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 |
|
Jaikanth_n
Starting Member
4 Posts |
 Posted - 2006-06-03 : 20:31:16
|
| 1.I'm running a time & memory consuming operation on SQL server 2000 (Bulk Copy from a big XML file). The box is Windows 2000 Advanced Server with 2GB RAM. SQL Server 2000 has SP 4.I'm getting the following error:-"Error: 17803, Severity: 20, State: 122006-06-02 18:20:30.13 spid53 Insufficient memory available.."I read several forums and learnt that adding /3GB switch in boot.ini file will make SQL Server recognize more than 2GB.But, since the box has only 2GB, does it may not make sense to add /3GB switch. Correct if I'm wrong.what else would be the solution?the worst part is sql server halts execution after this error, while some operations are still pending.2.I have another box which has the same settings (infact less RAM, ~1.5 GB RAM). this box performs exactly same operations as the above one, but finishes gracefully without givig me any error. Any clue why the above one errors out and not this one?Appreciate your help on these.ThanksJai |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-06-03 : 23:49:43
|
| I think you need to install the post SP4 hotfix rollup.here is the hotfix rollup package http://support.microsoft.com/?kbid=916287If you read that article you will see that any post Sp3 hotfix that is version 8.0.1000 or greater was not included in SP4. This article describes your error exactly, and it is build 8.0.1001 http://support.microsoft.com/kb/891719try installing the hotfix rollup and see if that takes care of your error.-ec |
 |
|
|
Jaikanth_n
Starting Member
4 Posts |
Posted - 2006-06-04 : 15:18:57
|
| interseting & useful. let me try this and get back to you.thanksJai |
|
|
|
Jaikanth_n
Starting Member
4 Posts |
Posted - 2006-06-04 : 21:44:32
|
| I installed the latest hot fix (8.00.2187) on sp4.Still the problem persists.Either I get the "Insufficient memory available..." error or the bulk copy succeeds, but other operations stop. (I have few bulk copys and few table update/inserts running together).One of these is affected. Rarely both succeed.Any help is appreciated.ThanksJai |
|
|
|
Jaikanth_n
Starting Member
4 Posts |
Posted - 2006-06-06 : 00:38:15
|
| Both my boxes are dedicated for running sql servers, have 2 cpus, parallel processing enabled on both. (though I'm not sure if parallel processing is being used!). I couldn't differentiate the 2 boxes.I tried to narrow down the probelm based on your thoughts. I supressed the bulk copy for the time being and I'm running everything else (other costly operations). These are executing successfully without any issues, even though its takes longer time. Performance is little slow here since the table is huge and a huge insertions/updates are happenning. Would a clustered index help here?Even if it is slow, It works! Now, I'm planning to handle the bulk copies separately. Now that I have isolated the bulk copy from other operations, I'm hoping this goes on well, too. I shall post the results soon.Let me know your thoughts. Thanks againJai |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-06-06 : 08:31:33
|
| Are there any errors in the event logs for the server itself when this happens? Also, see if you have any paging operations occurring when this is happening (performance monitor).MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
Error: 17803 : Insufficient memory available...