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 |
|
SqlAbc
Starting Member
1 Post |
 Posted - 2009-02-11 : 13:23:56
|
| Hello Experts,Our production database is running on SQL Server 2000. Once there was a open transaction that was left open for few days and the DBAs didnt notice it. Because of this the tempdb grown to the maximum leaving no free space in the harddrive. This created a lot of issues and the application was down for 30 minutes. Is there any preventive method to monitor this kind of issues in the production environment without affecting the performance ? Also let me know what are the other factors we need to be carefully monitoring in the production environment. Thanks & Regards,SqlAbc |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-11 : 14:44:18
|
| Simple Search will give you lots of valuable posts.Here is one of them,http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119436 |
 |
|
|
|
|
|
TempDB growth in Production server.