Differences between MSDE and SSE2005 RRS feed

  • Question

  • Good Afternoon, Everyone.

    I know SSE2005 is built on Sql Server 2005 and MSDE was built on Sql Server 2000 so let's not start a thread discussing that.

    My question is more about the concurrency governor found in MSDE. I've heard people talking about the concurrency governor in MSDE being removed in SSE2005. Instead, performance is limited by the server configuration; one CPU, 1 GB RAM, and a maximum 4GB database. Can anyone confirm this?

    What happens if the server has 2GB of RAM and/or dual processors? Will SSE only utilize 1 GB and/or one of the processors? 

    Thanks for the help,

    Sunday, April 30, 2006 7:06 PM


All replies