• MichaelJasson (7/2/2009)


    Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    You are not running Windows Vista on your server. You are, in fact, running Windows Server 2003 Enterprise Edition SP2. This is also running on x64 hardware so you don't have to worry about setting /3GB, /PAE or AWE.

    From what I have been able to see - it looks like your server has 32GB of memory. If you have not set a max of no more than 28GB of memory, your system is going to have problems. Is this a dedicated database server, or is it running other applications? If it is running other applications it is even more important that you set max memory.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs