SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Small Scale SQL Server Deployment


Small Scale SQL Server Deployment

Author
Message
Tim Mitchell
Tim Mitchell
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6840 Visits: 3104
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/tmitchell/smallscalesqlserverdeployment.asp



Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices


Johan Frisk
Johan Frisk
SSC Journeyman
SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)

Group: General Forum Members
Points: 84 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.


SW21_Bob
SW21_Bob
Say Hey Kid
Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)Say Hey Kid (662 reputation)

Group: General Forum Members
Points: 662 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
Luke L
Luke L
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14793 Visits: 6148

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
Ian Yates
Ian Yates
SSCrazy Eights
SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)

Group: General Forum Members
Points: 8070 Visits: 445

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]





Undebtedly
Undebtedly
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1118 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
Phil Henry
Phil Henry
SSC-Enthusiastic
SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)

Group: General Forum Members
Points: 186 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


Terry Grignon
Terry Grignon
Old Hand
Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)

Group: General Forum Members
Points: 328 Visits: 116
4 GB for Express actually.



Ian Yates
Ian Yates
SSCrazy Eights
SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)

Group: General Forum Members
Points: 8070 Visits: 445
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?



Terry Grignon
Terry Grignon
Old Hand
Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)

Group: General Forum Members
Points: 328 Visits: 116

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.





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search