Post reply

Windows Server 2003 w/4GB RAM /3GB switch, running SQL2000 Enterprise

  • November 4, 2005 at 9:08 am

    #110308

    Hello,

    We've been having soporadic performance problems with a server that seems to resolve itself when the SQL service is restarted, or the server is rebooted.  We've looked at all the obvious stuff, SPIDS, bad queries, blocks, locks, etc...

    One person mentioned that they thought they heard that running SQL Enterprise with 3+GB RAM on Win2003 Standard Edition using the 3GB switch is a bad thing.  Has anyone come across this?

    Regards,

    Brent

  • November 4, 2005 at 1:27 pm

    #602456

    You are running SQL Server 2000 with what Service pack?

  • November 4, 2005 at 1:31 pm

    #602460

    I'm running SQL 2000 Ent SP3a

  • November 4, 2005 at 1:49 pm

    #602465

    Can you elaborate on the performance problems you are having (CPU/Memory)?

  • November 7, 2005 at 12:46 am

    #602551

    One person mentioned that they thought they heard that running SQL Enterprise with 3+GB RAM on Win2003 Standard Edition using the 3GB switch is a bad thing. Has anyone come across this?

    No, there is no 'general' problem with that. Please describe your problem a little more. Do you get anything interesting in the error log, or Windows Eventviewer? Are you using linked servers, COM objects (with sp_OA*) or some extended procs a lot?

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • November 7, 2005 at 2:52 pm

    #602693

    Do you use sp_XML_xxx stored procedure a lot? If you have memory leak, the server will be getting slower.

     

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

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