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.
| Author |
Topic |
|
jhermiz
3564 Posts |
 Posted - 2007-01-17 : 10:31:11
|
Read this:http://www.baselinemag.com/article2/0,1540,2082921,00.aspIf it looks too long read the sections where it starts at 500,000 users to 1 mill, 2mill, ... etc.Learn a lot just reading this stuff.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-01-17 : 10:48:12
|
that would be "fun" to work with  Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2007-01-17 : 13:13:20
|
| Very very interesting read. Excellent !!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-17 : 13:54:01
|
| Granted I only skimmed the article, but I did skim each page...I wonder how big their databases are. It's probably in the terabytes, but I wonder how many.Tara Kizer |
|
|
|
jhermiz
3564 Posts |
Posted - 2007-01-17 : 14:45:01
|
quote:
Originally posted by tkizer
Granted I only skimmed the article, but I did skim each page...I wonder how big their databases are. It's probably in the terabytes, but I wonder how many.Tara Kizer
You'll have to read the rest of the article :) as you'll get a very good idea :). Cant believe in the beginning they were running on one SQL box...then they got to 9 servers with a lot of replication going on. I like the section about how they changed over to 64 bit sql server 2k5 and how they hit terroritory where even MS was having trouble replicating the same issues. Can you imagine the money they spent on IT consultations :)
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-17 : 14:53:26
|
| Well when I say skim, I mean I read about 75% of it. I read all of the configuration changes that they made. I just didn't see database sizes anywhere.We've been in production with our 64-bit SQL Server 2005 4 node cluster for a few months. We got some pretty beefy servers too. Performance is outstanding so far.Tara Kizer |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-18 : 06:16:14
|
| I would like to see the schematics if those SQL servers load balancing... Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
|
|
Awesome Article about MySpace on SQL Server