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 |
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2008-04-21 : 11:16:36
|
I have a sql 2000 server which has 2GB RAM. Occassionally users get out of memory errors.I have set the min. server memory at 512MB, max at 1.8GB.So I would presume, that the SQL Server has at least 1.8GB available if needed.However the Available MB counter shows about 680MB.The Target Server memory shows as 580MBand Total Server memory ast 345MB.Of course, the Buffer Cache Hit Ratio consistently shows at 99%.Question is how come the available MB counter shows as 680MB?Am I missing something?Any help is welcome.PareshRegardsParesh MotiwalaBoston, USA |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-21 : 12:11:48
|
>> So I would presume, that the SQL Server has at least 1.8GB available if needed.Doubt it - the OS will be using memory and all the other things that happen to be runnning.SQL Server will use what's left - or what it can grab first which can cause problems.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2008-04-21 : 12:31:27
|
there is nothing running on the server other than SQL.RegardsParesh MotiwalaBoston, USA |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-21 : 14:23:12
|
Something else must be running on the server. How big is the database? Are you sure there aren't any maintenance jobs running? Run perfmon to see what else is consuming recources.Terry |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-21 : 22:12:21
|
OS, all kind of drivers, anti-virus tool or so need memory. |
|
|
|
|
|