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

High Tempdb Usage Expand / Collapse
Author
Message
Posted Thursday, November 8, 2012 1:41 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:34 AM
Points: 2,609, Visits: 3,903
Hi Experts,

In one of our servers when some SSIS jobs are executed tempdb usage will become very high 1.99TB is reduced to 100GB in 7 Hours.

Is that normal if not what i need to check.
Post #1382321
Posted Thursday, November 8, 2012 1:48 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 43,016, Visits: 36,177
It's your server, you're the one who can tell if that's normal for your server.

If you feel that's excessive for your server, or you want to reduce it, investigate what's using TempDB and see if you can optimise them to use less TempDB space.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1382324
Posted Thursday, November 8, 2012 4:10 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:34 AM
Points: 2,609, Visits: 3,903
Thanks Gail,

Can you help me in identifying the processes using tempdb?? Some SSIS jobs running and its showing they are using user db.
Post #1382391
Posted Thursday, November 8, 2012 9:13 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 43,016, Visits: 36,177
sys.dm_db_session_space_usage


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1382563
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse