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 |
|
phantos
Starting Member
1 Post |
 Posted - 2007-11-15 : 13:24:49
|
| We have a live asp website which logs activity to a SQL 2000 database. This works fine for a while, but after a week or two the logging program hangs with a timeout, and SQL server will not allow any more records to be written.When this happens, we cannot write records to the database from our website or from Query Analyzer.We've looked in SQL Enterprise Manager but can't find any likely explanation - no locks or anything.What can we do that will allow us to diagnose the problem? We would like SQL Server to tell us why it won't write any more records to the database.When this problem happens we need to get the site back up and running within a few minutes, so our window of opportunity to investigate the problem is limited. Therefore we want to be pre-prepared!In the past we have re-started SQL Server (usually works) or re-booted the machine to get it up and running - the problem with this is that all evidence is then destroyed and we are no closer to solving the problem.Thanks for your help... |
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-11-15 : 13:32:46
|
| It happens if there is an autogrowth.Say, your database is 1Gb and autogrowth is 10%When SQL runs out of space, it stops, allocated 100Mb, "formats" that space and then continues.All that time it can not "insert records" |
 |
|
|
|
|
|
SQL Server Stops Writing Records