Post reply

QOD - RAM available to SQL 2000 Standard

  • June 30, 2003 at 1:01 am

    #159375

    I think there may be a problem here - my impression is that the limitation is per processor, so it could access up to 4 X 2GB on a 4 processor server...

  • June 30, 2003 at 4:38 am

    #463621

    Take a look here http://www.microsoft.com/sql/evaluation/overview/default.asp at the "Product SKU Matrix" under the section "Scalability".

  • June 30, 2003 at 5:44 am

    #463627

    Thanks

    When I look at the Memory tab of Server Properties in SQL Enterprise Manager, it looks as though I can allocate up to the full amount of memory on the server.

    I suppose that's just a bluff

  • June 30, 2003 at 7:47 am

    #463642

    Does this mean SQL Server Engine will use upto 2GB RAM for its usage and leave the excess memory for OS and other apps (if there is more than 2GB on server).

  • June 30, 2003 at 8:17 am

    #463654

    Yes, and this is actually true of any app. Unless the OS was booted with the /3GB switch or the /PAE switch and the app has been configured properly to use AWE memory, all applications are limited to 2 GB.

    The /3GB allows an app to expand to use 3 GB (provided there's memory available).

    The /PAE enables AWE. But an application still has to know how to use it and you've got to go through a few other steps.

    BTW, the /3GB switch only works properly in Advanced Server and Data Center Server (speaking of 2000 here). It'll appear to work in Server, but there's a KB article about it doing this for driver testing only.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply