«
»

How to change Min/Max Memory in SQL Server?

Posted by Jugal Shah on October 8, 2009


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

This entry was posted on October 8, 2009 at 4:07 pm and is filed under SQL Server. Tagged: . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

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

  1. Indrajeet said

    April 6, 2011 at 7:32 am

    It is really much helpfull information about Memory Management.

    Reply

  2. Indrajeet said

    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

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

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

Gravatar
WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Cancel

Connecting to %s

«
»
 
Follow

Get every new post delivered to your Inbox.

Join 175 other followers