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, December 3, 2014 7:00 PM
Points: 251, Visits: 760
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: Yesterday @ 8:05 AM
Points: 320, Visits: 1,095
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: Tuesday, December 16, 2014 5:03 AM
Points: 6,748, Visits: 8,544
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