Virtualization

VMware vCloud Air SQL Summarized

SQL Server, Virtualization
4 Comments
After reading through yesterday’s announcements about VMware vCloud Air SQL, here’s a quick boiled-down version for busy people with jobs: It’s Microsoft SQL Server 2008R2 and 2012 Enterprise Edition hosted in VMware’s data centers (not on-premises.) Only 3 instance sizes are available: small (2vCPU, 8GB RAM), medium (4vCPU, 16GB RAM) and large (8 vCPU). Drive…
Read More

Are You Getting the Benefits of Virtualization?

Here’s some of the reasons companies usually virtualize their SQL Servers: Cost savings on hardware Cost savings on Windows OS licensing Cost savings on SQL Server licensing Protect against the failure of a single hardware element Leverage extended features for Disaster Recovery Automatic load balancing across multiple hosts Easier hardware replacement/migration When we perform a SQL Critical…
Read More

Auto-Scaling SQL Server Always On Availability Groups with Virtualization

Time for a thought exercise. Thought exercises are hard. You’ve got a database application that has bursty and unpredictable loads. Out of nowhere, you’ll suddenly get socked with a large amount of SELECT queries. Due to the way the app is written, you can’t cache the query results – the queries keep changing, and the business…
Read More

VMware HA is Not Database Server High Availability

I served with High Availability. I knew High Availability. High Availability was a friend of mine.  VMware HA, you’re no High Availability. See, for us database administrators, high availability means protection when: The system drive fills up because some potato decided to download a bunch of files An operating system or database server update goes…
Read More

Reader Letter from Kelly J.

SQL Server, Virtualization
7 Comments
Hi Brent – I would imagine you get many of these notes of appreciation for what you do but I just couldn’t leave the office for the day without say “Thank you so much”.  I would have never have thought that my personal investment would have paid such dividends. Today, armed with the awesome information,…
Read More

SQL Server Virtualization Q&A

Virtualization
1 Comment
In my recent “Why Is My Virtual SQL Server So Slow?” webcast, we got a lot of great questions in chat.  Here’s some of the highlights: Question: “Why would I virtualize a 4-core server and turn it into a 2-core VM?  Doesn’t performance go down?” If you’ve got an existing physical box, and your only…
Read More
For the record, he didn't really trust the Soviets either.

Read-Only View Permissions and Roles in VMware vSphere

SQL Server, Virtualization
11 Comments
When Ronald Reagan said, “Trust, but verify,” he was talking about DBAs working with their VMware sysadmins. "Trust, but verify." Ronald Reagan As a consultant, I get to see a lot of SQL Server implementations – both successes and failures.  The successes have one thing in common: transparency.  The database administrators, VMware admins, and storage…
Read More
Lacie IAmAKey Drive

Top 10 Keys to Deploying SQL Server on VMware

Virtualization
79 Comments
The most successful deployments of virtual SQL Servers have a few things in common.  When a company is doing all of these things, odds are they’re going to be very happy with their virtual SQL Servers: 10. Use vSphere 4.1, not earlier versions. vSphere 4.1 introduced major improvements in multi-CPU scheduling that vastly improve performance. …
Read More
Menu