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 |
|
deepakmnair
Starting Member
4 Posts |
 Posted - 2005-12-19 : 03:25:45
|
| Hi,The SQL Server Database hangs overnight and also consumes high disk space on one of our servers. This has been recurring for quite a few weeks and occurs daily. Can somebody assist me in trouble-shooting the sameThanks in Advance Deepak |
|
|
surendrakalekar
Posting Yak Master
120 Posts |
Posted - 2005-12-19 : 04:37:29
|
| Few questions?1. Which SQL server and windows server you are using?2. All the SQL Server and windows patches are updated?3. How much disk space is free?Surendra |
 |
|
|
deepakmnair
Starting Member
4 Posts |
Posted - 2005-12-19 : 05:10:57
|
| SQL 2000 ENT Edition SP3Windows 2000 SP4 Advanced ServerFree Space ~3 GBI find that the disk space becomes quite less (in KBS) and the application as well as db stops responding, i believe backups are scheduled at nights, is there a way i can profile the same to be sure what is causing this,Also, i would like to know how can we commit the transaction log forcefully.. |
|
|
|
surendrakalekar
Posting Yak Master
120 Posts |
Posted - 2005-12-19 : 05:51:43
|
quote:
Originally posted by deepakmnair
I find that the disk space becomes quite less (in KBS) ...i believe backups are scheduled at nights,
If the backups are not scheduled is it working fine? If the virus scanner/removal s/w is installed just removed that. Check whether your server is having enough RAM. If it is enough it won't use that much of HDD space. There might be some other application/processes are running apart from backup.go through below links...this may be helpful for you...http://www.sql-server-performance.com/sg_sql_server_performance_article.asphttp://msdn2.microsoft.com/en-us/library/ms189081.aspxSurendra |
|
|
|
|
|
|
SQL Server Freezes : Consumes high Disk Space