John W. Colby
jwcolby at colbyconsulting.com
Wed Mar 16 07:37:36 CST 2005
>I did read that SQL Server Express 2005 would support more concurrent connections than MSDE 2000. Where and how many more? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Wednesday, March 16, 2005 7:29 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Access FE & MSDE BE? The last I heard was that SQL 2005 (and Express) would not support Access Data Projects. Still True? If so, what would be the best way to use SQL Server Express 2005 as the BE for an application using Access FE's? Any Pros/Cons or comparisons with other BE's? I did read that SQL Server Express 2005 would support more concurrent connections than MSDE 2000. Dan Waters ProMation Systems www.promationsystems.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Wednesday, March 16, 2005 3:14 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access FE & MSDE BE? Have a look at the new version http://www.microsoft.com/sql/express/ Martin ----- Original Message ----- From: "Stuart McLachlan" <stuart at lexacorp.com.pg> To: "Access Developers discussion and problemsolving" <accessd at databaseadvisors.com> Sent: Wednesday, March 16, 2005 1:47 AM Subject: RE: [AccessD] Access FE & MSDE BE? On 15 Mar 2005 at 19:26, Dan Waters wrote: > Is this correct? > > The 25 limit is not based on the number of people logged on, but on > the number of client computers concurrently connecting to the MSDE BE. > More can be logged on. > OK, I've just done it bit more searching. JC and I are both out of date with our 5. It's 8 in MSDE2000 http://msdn.microsoft.com/library/default.asp?url=/library/en- us/dnmsde2kwrk/html/msde2000webapp.asp <quote> MSDE 2000 employs what is known as a concurrent Workload Governor. The effect of the governor is to slow certain operations down by stalling user connections for a few milliseconds whenever there are more than eight concurrent operations. Some system-generated events in the database engine count against this eight-operation limit, so the governor may kick in even when your application code requests fewer than eight operations. The key is concurrent operations, such as executing a query. This is not the same as concurrent users. </quote> The supposed 25 limit (which appears to be an approximation of how many users before the slowdown becomes noticeable) comes from a number of different places including: http://www.microsoft.com/hk/sql/evaluation/overview/default.mspx <quote> SQL Server 2000 Desktop Engine (MSDE 2000) is a free, redistributable version of SQL Server. Third-party software developers can include it in applications they build that use SQL Server to store data. MSDE is an ideal solution for: Client applications that require an embedded database. Basic websites that serve up to 25 concurrent users. </quote> and http://www.microsoft.com/sql/msde/default.asp <quote> Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, redistributable version of SQL Server that's ideal for client applications that require an embedded database, new developers learning how to build data-driven applications, and Web sites serving up to 25 concurrent users. </quote> -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com