Hejmo
Persono
Servicoj
BLOG-o
Ilujo
Magic 7
Gvidlibro
Kontakto
Elfaro Rapida Ĉeko
Datuma Protekto
© 2006-2020, Jörg A. Stryk
Elfaro Rapida-Ĉeko
Ĉu vi ŝatus scii, ĉu via datumbazo servilo jam havas aŭ kaŭzas
problemojn
? La sekva listo de agadaj indikiloj de la "
Windows Performance Monitor
" (
perfmon.exe
) helpas vin rapide determini tion; enigu viajn aktualajn valorojn:
Objekto
Indikilo
Akt. Valoro
Rezulto
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