What are some ways I can constantly monitor and report on my production sql server so that I can determine where locks and performance improvements can be made?
|
feedback
|
migrated from stackoverflow.com May 24 '11 at 0:10
This question came from our site for professional and enthusiast programmers.
|
This is a very open ended question and the answer varies whom you talk to as there is so much that can be done. At a minimum, you should do the following.
http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
http://sqlblog.com/files/folders/release/entry35240.aspx This is a very high level starting point and don't consider this as a final list though. | |||
|
feedback
|