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 ↓

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Google account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

SQLDBPool – OLTP, OLAP, Big Data and NOSQL