SharePoint 2010 with a virtual SQL 2008 database. Will it perform?

Many people have many different opinions on this subject. Is it wise to virtualise SQL? I think it is fine. I was once not so sure but visiting SharePoint best practices conference last year as well as a data management event I now feel pretty confident. Also with our beast of a hyper-v setup I can have more RAM in a virtual SQL box than I could ever dream of in a physical server!

So on to SharePoint 2010.  I wrote a couple of simle SQL scripts just to make the database server do some work and then I used SharePoint to see how it was afected. (I’m a Firefox user so all the SharePoint stuff was done using that) The SQL server was SQL 2008 with 10Gb RAM, with the data going to a normal vhd (our production environment will be virtual failover cluster with data over iSCSI). SharePoint is sitting on a virtual machine with 8GB of RAM.

I did the following actions and timed how long each step took. Then I did them twice more; once with the SQL CPU running at 100% and then again with the disk being very busy writing rows to a database and also sharepoint performing a full crawl.

The tasks were:

Create a Team Site

Upload a docx (this was a sample made using the great “=rand(10,10)” feature of Word)

Open the document using Web Apps

Save the document after editing it within the browser

And finally deleting the site

I selected these actions as they are the kind of things people will be doing everyday with sharepoint. I didnt inclide page loading times as there was no noticble difference between browsing the site when SQL was under load and when it was not.

And the results are in:

Pretty good really. Even with the SQL server sweating away at the backend your dear SharePoint end users will be uploading and viewing documents with minimal fustration!

If anyone else has any numbers or tests they have performed (or want to question mine) then please leave a comment!

Chris

Technorati Tags: HyperV, SharePoint2010, SQL

1. Migrating from SharePoint 2007 to SharePoint 2010 Last week the twitter community and blogosphere came alive with...
2. Preparing for SharePoint 2010 Back in June I and Mike Herrity visited Seattle where...
3. PowerShell ISE in Server 2008 R2 With SharePoint Modules Some of you may have noticed that the ISE environment...
4. SharePoint 2010 Powershell Commands Help Yesterday i did a post The first steps to SharePoint...
5. The BETT Show 2010 Next week myself, Chris McKinley and Mike Herrity will be...
6. SharePoint Designer Settings in SharePoint 2010 We have engaged Sam Dolan http://www.pinkpetrol.com/ a SharePoint design specialist...