Thursday, October 8, 2009

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
Posted by at
Labels: ,

2 comments:

  1. IndrajeetApril 6, 2011 at 12:32 AM

    It is really much helpfull information about Memory Management.

    ReplyDelete
  2. IndrajeetApril 6, 2011 at 12:35 AM

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

    ReplyDelete

Subscribe to: Post Comments (Atom)