SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Server can support up to?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

blocker
Yak Posting Veteran

Philippines
89 Posts
Posted - 04/25/2012 :  02:07:09  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

2937 Posts
Posted - 04/25/2012 :  02:22:25  Show Profile  Reply with Quote
What edition of sql server ?

After Monday and Tuesday even the calendar says W T F ....
Go to Top of Page

Sachin.Nand
Flowing Fount of Yak Knowledge

2937 Posts
Posted - 04/25/2012 :  02:43:35  Show Profile  Reply with Quote
Might be worth reading this

http://msdn.microsoft.com/en-us/magazine/cc163629.aspx

quote:
..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 ....
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3241 Posts
Posted - 04/25/2012 :  02:50:06  Show Profile  Reply with Quote
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.

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page

blocker
Yak Posting Veteran

Philippines
89 Posts
Posted - 04/25/2012 :  05:18:42  Show Profile  Reply with Quote
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
Edited by - blocker on 04/25/2012 05:19:09
Go to Top of Page

tomrippity
Starting Member

USA
33 Posts
Posted - 04/25/2012 :  10:24:57  Show Profile  Reply with Quote

According to: http://msdn.microsoft.com/en-us/library/ms143432.aspx

524,272 terabytes
Edited by - tomrippity on 04/25/2012 10:26:54
Go to Top of Page

Sachin.Nand
Flowing Fount of Yak Knowledge

2937 Posts
Posted - 04/25/2012 :  13:00:50  Show Profile  Reply with Quote
quote:
Originally posted by tomrippity


According to: http://msdn.microsoft.com/en-us/library/ms143432.aspx

524,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 ....
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3241 Posts
Posted - 04/26/2012 :  02:28:22  Show Profile  Reply with Quote
quote:
Originally posted by Sachin.Nand
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.
...and an excellent example that theory and practice are two VERY different things!

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page

Sachin.Nand
Flowing Fount of Yak Knowledge

2937 Posts
Posted - 04/26/2012 :  03:15:35  Show Profile  Reply with Quote
quote:
Originally posted by Lumbago

quote:
Originally posted by Sachin.Nand
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.
...and an excellent example that theory and practice are two VERY different things!

- Lumbago
My 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 ....
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000