Category Archives: Virtualization

Virtualization

What do you want to know about virtualization?

The PASS Virtualization Virtual Chapter is working with virtualization vendors to build an FAQ, and we’re going to hand it out at the PASS Summit in November.  We’re also working on a unique Q&A panel event talking about SQL Server & virtualization – more on that shortly.

We’ve put together a one-page (well, one long page) survey asking:

  • Have you virtualized dev, production, DR, large database servers?
  • If you’ve virtualized SQL Server, what’s been the biggest benefit?
  • If you haven’t, what’s the biggest barrier?
  • What information do you need to confidently virtualize SQL Server?
  • What significant problems do virtualization vendors still have to solve?
  • Have you got any databases you’d like to virtualize, but the 3rd-party-vendor won’t support it?
  • What webcast topics would you like to see covered?

You can take the survey here.  We’d really appreciate your help.  Thanks!

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Laptop Virtualization Best Practices – And a Contest!

Whether you’re using Windows or a Mac, if you’re thinking about using virtualization for the first time on your laptop to test out new operating systems like Windows 7 or Windows 2008 R2, there’s a few things you should know.

Get Another Hard Drive

Drive Bay

Drive Bay

Laptop drives aren’t quick to begin with, and running two operating systems simultaneously doesn’t make life any easier for your pokey drive.

Your laptop probably has a removable CD/DVD drive, and that drive bay slot is designed to hold more than just optical drives.  You can pick up a hard drive caddy that slides into that same slot.  Check your laptop’s hardware manual for the exact part number, and then search Ebay for that part number.  Drive bay caddies are usually available for around $20-$40.

Apple Macbook users can swap out their internal drives with the MCE OptiBay drive adapter too.  This voids the daylights out of your warranty, but it’s not as hard as it looks.  I just went through this process with my own Macbook Pro, and I recommend it highly – I have a review of that coming soon.

Pay close attention to the caddy bay specs, and then order a hard drive to match.  Most laptop bay caddies take either a PATA or SATA 2.5″ laptop drive.  Some high-capacity 2.5″ hard drives are a non-standard 12.5mm high instead of 9mm, so make sure you don’t get a drive that’s too thick to fit inside your caddy.  Buy the fastest (not the largest) drive you can afford.  I use the 2.5″ performance test charts at TomsHardware for reference, and the current king-of-the-hill on performance per watt is the Seagate Momentus 5400.6 for around $90.

USB Piggyback Drive

USB Piggyback Drive

If your laptop doesn’t have a drive bay adapter or if you’re not willing to give up that trusty CD/DVD drive, you can also use an external USB hard drive.  Just make sure to get one of the 2.5″ models that doesn’t require external power – the less cables you have to carry, the better.  Then mount it on the back of your laptop display using Velcro tape.  Presto, you can detach it and reattach it whenever you need to pack the laptop into a tight case.

After installation, Windows will see this as just another hard drive that you can partition and format.  When you build virtual machines, store them on this secondary hard drive.  Bonus points for backing up your important files there, too.

Get As Much Memory As Possible

The more memory you have, the better.  I’d consider 4gb the minimum to comfortably run two Windows OS’s simultaneously no matter what virtualization software you’re using.

To find out how much memory your laptop can handle, use the memory configuration tool at Crucial.com.

When It Comes to Virtual CPUs, Less Is More

When building your guest OS’s, always set them up with just one CPU.  Virtualization CPU scheduling has a gotcha: if your virtual OS is set up with two CPUs, then the hypervisor’s scheduler will wait until two cores are available before doing any work in the guest – even if the guest only needs to do one core’s worth of work.  This same concept holds true at the server-level too – don’t set up your ESX guests with 4 CPUs just because you can.

Understand Virtual Networking Modes

The various flavors of hypervisors have three basic network modes for guests:

  • Bridged Networking – aka Home Office Mode. This is the one you’re going to think you want, because each virtual machine gets its own TCP/IP address directly from your home router just like your host machine does.
  • Network Address Translation – aka Starbucks Mode. The hypervisor acts as a little router, and it assigns unique TCP/IP addresses to each guest.  The guests aren’t on the public network directly, but they can access network resources just fine.  This is my favorite because I can switch back and forth between different networks without the guest servers wigging out.  I can suspend them to disk at home, then wake them up at Starbucks and nothing changes.  I highly recommend this mode, especially since it’s easy to switch back and forth between this and…
  • Host-Only Networking – aka Tin Foil Hat Mode. Like Starbucks Mode, each guest gets its own internal TCP/IP address on your laptop’s private network, but there’s no communication with the outside.  This is good for testing software that might have conflicts with other stuff on your network, and it’s also good when you’re on a slow network.  When I’m using my aircard and I don’t have a good signal, I’ll boot up my guests in Host-Only mode so that they don’t try to connect to Microsoft to download updates or anything else that might suck up my precious bandwidth.

Back Up Your Virtual Hard Drives

Installing the Windows guest, configuring it the way you want it, and patching it takes hours.  After you’re done – but before you install any third party software – shut it down and copy the flat files to another directory.

When you want to spin up a new virtual server, just make another copy of those flat files and import them into your hypervisor.  The methods are slightly different depending on what virtualization software you’re using, but all of them are much easier than reinstalling Windows from scratch and patching it.

That’s it for my tips – if you’ve got more to share, feel free to leave ‘em in the comments for other folks to get started easier.

Hard Drives, Get Your Hard Drives Here

Hard Drives, Get Your Hard Drives Here

Oh, And the Contest! Want a Free 120GB 2.5″ USB Drive?

I’m moving to Chicago soon, and I need your help.  I need to clean out my home office, but I hate throwing gadgets away.  Time to give away some of my extra goodies.

Today, since we’re talkin’ USB drives, let’s give those away.  I’ve got two self-powered USB 2.5″ hard drives, both 120 gigs, both exceedingly stylish.  One is a speaker’s gift from the PASS Summit last year, and one is a leather-bound hard drive.  (I have very strange tastes in USB devices.)

To win, just leave a comment here.  Only one comment per person, please.  I’ll draw two comments at random on Saturday Sept 12th at 7AM EST and announce ‘em here.  Good luck!

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Weekly Links for August 14

This might be my last link post. Now that Google Reader makes it so easy to broadcast saved articles to Twitter, Facebook, Delicious, etc., I’m thinking this might be redundant. If you’d miss it, leave me a comment explaining why you’d rather see these links in the blog instead of those other services. Thanks!

SQL Server Links

SQL Server 2008 R2 CTP Available – you can download it and start playing with it right now.  Disclaimer: the cool bits require Excel 2010 and an update to SharePoint, neither of which are publicly available.

Recovering a Database Without the LDF File – lots of talk in Twitter about this Denis Gobo Ted Krueger article.

Manual Administration – automate, automate, automate.  Rod Colledge explains why you can’t get off the hamster wheel until you start automating.

Use Database Snapshots During Code Deployment – Lawrence Overbey writes to take a snapshot first, then deploy your code.  When it’s all gone Pete Tong, you can roll back to the snapshot faster than you can do a restore.

Secrets of the SQL Server Consultant – Jason Massie passes on performance tuning tips.

Benchmarking – Who Needs It? – You do, and Mike Walsh shows you how to pull it off.

Chris Shaw’s Blog Quiz – I made some jokes in my response and things went swiftly downhill from there.  See answers from Grant Fritchey, Jason Massie, Tim Ford, Tom LaRock, and others.

New SQL Server Videos This Week

SQL Server Book Corner – Kevin Kline, Grant Fritchey, Ross Mistry and your humble author talk about how to pick a good IT book.

Tom LaRock on Meet the Experts – SQLRockstar gets interviewed by Christian Hasker, Quest Software marketing genius.  (Yes, he just happens to be my boss – why?)

Cloud and Virtualization Links

SQL Azure Documentation Online – you can read the docs and sign up for the CTP.  Remember, 10gb max per database…

Is Virtualization the DBA’s Friend? – Allan Hirt says not all the time.

The Junk Drawer

Learn How to Work a Crowd – Alexis Bauer deserves free drinks everywhere she goes. This five-minute how-to video is brilliant:

Google Reader Turns Up the Awesome – now you can share RSS articles straight to Twitter, Delicious or other social networking services.

16 Apps That Make Sharing Large Files a Snap – TechCrunch shows the pros and cons of each service.

Inject Yourself Into Your Content – stop writing boring crap, mmkay?  I say it over and over in private, but I don’t say it often enough here: if I wanted to read Books Online, I’d go read Books Online.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Weekly Link Recap for August 7

SQL Server Links

Kick Your Assumptions – Jimmy May explains why sys.dm_db_index_operational_stats doesn’t include information about every index, despite what Books Online says (and what I thought.)

The Importance of Regular Consistency Checks – Paul Randal reveals survey results about how often people are running DBCCs, and explain why they should be run more often.

Complimenting Your Skills and DBA Compliments – Colin Stasiuk and Jason Massie talk about the kinds of skills you should consider learning to augment your database administration abilities.

PASS is Relaunching Their Magazine – Grant Fritchey will be editing the new SQL Server Standard Magazine, and they’re looking for writers.

Is That Table Being Used? – Denis Gobo uses the DMVs to find out which tables are being queried.

Rome Wasn’t Built in 15 Minutes – Allan Hirt goes off about why good things take time and planning.

SQL Server Memory Models Part 1 – in which the Microsoft Premier Field Engineers take you to school.

Do Small Tables Need Indexes? – Simon Sabin answers with demo scripts.

New Training Videos

How to Audit Your SQL Server – Colin steps through all of the pre-2008 options, and then demos SQL Server 2008 auditing.

Troubleshooting the SQL Server Service – Denny Cherry and Trent Mera show how to troubleshoot the service when it won’t start.

Backing Up Big SharePoint & Encrypted Databases with Differentials – Backing up databases with a lot of binary data (images, documents, files) like SharePoint or fax software can be painful.  Same with encrypted data, too.  Brent Ozar and David Swanson explain how you can use differential backups to achieve compression in these normally incompressible environments.

Cloud and Virtualization Links

The Biggest Cloud Computing Pitfall – Jason Massie believes the problem isn’t security, but more like vendor lock-in.  If you code your application for proprietary cloud tools like Amazon SimpleDB, you can face lock-in, making it much tougher to change vendors.

Real World Azure with Microsoft IT – Microsoft’s doing a tour and they’re coming to a town near you!  Two sessions per day – a morning one for IT people, and an afternoon one for developers.  I’ll be at the Grand Rapids ones on 9/16.

The Junk Drawer

Linux - Finally Ready for the Desktop

XKCD Says Linux is Finally Ready for the Desktop

Seth Godin Webcast You Must Watch – Seth is a genius and a hell of a presenter, and this particular one is about why marketing is too important to be left to the marketing department.  Bonus points for working in Jimmy Buffett and Parrotheads.  Funny quote: “Do you remember when tofu only came in two flavors, Plain and Extra Plain?”

How To Know if a Company Is First-Rate or Second-Rate – Jay Grieves has an awesome article here with the line, “When you find a second-rate system that the company won’t fix, you know that you’re not dealing with a first-rate company and you need to stop treating them as such.”  Brilliant.

StackOverflow Birthday – StackOverflow is one year old this week.

DFS Replication Tips – Windows Distributed File System is a really cool way to synchronize your SQL Server backups across multiple locations without lifting a finger.  Kendal Van Dyke writes about things I wish I’d have known when I started using DFS.  (I still have a borked share on my domain controller from this.)

Facebook Now 4th Largest Site in World – they surpassed Wikipedia, and now they’re only behind Google, Microsoft and Yahoo.

Get Into the Top Ten Percent – Steve Jones tells you how to get your resume onto the top of the stack.

Your Robot Tripod is Trying to Get You Fired – Sony’s new tripod moves the camera around, recognizes faces, composes images and takes pictures automatically.  If only these took SD cards, you could hook it up to an EyeFi card that automatically uploads your photos whenever you’re within WiFi range.  Leave one of these bad boys running during your next drunken shindig, and capture the moment that you’ll always regret.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Virtualization Isn’t The Answer To Sprawl

Denis Gobo (BlogTwitter) wrote an article yesterday about SQL Server sprawl – the problem of database servers popping up from under desks, datacenter corners, and developer cubicles.  Part of the problem stems from SQL Server 2005 and earlier not requiring a license key, so they didn’t need a keygen hack or fake serial number.  Simply pop in the SQL Server CD, and next thing you know, there’s a new mission-critical part of the infrastructure.

SQL Server 2008 helps to slow down sprawl by requiring an installation key.  There’s still a free 180-day evaluation version of SQL Server that anyone can download, and it comes with built-in temporary registration numbers.  That doesn’t stop SQL Server sprawl altogether, but rather turns the problem into SQL Server time bombs.

Virtualization might seem like a solution because we can take these rogue instances out from under desks and put them in the datacenter.  Systems management software companies (Quest included) provide Physical-To-Virtual (P2V) converters that will make the process easier, and I’ve blogged about how to kill the dinosaurs with P2Vs.

When your company becomes really successful with virtualization, however, it turns out that virtualization makes the problem even worse!  Virtualization empowers sysadmins to quickly roll out new virtual machines based on templates.  In a matter of minutes, you can have a completely new Windows machine ready – perfect for use as a development server, testbed server, or proof-of-concept server.  Heck – it’s even easier than slapping SQL Server on a leftover machine under your desktop!

And that right there sums up the problem.

Suddenly it’s even easier to provision all-new servers.  Be careful with that licensing….

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube