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?
migrated from stackoverflow.com May 24 '11 at 0:10
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.
This is a very high level starting point and don't consider this as a final list though.