Virtualization

SQL Server 2008 R2: Think Virtualization

Virtualization
12 Comments
How are my servers doing? How are my databases doing? If my boss came in and asked which servers needed more horsepower or which ones could be consolidated together, how would I come up with an answer? I’ve always found it funny that DBAs and sysadmins don’t have good answers to these questions.  We roll…
Read More

PASS Virtualization Virtual Chapter

#SQLPass, Virtualization
1 Comment
The Professional Association for SQL Server has a few Virtual Chapters.  Formerly known as Special Interest Groups (SIGs), these are groups where people with similar interests can get together and talk shop.  It’s like that Furry group you belong to, only different.  Or maybe not so different. I’m starting up a Virtualization Virtual Chapter: a…
Read More

Reasons Why You Shouldn’t Virtualize SQL Server

Virtualization
93 Comments
I’ve blogged about why you should virtualize SQL Server, but it’s not all unicorns and rainbows.  Today we’re going to talk about some of the pitfalls and problems. When Virtualization Goes Right It’s Tougher to Get More Storage Throughput Servers connect to Storage Area Networks (SANs) with Host Bus Adapters (HBAs).  They’re like fancypants network…
Read More

Why Would You Virtualize SQL Server?

Virtualization
16 Comments
I talked about why sysadmins want to virtualize servers, and today it’s time to talk about why you as a DBA or developer might want to virtualize some of your SQL Servers. Virtualization Means Cheap High Availability Yo momma was an early adopter. That’s right – you’re adopted. In a perfect world, every SQL Server…
Read More

Why Your Sysadmin Wants To Virtualize Your Servers

Virtualization
14 Comments
DBAs and developers: right now, your Windows admin is talking to management about all the time, money and hardware he can save by virtualizing servers. He might not start with SQL Servers first, because frankly, he’s scared of database administrators.  DBAs only have one answer: “No.” Your sysadmin knows how you roll. Thing is, though,…
Read More

Partition alignment in virtual machines

Virtualization
1 Comment
Partition alignment is a setup trick for disk-intensive apps like Exchange and SQL Server that can have a 30% or more performance impact on  your server.  The setup information is in my SQL Server Setup Checklist, and Jimmy May has more details on the mechanics of partition alignment. If you run SQL Server in VMware,…
Read More

SQL Server support on virtual servers

Virtualization
1 Comment
The Microsoft knowledge base article on SQL Server virtualization support just got an update.  Here’s the interesting part: “Versions of SQL Server after SQL Server 2005 will incorporate full support for running on a supported guest operating system that is installed on a Windows Server 2008 Hyper-V virtual machine.” That means SQL Server 2008 will…
Read More

Ugly month of outages

Hardware, Storage, Virtualization
9 Comments
The past month has been a real challenge, filled with 70-80 hour weeks and clawing back from one disaster after another. In late June, IBM recommended that we upgrade the firmware on our DS4800 SAN controllers to fix some problems. We obliged, and two days later, our Exchange cluster rebooted without warning. We’d been having…
Read More
Menu