Database Performance

• su_kumar11

  SSCommitted

  Points: 1675

  More actions

  November 4, 2009 at 5:43 am

  #216439

  Hi,

  Can anyone can tell me that how to check database performance in sql server.

  Thanks,

  Sunil Kumar

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  November 4, 2009 at 7:32 am

  #1074802

  Perfmon is one method to monitor Server performance for various SQL Server counters.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• 465789psw

  Hall of Fame

  Points: 3314

  More actions

  November 5, 2009 at 9:06 am

  #1075425

  This will get you started

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