SQL Server Performance

Win2003EE & SQL2000EE memory split

Discussion in 'Performance Tuning for DBAs' started by twoboats, Jun 8, 2007.

  1. twoboats New Member

  2. thomas New Member

    For a standalone server [i.e. running nothing else but SQL Server] the OS will hardly need anything. I'd give SQL server 5GB of this.
  3. twoboats New Member

  4. MohammedU New Member

    Com object uses memory called MemToLeave (MTL) by default sql reserves 256 MB where as you can increase using -G switch as startup parameter...

    To allocate 1 GB to OS you have to use /3GB switch...

    How to configure SQL Server to use more than 2 GB of physical memory
    http://support.microsoft.com/kb/274750


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page