Size Matters

• Mardy Gazzo

  Ten Centuries

  Points: 1177

  More actions

  November 18, 2004 at 6:35 am

  #87043

  I have a friend, who has little knowledge of SQL sever, that works for a company that uses Oracle to host its enterprise applications. His employer was recently acquired by a company that uses SQL Server. So, they'll be migrating.

  He's a project manager and could care less which database they use but was under the impression that sql server was limited to smaller applications. They will migrate a 70 gig db.

  I'm not aware that size is an issue for sql server. How big is the largest production SQL Server db that you are aware of?

  Thanks

  Mardy

   

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 18, 2004 at 6:50 am

  #530641

  See, if this helps:

  http://www.terraserver.microsoft.com/

  http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx

  http://www.microsoft.com/sql/techinfo/administration/2000/scalability.asp

  http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.asp

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Sean Lambert

  SSC Eights!

  Points: 845

  More actions

  November 22, 2004 at 12:51 pm

  #531109

  Rosetta Genomics 10-Terabyte Human Genome Database:

  http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp

• Dave-3000

  SSCertifiable

  Points: 6186

  More actions

  November 23, 2004 at 4:00 pm

  #531323

  Probably the Oracle DBAs told your project manager friend that SQL Server was size-limited.  They are an insecure and defensive lot. 

  But if their Oracle apps are working OK, and they've already paid the big bucks to Larry Ellison and his henchmen, why migrate them? 

  There is no "i" in team, but idiot has two.