Information Overload

[MasterRacker]

I was reading something a few weeks ago that I don't seem to have a hope of finding again. It was either in a newsletter or a website somewhere (I know... ).

The author was referencing "typical" workload in reference to server sprawl in larger companies. They stated that MYSQL and Oracle shops typically host a hundreds to thousands of DBs per server while SQL Server, while getting better, typically only has a few hundred per server.

Does this ring any bells with anyone?

Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]

 

[mrdenny]

Sounds like marketing BS to me (especially since Oracle owns MySQL now).

Oracle technically only supports a single database per instance. Each user simply gets its own schema, so if you have 10000 users you have 10000 schemas, which I suppose could be considered 10000 databases.

Also keep in mind that most larger companies still think of SQL Server as the little database. These guys will poor millions of dollars into a single Oracle server, and only $30k into a SQL Server, then complain that the SQL Server isn't fast enough, and can't handle as much workload as the Oracle server when the Oracle server has 50 CPUs and 100 Gigs of RAM.

I've run SQL Servers will hundreds and thousands of databases per server, and SQL Servers with only 1 user database per server. It all depends on the workload that the system can support.

Numbers are just numbers. If all you care about is having a large number of databases per server, then create a ton of empty databases and there you go.

I'd bet that most Oracle or MySQL servers that are sized the same size as SQL Servers have about the same number of databases and about the same load on them.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog