March 10, 2011 at 8:47 am
Hi!
Anyone who knows large (billion+ rows) and publicly available (Internet) projects created with MS SQL Server...
...please, share a link here.
I need to show bosses MS SQL Server's success stories.
thanks in advance.
Anton Burtsev
March 10, 2011 at 8:50 am
Try here - http://sqlcat.com/
You're probably not going to find large, public databases, but there are really large implementations around. Some examples:
MySpace
NASDAQ
etc
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 10, 2011 at 9:01 am
There's a slideshow about the MySpace set-up here (from 2009, but still):
http://www.slideshare.net/markginnebaugh/myspace-data-architecture-june-2009
March 10, 2011 at 9:34 am
A few links for you:
2005, WinterCorp: 19TB warehouse - http://www.wintercorp.com/VLDB/2005_TopTen_Survey/2005TopTenWinners.pdf
Paul Randal's survey, 3 people over 100TB: http://www.sqlskills.com/BLOGS/PAUL/post/Bigger-is-better.aspx
1.1PB SQL Server: http://news.softpedia.com/news/Microsoft-Applauds-1-1-Petabytes-SQL-Server-2008-Database-97388.shtml
February 20, 2014 at 2:15 pm
Here is some more recent info from the SQLCAT team... among some other petabyte monsters and companies they profile the databases running XBOX live which adds 12 TB monthly as of the presentation.
http://passmedia.sqlpass.org/media/24hours/2012_fall/PDF/06.pdf
February 20, 2014 at 9:59 pm
russ.thomas (2/20/2014)
Here is some more recent info from the SQLCAT team... among some other petabyte monsters and companies they profile the databases running XBOX live which adds 12 TB monthly as of the presentation.http://passmedia.sqlpass.org/media/24hours/2012_fall/PDF/06.pdf
Cool Stuff.
I'd love to work on one of those 100TB+ databases.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 8:29 am
Not I. I'd pass on that job. I like my family and bed.
February 21, 2014 at 8:50 am
Steve Jones - SSC Editor (2/21/2014)
Not I. I'd pass on that job. I like my family and bed.
You'd hope if you're working on instances that big that you'd be doing more incremental work than a wholesale change
February 21, 2014 at 8:54 am
stormsentinelcammy (2/21/2014)
Steve Jones - SSC Editor (2/21/2014)
Not I. I'd pass on that job. I like my family and bed.You'd hope if you're working on instances that big that you'd be doing more incremental work than a wholesale change
You're still responsible for the whole thing. Can you imagine someone truncating a table? losing data? Having to restore the db in some way?
Yikes.
February 21, 2014 at 9:57 am
Steve Jones - SSC Editor (2/21/2014)
stormsentinelcammy (2/21/2014)
Steve Jones - SSC Editor (2/21/2014)
Not I. I'd pass on that job. I like my family and bed.You'd hope if you're working on instances that big that you'd be doing more incremental work than a wholesale change
You're still responsible for the whole thing. Can you imagine someone truncating a table? losing data? Having to restore the db in some way?
Yikes.
Can you imagine the DBA yard stick coming at them to slap their hands?:hehe:
Yeah - there would be some pain. But there is a lot of learning potential too.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 11:36 am
Agreed. Architecting, that would be fun. Day to day support? That's another story.
February 21, 2014 at 11:49 am
Steve Jones - SSC Editor (2/21/2014)
stormsentinelcammy (2/21/2014)
Steve Jones - SSC Editor (2/21/2014)
Not I. I'd pass on that job. I like my family and bed.You'd hope if you're working on instances that big that you'd be doing more incremental work than a wholesale change
You're still responsible for the whole thing. Can you imagine someone truncating a table? losing data? Having to restore the db in some way?
Yikes.
you're right but if you have half a brain you shouldn't be truncating a table :), losing data requires some work, restoring the db will require a lot of prayer 🙂
February 21, 2014 at 11:51 am
SQLRNNR (2/21/2014)
Steve Jones - SSC Editor (2/21/2014)
stormsentinelcammy (2/21/2014)
Steve Jones - SSC Editor (2/21/2014)
Not I. I'd pass on that job. I like my family and bed.You'd hope if you're working on instances that big that you'd be doing more incremental work than a wholesale change
You're still responsible for the whole thing. Can you imagine someone truncating a table? losing data? Having to restore the db in some way?
Yikes.
Can you imagine the DBA yard stick coming at them to slap their hands?:hehe:
Yeah - there would be some pain. But there is a lot of learning potential too.
very true, that's what it's all about...learning to deal with a multitude of situations where nothing scares you or surprises you...i'm with you i'd love to work on a db/server of that size if not larger, the learning gained from that would be incredible
February 21, 2014 at 1:36 pm
So, now i'm kind of curious to see what size DBs other members are working with.
I'm working with a 750 GB database with around 350 million records.
February 21, 2014 at 2:01 pm
Personally, I'm working with 2,659 databases, which add up to about 700GB of data altogether.
And yes, this is a horrible, horrible design by a vendor :-D. Really, all of these databases could just be tables in a single database (they're even set up to be as such!), but it works. Mostly. Sometimes. If you shake the server once a week or so.
- 😀
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply