Tuning poorly performing queries is one of the most important jobs of the DBA. With this in mind, this month’s qustion is “What tool(s) do you use to help you identify and tune slow performing queries?” This can include tools that come with SQL Server, your own custom-written scripts, or third-party tools. Tell us about the tools you use, and why you have chosen to use them.
Post your responses to the SQL Server Question of the Month in the comments section below (at www.bradmcgehee.com if you are viewing this from a syndicated newsfeed). And don’t forget to enter your e-mail address when you post your response, so I can contact you if you win.
Because there is no right or wrong answer, this month’s winner will be selected randomly from all the entries that are received.
This Month’s Prizes
|The prizes this month are an Amazon.com voucher worth US $50.00 and a license for the new SQL Monitor 3.0 (released during March), with one year of support and upgrades. SQL Monitor is a web-based monitoring and alerting tool which enables you to keep an eye on SQL server performance in real time on desktop machines and mobile devices. The new version will include custom metrics and alerts and new user roles. Try out a live demo of SQL Monitor now.|