April 20, 2012 at 9:19 am
Good Morning To All 🙂
i would like to ask if there is a 3rd party tool that we can use to measure the Execution of a Stored Procedure. and would point which part of the SP is causing the performance issue? and at the same time will suggest possible code change to the user to correct the Performance issue?
Thank you very much !
April 25, 2012 at 9:41 am
Good Morning To All,
I would like to ask if there is A Tool Besides SQL Profiler that can measure the performance of a certain stored procedure? any advise/help from you guys is very much appreciated.
Best Regards,
Noel Eman Isip
April 25, 2012 at 9:47 am
I currently use Confio Ignite to do that. I'm doing some testing on Quest Performance Analyzer to see if it works better for what I need on that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 25, 2012 at 9:49 am
You might also look at SQLSentry's PErformance Advisor. Not sure if it does what you want, but it can be helpful in analyzing issues.
No matter which tool you use, ultimately it pays to spend some time learning to write better T-SQL. We have lots of articles here, and authors are willing to help you understand how their techniques improve the execution of the code.
April 25, 2012 at 10:58 am
Thank you guys so much for the help. i would be needing these tools to rewrite the SP's that is running slowly here in our company. i am barely a week in here and would need to take a look at almost all the SP's that has some perf issues.
Much Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply