Slow running query

Question

Post reply

Slow running query

ramuthoutu

Grasshopper

Points: 17
More actions
December 8, 2010 at 3:06 am

#388391

Hi guys,
One question, assume a stored procedure is having 10 operations and among them one causing to degrade the performance of the query.
How to find out the operation making to run the query slow?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

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

ramuthoutu Grasshopper Points: 17 More actions · Answer 2

ramuthoutu

Grasshopper

Points: 17

December 8, 2010 at 4:50 am

#1260007

Thank you...