InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 18:24:50 GMT20http://www.sqlservercentral.com/Forums/Topic1382321-1550-1.aspxsys.dm_db_session_space_usageThu, 08 Nov 2012 09:13:37 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1382321-1550-1.aspxThanks Gail,Can you help me in identifying the processes using tempdb?? Some SSIS jobs running and its showing they are using user db.Thu, 08 Nov 2012 04:10:21 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1382321-1550-1.aspxIt'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.Thu, 08 Nov 2012 01:48:31 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1382321-1550-1.aspxHi 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.Thu, 08 Nov 2012 01:41:26 GMTRatheesh.K.Nair