Post reply

sql server 2000 an w2003 server

  • November 1, 2005 at 4:10 am

    #110300

    hello everybody,

    i 'm running sql server 2000 sp4 on w2003 server.

    Has anybody faces performance problems?? Is it better to use w2000 server instead of w2003 server?

    My sql server stop responding without error messages for a while and again and again.

    Thanks Nick

  • November 1, 2005 at 4:23 am

    #601507

    SQL Server 2000 should run just fine on Win2k3.

    Do you have any more information regarding the configuration of the server. Is there nothing all in the errorlog?

     

     

  • November 1, 2005 at 12:14 pm

    #601658

    Are you trying to take advantage of AWE memory?

  • November 2, 2005 at 9:31 am

    #601895

    W2003 supports more memory ( enterprise edition 32gb ) it also supports hyperthreading correctly and will allow 8 HT procs on enterprise ( total 16 procs )

    I've not had any probs with sp4 but note you need a patch if you're running awe.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • November 2, 2005 at 9:43 am

    #601902

    I was asking in reference to the patch for sp4.

  • November 3, 2005 at 3:11 am

    #602071

    You need an additional patch if you're using awe - only problems are if you don't apply the patch.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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