November 28, 2012 at 9:16 am
Does any one know of a good 3rd part tool that can pull the top worst queries and provide suggestions on better optimizing them?
Thanks
November 28, 2012 at 10:16 am
Not sure about the optimizing, but I think Ignite (http://www.confio.com/performance/sql-server/ignite/#5) and Performance Advisor (SQL Sentry, http://www.sqlsentry.net/performance-advisor/sql-server-performance.asp#features) will help find poor queries.
November 28, 2012 at 10:34 am
Yes thanks we have that one, but our boos was looking for a second tool.
November 28, 2012 at 12:10 pm
Optimizing queries is more of an art form than a science. There are just way too many factors for any kind of automation to be able to optimize queries. The first step is finding the ones that need to be optimized. The tools mentioned do a good job of that. The second step is reworking the query. This is where is gets challenging.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 29, 2012 at 5:51 am
I have yet to see a third party tool that makes good recommendations for what to do about poor query performance. You can get some generic checks on the low-hanging fruit of stuff like missing ownership references and such, but this is only marginal improvements. For any given query, frequently, a pair of human eyeballs has to determine what's wrong. For the generic simple stuff, check out SQLCop[/url]. But it really isn't going to do what your boss is asking for.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply