jwcolby
jwcolby at colbyconsulting.com
Sun Sep 18 19:00:17 CDT 2011
Mark, The reasons are exactly what Jim mentioned. The client currently has around 5 gigs of data, or at least their mdb containers are around that size. The free SQL Server express has the following limitations: 1) 10 gb file size 2) 1 core maximum 3) 1 gig ram maximum And the client has: 4) Serious money constraints today. SQL Server Express 2008 is just fine for a small database with a hand full of users but this is a fairly serious call center app, with 25 users in the database all the time. It just feels like a single core and a single gig is starting with serious limitations. He was "written a check" for $2K for purchasing a new server to take him into the future. I proposed $2400 for a "roll your own" 8 core AMD 6128 and 16 gigs of ram, a modern 8 port Areca raid controller and 3X 120g hard drives. He went back to the controller and got $3K. With that he added 5X 1 tb drives to build out some real storage for the company. They have always had old ebay Dell servers with too little memory and too little storage. Always trying to shuffle things around to free up room. We are actually looking at starting with Windows XP X64 as the OS on this (otherwise) entirely modern system. If it works that gets rid of the "$X per seat" for something like Windows 2008. If we can use MySQL on that with let's say 6 cores and 12 gigs of ram and a 60 gig SSD partition for the database files he could have a fairly serious system for his company size. Windows 2008 and SQL Server 2008 together were going to cost him around $10K just for those two things. While we may go there next year or the year after, I want to get him moving now. We have been stuck in neutral and rolling backwards for too long. John W. Colby www.ColbyConsulting.com On 9/18/2011 11:24 AM, Mark Breen wrote: > Hello Jim / Arthur > > Thanks for that analysis, quite accurate. > > Mr Colby, just a question, why are you not advising your client to use the > free MS SQL express R2. I use it all the time and PowerDNN use it on all > there servers that host 100,000 DNN installations. All free db's. That is > not to be sniffed it. And there are loads of tools to help with the > enterprise tools that Express does not ship with. (Note: the free version > does give you SSMS) > > Mark