|
|
Posted by Erland Sommarskog on 01/14/08 08:29
Ed Murphy (emurphy42@socal.rr.com) writes:
> Erland Sommarskog wrote:
>> I would first analyse whether the problem is really due to that cache
>> having been flushed.
>
> How would I go about that? Profiler trace, looking for lots of cache
> misses during the early morning?
Those are cache misses for execution plans, not cache misses for data
buffers.
I will have to confess that I don't really have a recipe out of the
cookbook to offer, but one idea is to study the Buffer Cache Hit Ratio
performance counter. Sample both during day time, and in the wee hours
when the users are complaining.
There is also the DMV sys.dm_os_buffer_descriptors, which looks very
interesting on paper, but when I have used it, the results have not
appeared to be entirely reliable.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|