This page requires JavaScript.
Help
Home
Personal
Services
Downloads
Links
Toolbox
Field Guide
Contact
Performance Quick-Check
Disclaimer
Webmaster
© 2006-2010, Jörg A. Stryk
Performance Quick-Check
Want to know if your database-server already has or causes
problems
? With the following selection of performance-indicators of the "
Windows Performance Monitors
" (
perfmon.exe
) you could find out quickly; insert your current values here:
Object
Indicator
Curr. Value
Result
(referring to Microsoft documents)
Memory
Available MBytes
Memory
Pages/sec
Physical Disk
Avg. Disk Read Queue Length
Physical Disk
Avg. Disk Write Queue Length
Processor
% Processor Time
System
Processor Queue Length
System
Context Switches/sec
Network Interface
Output Queue Length
SQL Server Access Methods
Full Scans/sec
SQL Server Access Methods
Page Splitts/sec
SQL Server Buffer Manager
Buffer Cache Hit Ratio
SQL Server Locks
Lock Waits/sec
SQL Server Locks
Number of Deadlocks/sec
NAV/SQL Performance Toolbox