SProc Optimization Tool
-
I'm looking for a 3rd party product that will evaulate stored procedures and provide optimization alternatives. I have seen an advert for it - I thought in one of the daily mailings from this site, but cannot find it.
Is anyone familiar with this tool - or any tool that evaluates TSQL and provides optimization recommendations.
-
There really is no substitute for learning this sort of thing for yourself, however, I think that Quest Central does what you are asking (although I can't say how well it does it)
In my humble
opinion you'd be better off getting a decent query optomisation book and spending some time with profiler and examining the query plans but I realise that not everyone has the time. All I can say is that it will make you a much better DBA than would otherwise be the case 
-
The Quest MS SQL tuning tool when you supply it with your SQL, will produce SQL statements that result in equivelent results and then execute each alternative against the data and measure execute time, writes & reads, and other performance measures. The DBA only has to select the SQL statement that provides the optimisation required.
The also have a database tuning tool that suggest table optimizations (indexs, etc) that will improve performance (I haven't tried this).
-
The Quest tool is the one I had seen, thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply