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

How to do tempdb utilazation?? Expand / Collapse
Author
Message
Posted Friday, July 5, 2013 3:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 5, 2014 9:12 PM
Points: 8, Visits: 78
How to do tempdb utilazation in mssq; server ?
Post #1470634
Posted Friday, July 5, 2013 3:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
sqldbaonly (7/5/2013)
How to do tempdb utilazation in mssq; server ?


Has Google broken down in your country? I'm sorry, but you've been asking questions all morning of which most of them can easily be answered with a google search in some reading.

This is a forum, not a search engine.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1470636
Posted Friday, July 5, 2013 3:35 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:52 AM
Points: 7,107, Visits: 13,462
sqldbaonly (7/5/2013)
How to do tempdb utilazation in mssq; server ?


Write a query which utilises a spilling sort or hash


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1470639
Posted Friday, July 5, 2013 4:49 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 3:40 PM
Points: 786, Visits: 690
Take a look at sys.dm_db_task_space_usage

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1470661
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse