SQL Server Performance

SQL std on Win2k3 std

Discussion in 'Performance Tuning for Hardware Configurations' started by KoRnonthrCob, Jun 26, 2006.

  1. KoRnonthrCob New Member

    Sorry if this has been asked before, but I have found so many different answers.

    I have a windows 2003 std server with 4gb of memory. I am running SQL server 2000 std and I would like to use more than 2gb of memory.

    My question is does SQL server std support more than 2gb of memory?

    Thanks
  2. thomas New Member

    No - you need Enterprise Edition.
  3. KoRnonthrCob New Member

    Damn.

    So which is better, 2005 EE or 2000 EE my app can use both.
  4. thomas New Member

    2005 definitely. It's far better AND (here's the good bit) you can use standard edition of 2005, it'll address as much RAM as the OS. The limitation to 2Gb in Std Edition exists only in 2000, not 2005.
  5. thomas New Member

  6. KoRnonthrCob New Member

    Thanks for the info, one more question can I get SQL 2000 std to do parellel processing of quries? or is that limited as well?
  7. joechang New Member

    i believe so, up to the standard ed limit of 4 procs.

    of course, for sql 2000, i recommend careful analysis of each parallel execution plan,
    the general assumption should be that it is more likely to be questionable or outright negative unless proven positive.

    for sql sever 2005, it is mostly likely to be beneficial or at least not a negative.
    i have not found a 2005 parallel plan to be broken, but it is possible for a few unusual cases to be broken

Share This Page