[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

setup SQL max memory usage in registry

Posted on 2007-10-02
2
Medium Priority
?
951 Views
Last Modified: 2012-08-14
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?
0
Comment
Question by:robinyanwang
  • 2
2 Comments
 
LVL 18

Accepted Solution

by:
Yveau earned 750 total points
ID: 20002199
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
 
LVL 18

Expert Comment

by:Yveau
ID: 20129960
Glad I could be of any help !
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question