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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by
on
Fri, Mar 14 2008
Filed under:
Filed under: sql server, perfmon, performance, dmv, cache, buffer, sysmon, tempdb, monitoring, temp tables, worktables, workfiles, ratio