RS First Dynamics NAV Blog

...from NAV 3.60 to NAV 2013
Archivio Posts
Anno 2015

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

SQL Performance analysis counters

SQL Performance analysis counters

The important perfmon counters are:

For disk/memory ->
memory: Available MB
memory: 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 SAN
physical disk: avg % idle time (for each disk)

For Sql ->
SQL Server Buffer manager: Buffer cache hit ratio
SQL Server Buffer manager: checkpoint pages\sec
SQL Server Buffer manager: Lazy writes\sec
SQL Server Memory manager: Total Server memory
SQL Server Memory manager: Target Server memory

most common waits (query sys.dm_os_wait_stats)

Categoria: Sql Server ALL
venerdì, 13 feb 2009 Ore. 15.27

Messaggi collegati

  • Views Home Page: 450.611
  • Views Posts: 862.660
  • Views Gallerie: 0
  • n° Posts: 343
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003