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: Monday, November 10, 2014 8:16 PM
Points: 250, Visits: 751
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: Tuesday, November 18, 2014 7:54 AM
Points: 317, Visits: 1,082
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: 2 days ago @ 7:42 AM
Points: 6,743, Visits: 8,515
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