May 1, 2010 at 3:00 pm
Hello
I am looking for a software that will check (analyse) my stored procedures and tells me if there is missing index on tables, or if the stored proc is slow or anything else.
I am using SQL Server 2005 Express
Is there such a software? A free one would be really nice.
thank you
Martin
May 3, 2010 at 5:32 am
dubem1-878067 (5/1/2010)
HelloI am looking for a software that will check (analyse) my stored procedures and tells me if there is missing index on tables, or if the stored proc is slow or anything else.
I am using SQL Server 2005 Express
Is there such a software? A free one would be really nice.
thank you
Martin
for Missing indexes use DTA (sql tool) or DMV views ( google them )
and for slowness, use execution plan
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply