VMware Cloud Community
jrr001
Enthusiast
Enthusiast
Jump to solution

SQL 2005 memory usage in virtual

The "VMware Best Practices for SAP installations" document (http://communities.vmware.com/blogs/SAPsolutions/2008/01/18/vmware-best-practices-for-sap-installations) mentions the following:

6. If you are using SQL Server as the database, use "fixed memory allocation" to avoid the allocation overhead of "dynamic" memory allocation.

Is this true with SQL 2005 and how do you accomplish this?

Reply
0 Kudos
1 Solution

Accepted Solutions
Anders_Gregerse
Hot Shot
Hot Shot
Jump to solution

It should be the same in SQL 2000 and SQL 2005. SQL will allocate all the memory available. Using fixed memory is at good practice in some senarios like having all SQL components on one box (not all of the release memory very well). To change memory from dynamic to fixed, take properties on the server inside the SQL management tool and select the memory tab. Select fixed memory and select how much. (This is from own memory, I'm not sitting near any SQL at the moment).

View solution in original post

Reply
0 Kudos
1 Reply
Anders_Gregerse
Hot Shot
Hot Shot
Jump to solution

It should be the same in SQL 2000 and SQL 2005. SQL will allocate all the memory available. Using fixed memory is at good practice in some senarios like having all SQL components on one box (not all of the release memory very well). To change memory from dynamic to fixed, take properties on the server inside the SQL management tool and select the memory tab. Select fixed memory and select how much. (This is from own memory, I'm not sitting near any SQL at the moment).

Reply
0 Kudos