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 |
|
blocker
Yak Posting Veteran
89 Posts |
 Posted - 2012-04-25 : 02:07:09
|
| Good day Guys!To all who has been an SQL Server Administrator, up to how much size of data can SQL Server 2008 support? I was asked by a Company for which is best to support large scale of data SQL Server or Sybase?Which of the two is more powerful? I mean, in performance.Thank you!TRANSOFTWARE |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-04-25 : 02:22:25
|
| What edition of sql server ?After Monday and Tuesday even the calendar says W T F .... |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-04-25 : 02:43:35
|
Might be worth reading thishttp://msdn.microsoft.com/en-us/magazine/cc163629.aspxquote:
..We built an online catalog of the SDSS data as a Web-accessible database, along with visual tools to analyze the data (SkyServer.sdss.org). The result is a SQL Server™ database with approximately 14 billion rows. It gives full GUI and SQL access to the SDSS data
After Monday and Tuesday even the calendar says W T F .... |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-04-25 : 02:50:06
|
| I know MySpace.com used SQL Server...which would be fair to say is large scale. And I'd go for SQL Server on the basis of it being far easier to get qualified people. Don't know much about licensing costs for Sybase but I would guess they are in the same ballpark.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
blocker
Yak Posting Veteran
89 Posts |
Posted - 2012-04-25 : 05:18:42
|
| thank you for the reply guys! Indeed, both are good, its just Sybase runs on almost platform, and SQL Server only runs on Windows platform..So it still depends on which platform the Company is using!TRANSOFTWARE |
|
|
|
tomrippity
Starting Member
37 Posts |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-04-25 : 13:00:50
|
quote:
Originally posted by tomrippity
According to: http://msdn.microsoft.com/en-us/library/ms143432.aspx524,272 terabytes
It says 524272 TB per database and 32,767 databases per instance.So it would mean 524272 * 32767 = 17178820624 TB which would be 16776192 PB.Now that's really galactic for a single instance...After Monday and Tuesday even the calendar says W T F .... |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-04-26 : 02:28:22
|
quote:
Originally posted by Sachin.NandIt says 524272 TB per database and 32,767 databases per instance.So it would mean 524272 * 32767 = 17178820624 TB which would be 16776192 PB.
...and an excellent example that theory and practice are two VERY different things!- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-04-26 : 03:15:35
|
quote:
Originally posted by Lumbago
quote:
Originally posted by Sachin.NandIt says 524272 TB per database and 32,767 databases per instance.So it would mean 524272 * 32767 = 17178820624 TB which would be 16776192 PB.
...and an excellent example that theory and practice are two VERY different things!- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
So is it even more than that in practice ?  After Monday and Tuesday even the calendar says W T F .... |
|
|
|
|
|
|
|
|
SQL Server can support up to?