Post reply

Max Memory on Enterprise Manager

  • August 21, 2003 at 3:57 am

    #162343

    Hi,

    How do i "refresh" the enterprise manager of sql2000 to reflect the "actual" max memory configured, i configured the max memory to 3GB it's shown on sp configure, but i only see 2GB max on the properties of enterprise manager for that server?

    Thanks

  • August 21, 2003 at 8:25 am

    #470782

    Which version of SQL Server do you run?

  • August 21, 2003 at 9:42 pm

    #470903

    Hi Allen,

    I am running SQL2000 EE, and windows 2000 advance version. I have max 2 GIG physical RAID5. I need to rephrase my question as i have figured certain things out.

    Based on my spec above, and the machine is dedicated to sql 2000, i have set

    my min memory to 0 and MAX memory to the default value which is 21........ i forgot.

    I supposed that's the best. Are there any more fine tuning i can do to the sql server options?

    I also need some advice on what performance indicator can i use on perfmon to monitor the performance of sql2000

  • August 22, 2003 at 7:05 am

    #470963

    Can you post the result of sp_configure?

    To see more performance tuning tips, go to http://www.sql-server-performance.com/

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

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