Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
movidiu
Starting Member
1 Post |
 Posted - 2008-10-31 : 03:07:00
|
| Hy , I am new in this forum , but i have some strange problem with the tempdb database witch is growing excessive. The database tempdb get all my space on the partition where the fizical files are located. The server is an SQL 2005 x64 an has 16 Gb of RAM, and he has all the patch. Can I, in some way to detect which store procedure or SQL statemant generate this anomaly. The problem is that the tempdb become big, then the used space from the tempdb become very small but the alocated database size remain the same (ex. 28 GB ) . Thanks in Advance. |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-10-31 : 07:52:40
|
| http://articles.techrepublic.com.com/5100-10878_11-6128110.html |
 |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-31 : 09:11:45
|
| If Tempdb activity is high make sure you have multilpe tempdb files (general rule-as many as cpu cores) Check this whitepaper on Tempdb http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-31 : 10:58:16
|
| Enabling 'Lock pages in Memory' also solves the issue for 64 bit server if TempDb is growing unexpectedly. |
|
|
|
|
|
|
Problem with "tempdb"