Posted by Marek Wierzbicki on 09/01/06 09:25

Hi

I have trouble with MSSQL2000 SP4 (without any hotfixes). During last two
weeks it start works anormally. After last optimalization (about few months
ago) it works good (fast, without blocks). Its buffer cache hit ratio was
about 99.7-99.8. Last day it starts work slow, there was many blocks and
dedlocks. There are no any queries, jobs and applications was added. Now
buffer cache hit ratio oscilate about 95-98. I try update statistics and
reindex some hard used tables, but there is no effect or effect is wery
short (after few hours problem return).

Mayby somene know what it could be?

Is it possible to estimate how each table (using DBCC SHOW_STATISTICS or
DBCC SHOWCONTIG or others) how the table affect on total buffer cache hit
ratio?

Marek

---
www.programowanieobiektowe.pl

• Next in forum: Re: estimation the buffer cache hit ratio
• Prev in forum: Create CUBE Roles automatically: Please help
• Thread view: estimation the buffer cache hit ratio

[Reply to this message]