Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

Regards,

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: Tuesday, August 19, 2014 5:13 PM
Points: 3,462, Visits: 1,797
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...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:53 AM
Points: 42,822, Visits: 35,952
Cross post. Please continue discussions here


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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