Just be aware that you need to poll those values into a table & query the delta between samples, as SQL Server continually increments the counters throughout the...
IO problems can definitely occur without disk queuing. This is easy to understand when you take into consideration the fact that SQL Server has an internal workload scheduling component -...
SQL Server 2000 Standard Edition has a hard wired memory limit of 2Gb, whether it's running under an x64 or x86 O/S. SQL 2000 Enterprise Edition does not have...