SQL Server Performance

what and how to monitor a database

Discussion in 'Performance Tuning for DBAs' started by decipher, Feb 15, 2006.

  1. decipher New Member

    hi guys just wanted some expert advice on how and what to monitor when administering a sql database.I'm more into developing web application, now i just want to learn how to administer and monitor the performance of my database.

    please give advice what is critical that should be monitored and step how to monitor these things.

    TIA
  2. ghemant Moderator

    Hi,<br />you can monitoring a sql server with SQL Profiler ,and below are some links to read , and offcourse read articles on SSP.<br /><br /<a target="_blank" href=http://vyaskn.tripod.com/top_15_sql_server_books.htm>http://vyaskn.tripod.com/top_15_sql_server_books.htm</a><br /><br /<a target="_blank" href=http://vyaskn.tripod.com/sqlserverfaq.htm>http://vyaskn.tripod.com/sqlserverfaq.htm</a><br /><br /<a target="_blank" href=http://vyaskn.tripod.com/coding_conventions.htm>http://vyaskn.tripod.com/coding_conventions.htm</a><br /><br /<a target="_blank" href=http://vyaskn.tripod.com/sql_server_security_best_practices.htm>http://vyaskn.tripod.com/sql_server_security_best_practices.htm</a><br /><br /<a target="_blank" href=http://vyaskn.tripod.com/track_sql_database_file_growth.htm>http://vyaskn.tripod.com/track_sql_database_file_growth.htm</a><br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  3. decipher New Member

    thanks ghemant for the links..

Share This Page