How to change Min/Max Memory in SQL Server?

Step 1: Open SSMS

Step 2: Connect to desire Server and right click on the server (for i.e. sqldbpool) and Select properties

Memory1

Step 3: Click on memory tab and configure Min and Max memory

Memory2

2 thoughts on “How to change Min/Max Memory in SQL Server?”

Indrajeet April 6, 2011 at 7:32 am

It is really much helpfull information about Memory Management.

Reply ↓

Indrajeet April 6, 2011 at 7:35 am

Could you please give me some idea about, How to limit the usage of CPU in sql server 2005?

Reply ↓

aiDeeva.com