Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SQL 2008 Express versus SQL 2008 Standarf (full)

Author  Topic 

ferret2010
Starting Member

1 Post

Posted - 2012-09-03 : 16:17:48
Hi folks ...

Our company have a software package designed to monitor clinical instrument over TCP/IP. The application uses SQL 2008 as its DB engine.

Each instrument is a client and reads/writes to/from the SQL DB via controlling software.

The default DB engine we provide is SQL 2008 Express. Most of our systems connect to between 4 and 18 instruments (clients). We have pams to extend to 30 instruments sometime soon.

Our DB will not come close to the 10GB limit afforded by SQL 2008 Express, since it's culled when it reaches 12 months old.

In the big scheme of things, SQL 2008 Standard (full) version is very expensive.

Is there any benefit is moving from SQL 2008 Express to SQL 2008 full version for 30 clients?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-09-04 : 14:24:30
The number of clients isn't necessarily why you would want the full version. Which edition you pick is dependent upon the features each edition provides. If you can fit into the free edition, then by all means use that. If you can't, then you need to upgrade.


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -