Differences between MSDE and SSE2005

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,
Scott

You assumptions are all right.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Jens is right, see here for more background,

http://blogs.msdn.com/euanga/archive/2006/03/09/545576.aspx

|||

Thanks for the info!

How about the second part of the post? What happens is I attempt to use SSE on a box with multiple processors or more than 1GB of RAM? Will it install? Will it run but limit itself to a single processor and ignore any RAM over 1GB?

Thanks,
Scott

|||It will ignore additional hardware.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Excellent. Thank you...

Scott