Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Small Scale SQL Server Deployment Expand / Collapse
Author
Message
Posted Tuesday, October 25, 2005 4:39 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:42 AM
Points: 1,046, Visits: 2,737
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/tmitchell/smallscalesqlserverdeployment.asp



Tim Mitchell, SQL Server MVP
Independent Business Intelligence Consultant
www.TimMitchell.net
@Tim_Mitchell

Post #232232
Posted Monday, November 14, 2005 1:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 17, 2010 1:11 AM
Points: 2, Visits: 15

Great article on a subject that I hope to read more about. After all, as mentioned, the small scale setups constitute the vast majority of cases if not the most complicated ones.

Post #236778
Posted Monday, November 14, 2005 7:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, August 20, 2013 2:05 PM
Points: 308, Visits: 55

The only thing you didn't mention (unless I missed it) is that size of the database isn't the only factor to consider. The transaction throughput is important too.

Another consideration is that most very small businesses will not have a dedicated database server. They will often have Small Business Server and run Exchange, Terminal Services, and many other services all off the same box. The hardware needs to be sized for what the server needs as a whole, not just the needs of SQL Server.




Bob
SuccessWare Software
Post #236845
Posted Monday, November 14, 2005 9:11 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 20, 2014 5:34 AM
Points: 2,651, Visits: 5,990

Nice Article.  Thanks for the mention of Express and MSDE.  So many small business forget these in favor of other "free" solutions using MySQL and PostgreSQL.  Dont' forget that these all come with a learning curve and may cost you more in the long run.



To help us help you read this

For better help with performance problems please read this
Post #236903
Posted Monday, November 14, 2005 4:19 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 30, 2014 10:08 PM
Points: 1,038, Visits: 444

MSDE / SQL Express also have a database size limit of 2GB...

But good article - nice to see comments & discussion on running smaller SQL Servers on a budget!

As for the MySQL stuff - I have to say that my last experience was with MySQL v3.5 or something and I found it to be rather awful, missing may important and basic features that I take for granted on SqlServer, such as stored procs.  I too have seen several shops go with MySQL for their internal project and then decide
a) They ask us to come in and bend our software to run on MySQL - answer is always no...  Some haven't wanted to run MSDE for reasons unknown    OR
b) They end up throwing away everything they've done and have wasted a lot of time because they want something that MSSQL offers, or the in-house person who wrote the database leaves and there is no one who can maintain the software...
[End rant] 




Post #237025
Posted Monday, November 14, 2005 7:02 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 20, 2009 3:33 PM
Points: 124, Visits: 13
I've attended the local SQL Server group only once in about four years. The reason is that attention has always been on large scale, enterprise level databases. The statement that small scale setups compose the vast majority of cases out there comes as a shock to me, though logically it makes sense.

I'm part of an organization that has been using MSDE on laptops for years. I don't know of anyone else that does that...maybe I should write about it one of these days.




Steve Miller
Post #237039
Posted Tuesday, November 15, 2005 1:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 30, 2012 7:54 AM
Points: 18, Visits: 298

Good, no nonesense, solid article, Tim - thanks for that.

I count myself as one of the small business users- with SQL 2000  sitting within a partitioned primary server- running a MIS that uses SQL for its data deposit, and utilising Crystal Reports.

With the myriad of rave reviews of SQL2005, and the knowledge that some day I going to have to upgrade - it was nice to read a straight forward, informing article without the hype. ( No criticism intended to any other contributors!)

Lets hope we see more from Tim

Post #237077
Posted Monday, November 21, 2005 7:35 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:17 AM
Points: 112, Visits: 80
4 GB for Express actually.


Post #238492
Posted Monday, November 21, 2005 9:10 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 30, 2014 10:08 PM
Points: 1,038, Visits: 444
So the 2GB limit in MSDE (2GB data + 2GB transaction) is now 4GB in Express (4GB data + 4GB transaction??)...  Are you sure the 4GB is not 2GB + 2GB still?


Post #238730
Posted Friday, November 25, 2005 9:50 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:17 AM
Points: 112, Visits: 80

Yes... that is what Microsoft reports:  4GB data.

Here's an excerpt from the MSDN site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp

The SQL engine supports 1 CPU, 1 GB RAM, and a 4 GB database size. ... The 4 GB database size limit applies only to data files and not to log files. However, there are no limits to the number of databases that can be attached to the server.




Post #239696
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse