August 11, 2008 at 12:53 pm
Guys,
I am trying to shrink tempdb which is up to 100gb by the following command, but it doesnt seem to release unused space.
dbcc shrinkfile (tempDEV, 100)
Also is there any way to find out all open cursors and close them which might also potentially contirbute to tempdb growth
Thanks
August 11, 2008 at 1:04 pm
If TempDB is full, then there isn't going to be any free space for shrink to release to the OS. You need to find out what's using the tempDB space first.
Any long running processes? Are you rebuilding indexes? Queries with large sorts? Anything like that?
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
August 11, 2008 at 1:05 pm
On the cursors questions, take a look at the system views. There are a set of them for cursors.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply