How does SQL Server 2005 Express compare to MSDE?
Updated: 6/20/2008 12:25:00 AM Requests: 8811 SQL Server 2005 is the successor to MSDE. It will still be free, it will still be distributable, and licensing (so I hear) will be much simpler. There will no longer be a workload governor. In MSDE, performance was throttled when more than five user workloads were running at the same time. Many people thought this was a five user *connection* limitation, but this was never the case. The engine would not refuse additional connections, nor would it throttle performance when there were more than five idle connections. See this article on The SQL Server 2000 Workload Governor for more information, but be confident that there is no such technology present in SQL Server 2005 Express Edition.
Related Questions
- After ProMax 3.0 installs Microsoft SQL Server Express SP3, my Windows XP/SP2 system experiences the blue screen of death (BSOD) or repeated restarts. How do I resolve this problem?
- Is the latest SQL Server 2005 Express service packs and security installed?
- Can the Microsoft SQL Server Desktop Engine (MSDE) be installed manually?
