Originally Posted by imcffp
New IT guy, who seems very familiar with AC strongly suggested that I upgrade to SQL workgroup or Standard (Best). This would be approximately $800.00 to $4400. AC will only use 1 core of the processor and 1 Mb of RAM with SQL express.

I may have missed discussions about this.

Any thought?


SQL Server Express 2005 (packaged with Amazing Charts) is constrained to one processor (not one core) and to 1 gigabyte of RAM. This means if you were to have a quad core processor, it could use all 4 cores. Could you please list the specifications of your server and how many users there are in your office? For 4400 you could get a pretty nice server with SBS 2011 Premium Addon with SQL Server Standard for Small Business. Just for SQL, that price seems pretty hefty.

Here's a comparison chart from MS for SQL Server 2005:
http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx


Here's a comparison chart from MS for SQL Server 2008:
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

Last edited by sluthra; 06/03/2011 10:15 PM.