Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Run, The Sky is Falling (#memeMonday)

This month’s Meme Monday is “dumb SQL questions”.  Here’s the one that gets under my skin the most these days:

Let me explain this again...

Our databases are starting to get really big. When should we think about moving them to Oracle?

No. No, no, no, no, no no no no no no no no no no no no no no no no no NO.  Microsoft SQL Server is not Notepad. It’s not Access. It’s not Excel. It’s not a toy. It is a full fledged, enterprise ready relational database server. It’s all grown up and has its big boy boots on. It can handle it, you go right ahead.

Futhermore, the performance issues you see with your databases aren’t due to the incredible growth you’re seeing, oh no no. Your performance issues stem from bad code, badly designed vendor databases, badly maintained (or outright neglected) servers and DBs, and your own general lack of caring. In short, issues that will not go away by attempting to port to a whole other platform.

Bonus points: Said databases are fewer than 10, and smaller than 15 Gb apiece.

Now, behave yourself, and don’t make me explain it again.

-Jen

Comments

Posted by Jason Brimhall on 7 June 2011

Wow those are big databases.  I don't think I have seen one that big in at least 5 years.

Oh wait - yes I have - my test databases.  I better port those to Oracle.

Posted by Chris Harshman on 7 June 2011

have no doubt that Oracle can run on servers that SQL Server could only dream about since it runs on a wider range of platforms.  The amount of horsepower on modern Windows servers though can scale a well designed SQL Server database into the terabytes though.

Posted by Jason Brimhall on 7 June 2011

@Chris - I have actually supported multi-terabyte databases on SQL Server 2000 and on.  SQL Server does well with large databases.

Posted by Dukagjin Maloku on 7 June 2011

Hey hey hey today these two database technology really are very strong to handle a lot of data and I do not have doubt on them ...simple today the SQL Server 2008 R2 / Oracle 11g are the best database platform that you can have many possibilities to manage large data (TeraB)! I vote for both of them, choose whatever you want and you will be the winner to manage large databases!

Posted by David on 27 June 2011

There are plenty of good reasons for upgrading to Oracle, not least to take advantage of the scalability and HA features of non-Windows platforms. Oracle also has plenty of features which SQL Server cannot match. Microsoft seem to agree because in every new release of SQL Server they add new features that Oracle customers have enjoyed for years. Microsoft still has a long way to go to catch up with the guys from Redwood Shores.

Leave a Comment

Please register or log in to leave a comment.