controling memory usage by SQL?

[nowayout]

Hi all,

How can in controll memory usage of SQL Server.?

Suggestion please. thanks

 

[MDXer]

In Server properties you can allocate the min and max memory values and also whether memory allocation is static or dynamic.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[ClaireHCM]

Followed what MDXer said.
You can modify the setting in Enterprise manager ,right click on Server name ,go to Memory tab where you can change setting

 

[wyldsider]

For those of us that are trying to do the same thing using MSDE, is there a MSDE solution involving SQL queries that could achieve the same result?

Jack De Winter
Software Developer
MedTel Software

http://www.medtel.on.ca