October 24, 2007 at 4:00 am
Hi Friends,
my application is getting very slow performance.:D
Because sql server not responding properly in particular case like run some big query.
Can u any tell me how we can identify the particular query is working fine or not.
i am using sql server profiler. its shows duration of TSQL. 😀
If we know using sql server profiler duration means
What is the maximum response duration for TSQL Query?:D
Regards,
Kiruba sankar.S
🙂
October 24, 2007 at 8:57 am
I'm not entirely sure what you are asking, however in general if you are doing performance tuning like that you can take the Profiler results and store them into a table then sort by duration. Anything that consistently takes too long you need to look at more carefully. A lot of times performance issues are bad joins or missing indexes. Also you could try running the Database Engine Tuning Advisor.
Kenneth Fisher
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 25, 2007 at 12:56 am
Cross post. Please continue discussions here
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply