April 19, 2007 at 10:50 am
Is there a connection limitation if using sql express? Also, is sql express recommended for use with an application that is sending about 60 or so transactions per minute over 18 or 20 connections from about 7am to 8 pm daily?
A vendor is considering trying to run this type of software on an MSDE database but I thought maybe sql express would work better but not even sure if that is the route they should go. Currently they are using our sql 2000 standard edition but all their connections(avg of 25)will just drop from sql, so now they want to consider installing an MSDE version on the application server.
Juanita
May 15, 2007 at 7:42 pm
There was a throughput limitation on MSDE - I think it was five simultanenous operations - but this limit does not exist on SQL Server Express. This free version runs the same database engine as the commercial versions, with some hardware limitations (4gb database size, single proc, 1gb of RAM).
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply