SQL Server Performance

SQL Server 2000 is much slower on Windows 2003 than Windows 2000. Any help?

Discussion in 'Performance Tuning for DBAs' started by waynezhang101, Feb 25, 2008.

  1. waynezhang101 New Member

    We just have a new computer with 20GB RAM with Windows 2003 Enterprise edition (32bit) and PAE configured for SQL Server 2000. The old one was Windows 2000 with 4gb ram. But SQL Server 2000 is much slower than the old one. SQL Server 2000 AWE is configured on the new one. Does any one have the similar case? any information will be appreciated. Thanks.
    waynezhang101, Feb 25, 2008
    #2

  2. satya Moderator

    satya, Feb 26, 2008
    #3

  3. mcosy New Member

    Hi,
    I think running on 64Bit Windows 2003 OS can use more Meomory and will help SQL 32 bit even with 2GB limitation?
    mcosy, Mar 5, 2008
    #4

  4. satya Moderator

    Bear in mind SQL 2000 SE is limited to 2GB by default only other editions can take such an advantage provided what refered in that links.
    satya, Mar 6, 2008
    #5

  5. waynezhang101 New Member

    We are using SQL 2000 Enterprise Edition plus AWE enabled.
    waynezhang101, Mar 6, 2008
    #6

  6. satya Moderator

    satya, Mar 7, 2008
    #7

Share This Page