STRYK System Improvement / Performance Quick-Check

Performance Quick-Check

Möchten Sie wissen ob Ihr Datenbank-Server bereits Probleme hat oder verursacht? Anhand der folgenden Auswahl an Performance-Indikatoren des "Windows Performance Monitors" (perfmon.exe) können Sie das schnell feststellen; tragen Sie Ihre aktuellen Werte ein:

Objekt	Indikator	Akt. Wert	Ergebnis
Memory	Available MBytes
Memory	Pages/sec
Physical Disk	Avg. Disk Read Queue Length
Physical Disk	Avg. Disk Write Queue Length
Physical Disk	Avg. Sec/Read
Physical Disk	Avg. Sec/Write
Physical Disk	% Disk Time
Processor	% Processor Time
Processor	% Privileged Time
Process	% Processor Time (SQL Server Instance)
Process	Page Faults/sec (SQL Server Instance)
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 Access Methods	Table Lock Escalations/sec
SQL Server Access Methods	Worktables created/sec
SQL Server Buffer Manager	Buffer Cache Hit Ratio
SQL Server Buffer Manager	Free Pages
SQL Server Buffer Manager	Page Life Expectancy
SQL Server Memory Manager	Memory Grants Pending
SQL Server Locks	Lock Waits/sec
SQL Server Locks	Lock Wait Time
SQL Server Locks	Number of Deadlocks/sec
SQL Server SQL Statistics	Batch Requests/sec
SQL Server SQL Statistics	Re-Compilations/sec