dmv, cache, perfmon, performance - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

SQL Server 2005 PERFMON counter spikes in Transactions/sec and Buffer Cache Hit ratio, what does it say? Published 14 March 8 4:16 AM | SSQA.net: Recently I was involved in one of the Performance Audit exercise at a client's place where they complain about Server CPU is always HIGH and what they have observed is even the physical disk where TEMPDB is located has been used extensively, as they...

Filed under: sql server, perfmon, performance, dmv, cache, buffer, sysmon, tempdb, monitoring, temp tables, worktables, workfiles, ratio

SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)