Performance- Buffer Manager:Page Lookups/Sec

We have a BI app that were testing, running many different reports. Under
some conditions the Buffer Manager:Page Lookups/Sec counter spikes very
high. I was wondering if this normal behaviour, and if not, what can be
done to ameliorate it.
Thanks in advance
Not sure if you know this or not, but the page lookups/sec counter is:
Number of requests to find a page in the buffer pool.
So depending on what you are doing this could be normal. It appears that you
are retrieving data and SQL Server first trying to find the data in the
memory.
HTH,
DeeJay Puar
MCDBA
"MAS" wrote:

> We have a BI app that were testing, running many different reports. Under
> some conditions the Buffer Manager:Page Lookups/Sec counter spikes very
> high. I was wondering if this normal behaviour, and if not, what can be
> done to ameliorate it.
> Thanks in advance
>
>

Performance- Buffer Manager:Page Lookups/Sec

We have a BI app that were testing, running many different reports. Under
some conditions the Buffer Manager:Page Lookups/Sec counter spikes very
high. I was wondering if this normal behaviour, and if not, what can be
done to ameliorate it.
Thanks in advanceNot sure if you know this or not, but the page lookups/sec counter is:
Number of requests to find a page in the buffer pool.
So depending on what you are doing this could be normal. It appears that you
are retrieving data and SQL Server first trying to find the data in the
memory.
HTH,
DeeJay Puar
MCDBA
"MAS" wrote:

> We have a BI app that were testing, running many different reports. Under
> some conditions the Buffer Manager:Page Lookups/Sec counter spikes very
> high. I was wondering if this normal behaviour, and if not, what can be
> done to ameliorate it.
> Thanks in advance
>
>

Performance- Buffer Manager:Page Lookups/Sec

We have a BI app that were testing, running many different reports. Under
some conditions the Buffer Manager:Page Lookups/Sec counter spikes very
high. I was wondering if this normal behaviour, and if not, what can be
done to ameliorate it.
Thanks in advanceNot sure if you know this or not, but the page lookups/sec counter is:
Number of requests to find a page in the buffer pool.
So depending on what you are doing this could be normal. It appears that you
are retrieving data and SQL Server first trying to find the data in the
memory.
HTH,
DeeJay Puar
MCDBA
"MAS" wrote:
> We have a BI app that were testing, running many different reports. Under
> some conditions the Buffer Manager:Page Lookups/Sec counter spikes very
> high. I was wondering if this normal behaviour, and if not, what can be
> done to ameliorate it.
> Thanks in advance
>
>sql

Performance - SQLServer:Buffer Manager Free pages

Hi
Envinnment : Windows 2003 SQLServer 2000 sp3 with AWE enabled
While performance monitoring in the low peak time, I saw the SQLServer:
Buffer Manager - Free pages = 1768 and came down till 500 and back to 1398.
I gathered form sysperfinfo the following
Buffer Cache database pages 8360 MB
Free pages 10 MB
Procedure Cache Allocated 1377 MB
Is any thing wrong with Buffer Manger? because of free space came down? Is
there any lower limit for free pages?
Thanks for looking this issue
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200510/1sorry to add total memory . 12GB
Dedicated to SQL = 10.5 GB
kpxus wrote:
>Hi
>Envinnment : Windows 2003 SQLServer 2000 sp3 with AWE enabled
>While performance monitoring in the low peak time, I saw the SQLServer:
>Buffer Manager - Free pages = 1768 and came down till 500 and back to 1398.
>I gathered form sysperfinfo the following
>Buffer Cache database pages 8360 MB
>Free pages 10 MB
>Procedure Cache Allocated 1377 MB
>Is any thing wrong with Buffer Manger? because of free space came down? Is
>there any lower limit for free pages?
>Thanks for looking this issue
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200510/1|||Hi
To use the Buffer Cache Hit Ratio.
I use that along with SQLServer:MemoryManager\Total Server Memory(KB)
and SQLServer:MemoryManager\Target Server Memory(KB). Total and Target
values should be equal.
Target should never be higher than Total. Target is how much SQL
Server would like to use and Total is how much it currently has.
HTH
From
Doller|||Total and target memory are same 10.506 MB
doller wrote:
>Hi
>To use the Buffer Cache Hit Ratio.
>I use that along with SQLServer:MemoryManager\Total Server Memory(KB)
>and SQLServer:MemoryManager\Target Server Memory(KB). Total and Target
>values should be equal.
> Target should never be higher than Total. Target is how much SQL
>Server would like to use and Total is how much it currently has.
>HTH
>From
>Doller
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200510/1

Perfmon SQL Server counters not appearing in list for saveds counter log.

Hi,
I set up a counter log to record SQL data in perfmon. This included a
few O/S counters and
SQL Server:Buffer Manager/Buffer Cache Hit Ratio
SQL Server:General Statistics/User Connections
I am now trying to look at the data through Perf Mon on the same
machine. However I can only add O/S counters to the view. The SQL
Server counters don't appear in the list.
Any ideas?
Cheers,
JamesHi James
"JimLad" wrote:
> Hi,
> I set up a counter log to record SQL data in perfmon. This included a
> few O/S counters and
> SQL Server:Buffer Manager/Buffer Cache Hit Ratio
> SQL Server:General Statistics/User Connections
> I am now trying to look at the data through Perf Mon on the same
> machine. However I can only add O/S counters to the view. The SQL
> Server counters don't appear in the list.
> Any ideas?
> Cheers,
> James
I assume this is opening the log file? In which case I suspect the counters
weren't collected. Are the counters available if you try to add them to the
system monitor?
If you are on a 64 bit server are you running the correct version of perfmon?
John|||On Jul 9, 1:28 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi James
>
>
> "JimLad" wrote:
> > Hi,
> > I set up a counter log to record SQL data in perfmon. This included a
> > few O/S counters and
> > SQL Server:Buffer Manager/Buffer Cache Hit Ratio
> > SQL Server:General Statistics/User Connections
> > I am now trying to look at the data through Perf Mon on the same
> > machine. However I can only add O/S counters to the view. The SQL
> > Server counters don't appear in the list.
> > Any ideas?
> > Cheers,
> > James
> I assume this is opening the log file? In which case I suspect the counters
> weren't collected. Are the counters available if you try to add them to the
> system monitor?
> If you are on a 64 bit server are you running the correct version of perfmon?
> John- Hide quoted text -
> - Show quoted text -
Hi John,
Yes, I am opening the log file. And yes they are available in Sys Mon.
It's a virtualised 32bit server I believe (Intel Xeon 3.2GHz).
As for perfmon version I'm just using the one in Administrative Tools.
So, I definitely put the counters in the log. Why haven't they been
recorded? I notice there is something about objects as well. I only
put the individual counters in. Do I need to put the whole SQL Server
object in?
Cheers,
James|||Hi James
"JimLad" wrote:
> On Jul 9, 1:28 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > Hi James
> >
> >
> >
> >
> >
> > "JimLad" wrote:
> > > Hi,
> >
> > > I set up a counter log to record SQL data in perfmon. This included a
> > > few O/S counters and
> >
> > > SQL Server:Buffer Manager/Buffer Cache Hit Ratio
> > > SQL Server:General Statistics/User Connections
> >
> > > I am now trying to look at the data through Perf Mon on the same
> > > machine. However I can only add O/S counters to the view. The SQL
> > > Server counters don't appear in the list.
> >
> > > Any ideas?
> >
> > > Cheers,
> >
> > > James
> >
> > I assume this is opening the log file? In which case I suspect the counters
> > weren't collected. Are the counters available if you try to add them to the
> > system monitor?
> > If you are on a 64 bit server are you running the correct version of perfmon?
> >
> > John- Hide quoted text -
> >
> > - Show quoted text -
> Hi John,
> Yes, I am opening the log file. And yes they are available in Sys Mon.
> It's a virtualised 32bit server I believe (Intel Xeon 3.2GHz).
> As for perfmon version I'm just using the one in Administrative Tools.
> So, I definitely put the counters in the log. Why haven't they been
> recorded? I notice there is something about objects as well. I only
> put the individual counters in. Do I need to put the whole SQL Server
> object in?
> Cheers,
> James
If they are in the file it should be ok or the file is somehow corrupt. You
should not need to include anything other than the specific counters. Try
doing a new one with just one of the counters and see what happens.
You could try importing the file into SQL 2005 profiler it you have a
corresponding profile.
John|||On Jul 9, 12:52 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi James
>
>
> "JimLad" wrote:
> > On Jul 9, 1:28 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > > Hi James
> > > "JimLad" wrote:
> > > > Hi,
> > > > I set up a counter log to record SQL data in perfmon. This included a
> > > > few O/S counters and
> > > > SQL Server:Buffer Manager/Buffer Cache Hit Ratio
> > > > SQL Server:General Statistics/User Connections
> > > > I am now trying to look at the data through Perf Mon on the same
> > > > machine. However I can only add O/S counters to the view. The SQL
> > > > Server counters don't appear in the list.
> > > > Any ideas?
> > > > Cheers,
> > > > James
> > > I assume this is opening the log file? In which case I suspect the counters
> > > weren't collected. Are the counters available if you try to add them to the
> > > system monitor?
> > > If you are on a 64 bit server are you running the correct version of perfmon?
> > > John- Hide quoted text -
> > > - Show quoted text -
> > Hi John,
> > Yes, I am opening the log file. And yes they are available in Sys Mon.
> > It's a virtualised 32bit server I believe (Intel Xeon 3.2GHz).
> > As for perfmon version I'm just using the one in Administrative Tools.
> > So, I definitely put the counters in the log. Why haven't they been
> > recorded? I notice there is something about objects as well. I only
> > put the individual counters in. Do I need to put the whole SQL Server
> > object in?
> > Cheers,
> > James
> If they are in the file it should be ok or the file is somehow corrupt. You
> should not need to include anything other than the specific counters. Try
> doing a new one with just one of the counters and see what happens.
> You could try importing the file into SQL 2005 profiler it you have a
> corresponding profile.
> John- Hide quoted text -
> - Show quoted text -
James,
This just happened to me last week. In my case, I could see the all
counters except for SQL Server counters (Availible memory, buffer
etc). It was a permissions issue. You can "run as" and when I changed
to administrator of the box who has sa access, they appeared.
Hope this helps.
Kristina