setup SQL max memory usage in registry

we have a third-party finance solution, along with a SQL server to support it.

I notice that the memory usage of SQL is getting bigger...
i remember I did the max memory for store.exe of our exchange server.
Is there a same way to setup the max memory limit for sqlservr.exe in the registry?
robinyanwangAsked:
Who is Participating?
 
YveauConnect With a Mentor Commented:
Just use the EM(2000)/SSMS(2005) to do that.
Connect to the server, right click the instance and go to the properties window.
There, find the memory tab and set the maximum server memory.

Hope this helps ...
0
 
YveauCommented:
Glad I could be of any help !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.