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

need top 20 stored proc which used tempdb most of all Expand / Collapse
Author
Message
Posted Friday, July 13, 2012 5:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 6:30 AM
Points: 250, Visits: 743
Dear All,

How we can find top 20 stored proc which used tempdb most of all?

Please advice me.

Thanks and Regards,
Ravi.
Post #1329357
Posted Friday, July 13, 2012 5:12 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 9:43 AM
Points: 316, Visits: 1,022
Is this any help?

http://www.sqlservercentral.com/Forums/Topic1050299-1550-1.aspx#bm1051487
Post #1329362
Posted Friday, July 13, 2012 5:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:34 PM
Points: 6,997, Visits: 8,409
have a look at Roberts blog : http://www.sqlsoldier.com/wp/sqlserver/breakingdowntempdbcontention

that is if you're looking for contention issues.

Anther place to start can be :
http://www.sqlservercentral.com/Forums/FindPost1050355.aspx


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1329366
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse