SQL Performance analysis counters The important perfmon counters are: For disk/memory -> memory: Available MBmemory: Pages/sec For disks ->physical disk: avg sec/read (for each disk)physical disk: avg sec/write (for each disk)physical disk: avg disk queue length (for each disk) Not really meaningful on a SANphysical disk: avg % idle time (for each disk) For Sql ->SQL Server Buffer manager: Buffer cache hit ratioSQL Server Buffer manager: checkpoint pages\secSQL Server Buffer manager 
Leggi tutto il post...