December 17, 2010 at 10:11 am
In trying to optimize database code, are there any tools that can go through all the stored procedures on the server and automatically build showplans that can help us identify table scans and inefficient queries? Could build an application to do this but I would hope something already exists for this type of functionality.
Any ideas on this??
December 17, 2010 at 10:20 am
Not a tool but at least a starting point.
A query and several links are provided here. The query shows how to query the plan cache specifically for missing indexes. You can use this query to retrieve the show plans from cache.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 20, 2010 at 6:09 am
Bill "Bojangles" Robinson (12/17/2010)
are there any tools that can go through all the stored procedures on the server and automatically build showplan that can help us identify table scans and inefficient queries?
there are certain queries available in sql 2005/2008. with the help of which you can work on on queries/SP one by one.if you concentrate on individual queries that can give you better results
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply