Post reply

SQL Server 7 memory problem

  • July 30, 2003 at 5:12 am

    #58713

    I have SQL 7 standard edition running on windows 2000 advanced server with 4 GB of ram and 4 processors. SQL Server is configured to use 2 GB (max allowed with this configuration?). But SQL SERVER only uses max of 1.7 GB; does anyone know why the other 0.3 GB is not being used?

    I'm getting paging but SQL server shows 0.3 GB of memory free.

    Thanks for any help you can offer.

  • July 30, 2003 at 6:36 am

    #467705

    How large are your database? How heavy has the paging happened? Are you sure the paging is being caused by SQL Server?

  • July 31, 2003 at 11:46 am

    #468065

    We had the same issue with the same setup. You need to add the /3GB switch in the boot.ini file, and then set the maximum memory to 2 GB in the SQL Server properties dialog box. Please note that the /3GB switch requires a reboot to take effect.

Viewing 3 posts - 1 through 2 (of 2 total)

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