How to change Min/Max Memory in SQL Server?

Written by

Jugal Shah

in

,

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

Comments

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

  1. Indrajeet Avatar
    Indrajeet

    It is really much helpfull information about Memory Management.

    Reply
  2. Indrajeet Avatar
    Indrajeet

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

    Reply

Thanks for the comment, will get back to you soon… Jugal Shah

More posts