how much of RAM sql server utilies??

[p10]

I have changed my RAM from 128 to 256 thinking that SQL SERVER 7 uses atleast of 90 to 100 MB of RAM. But now, after installing 256 it takes almost of 210MB. How can I make it to minimun use???

 

[moonshadow]

SQL 7 will more or less take as much memory as you give it in an attempt to improve it's performance. However, you can limit the amount of memory it takes. In Enterprise Manager, right click your server, select properties, select the Memory tab, and adjust the maximum setting to something you're comfortable with. Are there any particular reasons why you don't want SQL 7 to have as much memory as it wants - it's generally pretty good at tuning itself ? Are you perhaps running something else on the server ?

 

[p10]

I want because when there is any updation that there is no RAM left to process it as it get Time Out Problem.

 

[moonshadow]

Sorry, but I can't quite understand your English. If you're having TimeOut problems, it's nothing to do with RAM