SQL Monitoring

• Linda_web

  SSC Enthusiast

  Points: 179

  More actions

  May 2, 2009 at 12:06 pm

  #204004

  Hi,

  I know I can monitor sql server from windows performance monitoring program,

  But really, I don’t understand how I read it or analyze it..

  I appreciate if someone can give link or explanation on step by step on how to analyze the performance and how to read it what I can do with it.

  Thanks in advance

• WayneS

  SSC Guru

  Points: 95460

  More actions

  May 2, 2009 at 12:10 pm

  #987742

  You might want to check out this recent article on this site: http://www.sqlservercentral.com/articles/Video/66675/

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  May 2, 2009 at 1:04 pm

  #987746

  Brent Ozar has a good blog post on how to collect and interpret perfmon counters.

  http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/