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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-16 : 10:32:54
|
| John writes "Hi All,We have a product which when stress teested against sql server 7.0 sp2 , enterprise edition , odbc driver version 2000.80.194.00 running on nt 4.0 workstation with sp6, which runs successfully for approx 12 hours but after this it starts getting the below error frequently [Microsoft][ODBC SQL Server Driver][SQL Server]Could not perform the requested operation because the minimum query memory is not available. Decrease the configured value for the 'min memory per query' server configuration option. This value is currently 1024 as per the default.Our app over the said 12 hours increase in memory consumption upto a max of approx 50megs ( this is not a memory leak , just nature of test) , during this time sql server memory consumption decrease to approx 12 megs. There is 128 megs of RAm on the machine.Why would this be happening ? It appears that sql server is relinquishing memory to the point where it doesn't have enough to execute its queries.We will reduce the 1024 doen to 512 but surely this will just delay the error rather than solve it." |
|
|
|
|
|
SQl Error - Could not perform the requested operation because the minimum query memory....