RS First Dynamics NAV Blog

...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

SQL Performance analysis counters

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...
Categoria: Sql Server ALL
venerdì, 13 feb 2009 Ore. 15.27

Scrivi un commento

Non è possibile inviare commenti a questo Blog


Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003