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
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment