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 |
|
lbusuioc
Starting Member
4 Posts |
 Posted - 2006-11-16 : 17:14:03
|
| I have couple of SQL Server 2000 databases, each of them having the size around 200GB.Recently I started experiencing some problems while inserting/updating data.The problem is that it seems like it just hangind and it never finish the insert/update. I tried a simple update that affects just few records and it still hangs without any reason. There is no process locking the update process.If I go to the database properties and increase the size of the database and then perform the update/insert all works well. My databases are set for unlimited growth , 10% file growth. I have plenty of space free on the disk.In any case, it looks like it is not able to grow by itself.I use SQL Server 2000, Enterprise Edition. I would appreciate your help. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-16 : 17:16:52
|
| How long does it take when you increase the size? Is the update/insert really hanging or just taking a long time because the database is busy growing by 20GB when you perform the insert/update? |
 |
|
|
|
|
|
update/insert hanging