Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

TSQL by Duration(Respone Time) Expand / Collapse
Posted Wednesday, October 24, 2007 4:00 AM


Group: General Forum Members
Last Login: Wednesday, July 13, 2011 10:24 PM
Points: 18, Visits: 46
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. :D

If we know using sql server profiler duration means

What is the maximum response duration for TSQL Query?:D


Kiruba sankar.S

Post #414296
Posted Wednesday, October 24, 2007 8:57 AM

Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, December 2, 2016 10:54 AM
Points: 3,486, Visits: 2,016
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 Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
For better, quicker answers on T-SQL questions, click on the following...
For better answers on performance questions, click on the following...

Link to my Blog Post -->
Post #414479
Posted Thursday, October 25, 2007 12:56 AM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #414794
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse