April 30, 2009 at 3:42 pm
Guys,
We are working on a feasibility study on some Application for the SWINE flu thing... so I need some quick help.
Can Sql Server Express be used to run as a database for an OLTP application.
Java Web Server + Sql Server Express for a application that could have at least 200 simultaneous users entering data.
thanks for any suggestions,
_Uday
April 30, 2009 at 3:50 pm
From msdn:
SQL Server Express uses the same reliable and high-performance database engine as the other versions of SQL Server 2005. It also uses the same data access APIs such as ADO.NET, SQL Native Client, and T-SQL. In fact, it is differentiated from the rest of the SQL Server 2005 editions only by the following:
Lack of enterprise features support
Limited to one CPU
One GB memory limit for the buffer pool
Databases have a 4 GB maximum size
Otherwise, there is no workload throttle and the engine performs as in other editions.
April 30, 2009 at 4:06 pm
What you could do is used the Express Advanced it comes with SSRS lite which comes with separate memory limit so you could separate your execution based on needs, run queries in the relational engine and run reports in SSRS so you have about 3gig of ram to use.
Kind regards,
Gift Peddie
April 30, 2009 at 4:15 pm
Thanks Gift Peddie. I'll look into it
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply