Installing SQL 2008 R2 on 2008 R2 Server Core

Following on from previous posts on a similar theme, I wanted to make a quick note of how SQL 2008 R2 is installed on a 2008 R2 Server Core VM. SQL 2008 R2 has a number of feature dependencies that must be present before an installation can take place. Assuming that you've deployed your VM, given it some network settings and joined it to your domain (if you want) then there are three further things you need to address to get SQL installed. The first is adding some disk space to the VM. If, like me, you deploy Windows server…

Read More

SQL VM CPU Spikes

Some people still aren't convinced by virtualisation and while it's true that there are some situations that it's not especially suited for they are relatively few in my experience. I know a few people who are yet to be convinced completely. One's a SQL DBA and there are times when she has a point. I thought that this might be one of them until I started poking around. Initially I was asked about what was causing a SQL VM to respond slowly and use 100% CPU. I had a look in vCenter and while it looked slightly busy it didn't…

Read More