Also depends on the I/O metrics on the databases also. ( You running OLAP or OLTP?) its not always about RAM ( which will help with the Buffer Pool, but if you have a slow disk subsystem that can keep up with the page spilts, inserts and deletions you are going to start seeing slow downs in the response from the database due to a slow disk subsystem.
Why I look at SQL in a different light then regular OS virtualization, and I still favor for proper hardware scaled properly and scoped properly and cluster the DB and use Mirroring, Transactional Log Shipping for DR/HA, and just migrate your multiple databases to these few systems instead of moving multiple hardware sets with SQL on them to virtual land. Just food for thought, Z Edward E. Ziots CISSP, Network +, Security + Network Engineer Lifespan Organization Email:[email protected] Cell:401-639-3505 From: Andrew S. Baker [mailto:[email protected]] Sent: Friday, January 07, 2011 9:06 AM To: NT System Admin Issues Subject: Re: Some advice re Servers Virtualization Okay. How much RAM do you expect to devote to each DB server? So far, the specs don't look like a problem, but specific details could raise red flags... ASB (My Bio via About.Me <http://about.me/Andrew.S.Baker/bio> ) Exploiting Technology for Business Advantage... On Fri, Jan 7, 2011 at 8:12 AM, Pierre Camilleri <[email protected]> wrote: The database servers will be virtualized and the databases are not heavily used. In fact there will be SQL 2005/2008 and Oracle 10g databases being hosted but will not be very large and again not heavily used. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
