February 1, 2006 at 3:10 pm
im going into the optimization phase of the application, and i wonder if there is a tool , or maybe a script
to automatically compare a stored procedure before and after a modification, for the IO reads/writes, duration,
cpu used etc.
i know that usually optimisations can be seen in the duration of the procedures, but i want to see the smallest changes in the performance of a sp.
February 2, 2006 at 3:55 am
I know there are several SQL tuning tools out there that do a nice job of this. I saw a webinar from Quest software on their tool. It will show you the stats before & after you tune a SP. Embarcadero has the same kind of tool. I believe it is called Rapid SQL.
John
February 3, 2006 at 7:58 am
The Quest tool is called SQL Tuning. I saw a webinar on it as well. It's included as part of their Quest Central for SQL Server package.
February 4, 2006 at 4:57 pm
thanks, it looks exactly what i need
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply