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 |
|
Rame
Starting Member
2 Posts |
 Posted - 2008-07-21 : 15:09:29
|
| How can we handle tempdb full situation?Steps to solve the problem? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-07-21 : 15:28:27
|
I've got to admit, Tara's second item can be critical. I've seen end users TRY and create a query within the application (PeopleSoft in my case) and through their inexperience and lack of knowledge about the table relationships\keys, totally bring SQL server to it's knees. The only option we had was to restart SQL, which recreated tempDB. Immediately after the restart was complete, we began restricting which users had query access.  Terry |
 |
|
|
|
|
|
Tempdb full situation handling