Derek, While MSDE (SQL Server 2000) has a performance governor on it, SQL Server 2005 Express (the version Paul is asking about) does not. They also raised the database size limit to 4GB from 2GB. One thing in MSDE not in SQL Server 2005 is the SQL Agent used to schedule things like backups.
Rick White Light Computing, Inc. www.whitelightcomputing.com www.rickschummer.com 586.254.2530 - office 586.254.2539 - fax -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derek Kalweit Sent: Friday, October 27, 2006 09:57 AM To: [EMAIL PROTECTED] Subject: Re: Anyone used SQL Express? > Performance is really no different than the full version. I have 5 > systems out there with 4 users on each server and the performance is > more than adequate. Indeed. MSDE is just as powerful as SQL Server as far as the query engine goes, etc. The only difference performance-wise is a built-in throttle/semaphore that prevents more than 5 queries from executing simultaneously. You'll see notes about this in the event log if you hit it. For many DB network apps(which don't have constant DB queries) with 1-10 network users, you can still use MSDE without a problem. -- Derek [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
