Already a member?
Sign in
Welcome! Wikis are websites that everyone can build together. It's easy!
02/20/2008 - Virtualizing Big Databases - Comments
I've been doing quite a bit of work over the last few years to provide some data as to how things like SQL Server databases and Exchange mailbox servers perform inside a VM. All in all the story has turned out to be pretty good. Sure, running in a VM does have a certain performance overhead or penalty, but when most servers are running at 20% utilization or lower - this turns out to not be a problem.
Specifically I have been running some SQL Server 2005 tests, which I am wrapping up now, in the last few weeks. On a conference call today where we were discussing the results a question came up that I thought was pretty good -
What "size" of SQL Server database do most people run?
Of course this is an impossible question to answer, but of course I came up with an answer anyway! In terms of SQL Server databases that are running in VMs - I think that so far most people have only migrated "smallish" databases. Ones that don't have extremely high transaction rates. I do know of a few cases where more performance intensive databases have been virtualized, but these are the exception today. I think that in the future more of these high performance DBs will also be virtualized.
I think that many IT shops are looking at virtualization and think that it would be really cool to move some of their "bigger" stuff into VMs. To take advantage of a better way to manage things, but they are waiting to see how everything plays out before they begin to virtualize big apps like SQL Server, Exchange, Oracle, etc.
Todd
Specifically I have been running some SQL Server 2005 tests, which I am wrapping up now, in the last few weeks. On a conference call today where we were discussing the results a question came up that I thought was pretty good -
What "size" of SQL Server database do most people run?
Of course this is an impossible question to answer, but of course I came up with an answer anyway! In terms of SQL Server databases that are running in VMs - I think that so far most people have only migrated "smallish" databases. Ones that don't have extremely high transaction rates. I do know of a few cases where more performance intensive databases have been virtualized, but these are the exception today. I think that in the future more of these high performance DBs will also be virtualized.
I think that many IT shops are looking at virtualization and think that it would be really cool to move some of their "bigger" stuff into VMs. To take advantage of a better way to manage things, but they are waiting to see how everything plays out before they begin to virtualize big apps like SQL Server, Exchange, Oracle, etc.
Todd
Latest page update: made by todd_muirhead
, Jul 9 2008, 1:06 PM EDT
(about this update
About This Update
Moved from: Virtualization Frontier
- todd_muirhead
No content added or deleted.
- complete history)
Moved from: Virtualization Frontier
- todd_muirhead
No content added or deleted.
- complete history)
Keyword tags: None
More Info: links to this page