May 9, 2013 at 4:58 am
Here in my sql server Temp db is full and there is no disk space
so here we are going to shrink the temp db but it is not working
we don't have the another disk
here i want to find out the global variables and stored procedures and kill them
How to find out
May 9, 2013 at 8:01 am
You can not get your space back on that way.
The only way I know is that you have to restart SQL server services. But You really have to read BOL about TempDB management.
I will recommend you start from here.
May 9, 2013 at 9:24 am
Here is a link which will allow you to find out what's using tempdb.
http://msdn.microsoft.com/en-us/library/ms176029(v=sql.105).aspx
May 9, 2013 at 10:30 am
No such things as global variables.
Use the task space usage and session space usage DMVs to identify what's using lots of TempDB and tune the queries so that they don't use so much. You may also just need more TempDB space.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 10, 2013 at 3:07 am
please provide the dmv's
May 10, 2013 at 3:14 am
I gave you more than enough to look in Books Online....
sys.dm_db_task_space_usage and sys.dm_db_session_space_usage
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply