Monthly Archives: January 2010

You may ask yourself, How did I get here?

Paul Randal (Blog@PaulRandal) tagged me in a post about the three events that brought him here.  I had to think about this one for a while, and I even talked it over with Erika.

Discovering BBSes

Typical BBS Menu

Typical BBS Menu

Long before the public got access to the Internet, I was logging onto Bulletin Board Systems (BBSes) with my Commodore 64. I first got started using Quantum Link, a commercial service, and then started asking around if there was anything similar but free and more grassroots-oriented.  (Being a high school kid, I doubt I used the words “grassroots-oriented,” but you know what I mean.)  When I discovered that local people were running their own online services with a bank of modems and a bunch of phone lines, I was awestruck.  These little communities were springing up all over the US, and anybody could meet other likeminded geeks anytime, anywhere.

I was hooked, and I never gave up.  When I got an IBM PS/2 in high school, IBM sent out a message to their customers notifying them of self-support in the IBM forums on some online service (might have been Prodigy, I can’t recall.)  IBM ran a contest that the user who answered the most support questions in a month would win a piece of hardware – some months it was a monitor, other months it was a hard drive.  I woke up early every day, answered questions like crazy, and raced home from school to answer more.  I won a color monitor, and I remember being really bummed out that it wasn’t the monster 20mb hard drive.

When it came time to pick a college, I chose the University of Houston in part because of its excellent Internet labs.  Any student could stroll into the labs at any time, around the clock, and get unmetered access to the Internet.  Hubba hubba!  I could have majored in MUDs and IRC.  My IRC nick was TomServo, and I played a cross between the MST3K character and a helpful bartender.  As people entered the chat room, I would do things like:

  • /me slides a beer down the long wooden bar towards the new guy in the room.
  • /me tosses a bag of quarters towards the newcomer and points her at the jukebox.
  • /me cheers and hollers, “NORM!”

I lived for that stuff.  Sadly, I was not quite as excited about the rest of the university experience, which leads me to my next life-defining event.

Dropping Out of College

UH Melcher Hall

UH Melcher Hall

I did pretty well in high school and was recognized as a National Merit Finalist.  I could attend almost any school I wanted for free (but not the University of California Berkeley, which was my first choice.)  I picked the University of Houston (go Coogs!) and lived it up.  Full ride, free housing, free books, even free food and drinks.

I just didn’t like college.

I did really well in the courses I enjoyed, like literature, political science, and psychology, but anything I didn’t like, I dang near failed.  I couldn’t get motivated to slave away over courses that had zero real-life use, like calculus, but I couldn’t avoid those courses if I wanted to graduate.  Since I found myself less and less interested in the irrelevant stuff, I decided I could do without the diploma, and I dropped out.

I know I would have been a totally, completely different person if I’d have finished college.  I’d have gotten a white collar job right after graduating.  In a perfect world, I would have connected the dots between my passion for computers and my disinterest in mathematics, and figured out a way to motivate myself to get a degree in computer science.  The early 90s was an awesome time to get an education in computers, and who knows?  Maybe I would have ended up in a dot-com – or at least, a more successful one.  That didn’t happen, though, so I wound my way through the hospitality industry instead.

Taking Control of My Career

In 1999, I worked for a hotel management company.  Because of my odd background, I did a mix of jobs – I ran the financial auditing, and I managed the computer networks.  By then, I’d already tried and given up on managing hotels – I hated depending on an army of minimum-wage workers who were all striving to get out of their jobs.  I traveled around from hotel to hotel, auditing their books and their day-to-day operations, and also set up computers, servers, and networks.  When I was in the home office in Memphis, I managed that network as well.

I started getting burned out, and I asked my manager to pick one of the two jobs – either internal audit or IT – so I could focus on that one.  Due to the small size of the company (around 25 hotels), they didn’t really have enough need for one person to do either job full time.  He tried picking one, but I kept getting sucked back into doing both.  I worked ridiculously heroic hours, 10-12 hours a day, 7 days a week, for months on end trying to keep everything under control.  After repeatedly asking for help for several months straight, I suddenly had a Eureka moment.

In my boss’s mind, I was a complete success.  He had no reason to fix anything.

All of a sudden, I realized that I shouldn’t be striving for the company’s definition of a successful employee.  I had to make my own definition and strive for that.  It isn’t always in the company’s best interest to see employees blossom to their fullest potential.  At the time, I thought it might be a limitation of small companies, but I’ve since seen that same problem pop up at big companies too.

From that point forward, I was a different employee.  I want to be a successful employee in my employer’s eyes, but when I take a job, one of the questions is, “One year after someone’s taken this position, what does success look like?  What is the best employee doing?  How are you rewarding them for what they’ve done?”  In IT, this question takes people by surprise, but the answers reveal a lot.

Who I’m Tagging

I’m going to tag different people than I usually tag, and in my mind, they’ve got something in common.  Let’s see how Andy Leonard, Jonathan Kehayias, and K. Brian Kelley answer the call.

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

Friday Linkpost (I Know, Right?)

It’s been a while since I did one of these, and I’m going to kind of cheat.  These aren’t my bookmarks for the week – they’re actually short things I’ve been meaning to blog about, but haven’t had the time.  Might as well lob them out now or forever hold my peace.  My excuse for not writing more often is that I went on a cruise last week with Mom and had a great time.

These margaritas are for Mom. Honest.

These margaritas are for Mom. Honest.

PASS Summit Evaluations Out – the speaker feedback results are in, and I got #8 in the top 10 sessions overall!  Yay, me!  My session on social networking with Jason Massie got 5th overall in the Professional Development track too.  Allen Kinsel blogged about the data, and you can read the results here.  Big congratulations to all of the presenters who scored on these reports, and for those of you who didn’t, you’re still winners in my book.  It takes huge guts to stand up on stage and deliver your presentations.  Keep in mind that your fellow database professionals are paying to hear you speak – that’s the ultimate evaluation.

Kevin Kline tagged me in his goalpost – and viciously accused me of drinking Zima.  I would like to make it perfectly clear that I’m a Bartles and Jaymes man, and thank you for your support.

Denis Gobo interviewed me about the book – and about the authoring process in general. Read the interview at his blog.

EWeek published an article of mine – about how to develop a good database backup and recovery strategy.

StackOverflow is building an API – if you want to interact with StackOverflow, ServerFault, and SuperUser via programming APIs, now’s your chance to get your voice heard.

Lots of Azure buzz – Azure goes commercially live next month, and there’s a lot of good articles and videos coming out.  OakLeaf Systems does a fantastic job of recapping the most recent activity, as evidenced by their most recent cloud recap.  If you like that kind of info, I highly recommend their blog.  They did a great analysis on the Azure SLA/NDA problem.

Windows Azure lessons learned at Quest – we’re building an on-demand version of our apps hosted in the cloud.  Quest cloud guru Dmitry Sotnikov did an interview with Channel9 about the lessons we’ve learned.

According to Bing, I’m runner-up for the sexiest DBA – with first place going to Rhys Campbell, author of TweetSQL, and I can’t deny the sexy in that.

I upgraded my blog to WordPress 2.9 – and yes, you care, because one of the features in 2.9 is the ability to embed videos easier, and the videos even show up in RSS feeds.  Brace yourself – I have big, big plans for this, and no, they don’t all involve videos of Vince Offer and Ken Block.

There’s a plague of plagiarism going around – somebody else is ripping off my material along with other prominent bloggers’ stuff.  Todd McDermid talked about the incident, Denny Cherry responded to Todd, and Jorge Segarra used my words to illustrate the point.  After reading Todd’s article, I’m rethinking my reaction, and I’m trying to relate it to real-world examples of tangible thefts.

In my travels, I visit a few museums, and they all have different policies on taking pictures.  Sometimes you’re not allowed to use tripods, but you can use a point & shoot camera.  Sometimes you can use any camera or tripod, but you have to pay a fee.  Sometimes it’s a free-for-all.  I try to ask the museum when I enter, but people don’t always understand the question, especially in foreign countries where the only words I can speak involve beer or bathrooms.

I’ve learned over time that whenever I try to take a picture in a museum, I should go nice and slow, making it clear that the nearest guard sees what I’m about to do long before I set up the shot.  I can see how the guard is going to react, and then I know for sure whether or not it’s okay.  That informal interaction tells me what’s okay – and what’s not okay.

It’s hard to do that in blogs.  I think there’s people out there who think they’re not doing any harm by taking a picture of my work and hosting it elsewhere.  I talked about why it’s wrong in my post More Thoughts on Blog Plagiarism, but copy/pasters don’t read my archives.  It really pains me to do this, but what I’m going to do is add a footer in my RSS feed saying something like this:

“Before you copy my work, please read this article.  Readers – if you’re reading this anywhere other than BrentOzar.com, email me at BrentO@BrentOzar.com.  If your tip results in me finding an unauthorized copy of my work, I’ll give you a $20 Amazon gift card.”

I really, really hate doing that, but people keep right on plagiarizing my work.  If anybody else has better ideas, I’d love to hear ‘em.

Update 1/15 – David Stein wrote a funny post about the plagiarism.

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

Chicago #SQLPASS Meeting Recap

John Jones and Ray LaMarca of NetApp came to the Chicago PASS Chapter tonight, and John did a presentation about storage performance.  One of my measures of a good performance is the number of questions asked during the presentation, and John’s presentation was definitely a winner there.  Lots of good questions.

John Jones of NetApp

John Jones of NetApp

John recommended that everyone use an IO stress tool to validate performance.  This way you can use your metrics as a baseline so you can understand what kind of performance you can expect, analyze trends, and troubleshoot issues.  He listed several metrics, but he focused most on I/Os per second (IOPs) and IO size (the amount of data being transferred.)

Workload affects performance because different workloads access data differently.  OLTP databases are generally random in nature for both reads and writes, whereas OLAP (or Decision Support Systems) tend to be sequential, like table scans, index scans, and bulk inserts.  For a RAID array, the worst performance scenario is random writes, and the best case scenario is sustained sequential reads.  An attendee asked how SANs are affected in shared environments where multiple servers share the same disk drives, and John agreed that those systems will be mostly random.  For more on this topic, check out my Steel Cage Blogmatch with Jason Massie.

John pointed out that all SAN vendors get their disk drives from the same hard drive vendors.  A drive in a NetApp SAN doesn’t spin any faster than a drive in an HP SAN – it just boils down to what the SAN vendor does between the server and the drives.  Drive throughput averages are:

  • SATA 7200 rpm – 40 IOPs at 20ms latency
  • FC 10k rpm – 120 at 20ms
  • FC 15k rpm – 220 IOPs at 20ms
  • SAS 15k rpm – 220 IOPS at 20ms

SAS 15k drives are becoming more popular because they’re packaged smaller – NetApp can fit 24 drives in a 4u rack space.

You can use Performance Monitor (Perfmon.exe) to measure your storage performance.  Here’s the metrics John focuses on:

  • Average Disk Queue Length number, but that you have to work with your SAN team to find out the number of spindles behind your array.
  • Avg Disk Sec/Read should average under 20ms for OLTP systems (30ms for DSS)
  • Avg Disk Sec/Write should average under 10ms.
  • Disk Read Bytes/Sec (Throughput) – divide this by 1024 twice to get megabytes.
  • Disk Write Bytes/Sec (Throughput) – divide this by 1024 twice to get megabytes.
  • Avg Disk Bytes/Transfer (IO Size) – divide this by 1024 once to get megabytes.

I’ve got more about capturing and analyzing these statistics in my Perfmon tutorial for SQL Server DBAs.  John also likes using the DMV sys.dm_io_virtual_file_stats to get database-by-database IO statistics.

John talked about NetApp’s FlexVols, which sound like plain shared spindle configurations with some extra goodies like “automatic load shifting” which means “tuning is no longer necessary.”  I have mixed feelings about this.  If you don’t have the time to do a really good SAN configuration and you don’t need to wring every bit of performance out of the SAN, this works well, but if you do it poorly, you can screw yourself.  Try putting SQL Server on the same spindles as a bunch of file servers doing antivirus scans.

He also covered SAN snapshot backups, which can back up huge volumes of data instantaneously.  I like snapshot backups for a few use cases.  If you’ve got a multi-terabyte data warehouse, for example, and you need to quickly refresh your dev and QA environments, SAN snapshots are a neat way to do it.  He kept looking nervously over at me knowing I work for the company that makes Quest LiteSpeed – poor guy.  If I wanted to shoot holes in snapshot backups, I’d ask how they help for disaster recovery or log shipping, and how they manage to save space in environments that do index defrags, but I kept my mouth shut, heh.

NetApp has a Performance Acceleration Module (PAM) card that acts as a 256-512mb cache card.  It’s only for reads, but it gets you faster writes because your drives aren’t burdened with doing so many reads.  He showed some statistics suggesting that these cache cards get the same read performance benefits as adding a bunch of hard drives, but without the cost or space problems.

Great presentation, lots of good information & questions.  Big thanks to NetApp and to John!

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

Free Day-Long Virtual Event for SQL Server

SQL Server training, come get your fresh hot SQL Server training here…

On Wednesday, March 3rd, we’re doing an all-day live virtual conference on how to use dynamic management views (DMVs) to do SQL Server performance tuning and troubleshooting.  We’re going to have sessions at the beginner, intermediate, and advanced levels taught by:

  • Kevin Kline (BlogTwitter) – Microsoft MVP since 2004, author of SQL in a Nutshell, founding board member of the Professional Association for SQL Server, and all around good guy.
  • Ari Weil (BlogTwitter) – Product Manager for Quest’s performance products, and knows way more about waits, performance tuning, and SQL Server architecture than anybody should.
  • Brent Ozar (BlogTwitter) – your humble author. Okay, well, author anyway.

How much would you pay for training this good?

$39.95?  $49.95?  Even $59.95?

But wait – there’s more!

It’s going to look amazing – even better than Vince’s Slap Chop Rap Remix.

We’re using the same high definition setup that the SSWUG Virtual Conference uses.  None of the LiveMeeting, picture-in-a-thumbnail stuff – we’re talking TV studio with awesome sound and cameras.  At any given time, two of us will be on camera, joking back and forth.

Since it’s completely live, and you know I’m addicted to Twitter, we’ll be taking questions and interacting with the audience the whole time.  This is gonna be fun.

The price: cheaper than free.

It’s not just free – if you register by January 31st, you’ll be entered to win one of four Amazon gift cards.  We’re giving away four $50 cards, two $100 cards, and a $200 gift card!  Even if you don’t wanna go, you should register just to win a chance at these gift cards.  (I’m probably not allowed to say that, but hey, this is just between us.)

Operators are standing by.  Register now!

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

Free Webcast: “But It Worked On My Machine!”

You’ve heard it before: “It worked on my machine, but now that it’s in production, users say it’s too slow.”

It isn’t always the developer’s fault.  Sometimes they’re using SQL Server features that look great on paper, but in reality fail to scale up to production loads.

On January 28th, I’ll be doing a Quest Pain of the Week webcast with Ari Weil.  We’ll talk about how to find bad code before it’s too late, how to prove to your developers that it won’t scale, and how to help them fix the problem fast.

Register for the free webcast today!

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

Josef Richberg and Marlon Ribunal Syndicate at SQLServerPedia

Two more bloggers joined the posse at SQLServerPedia this week, and they’re familiar faces to the Twitter community.

Josef Richberg (Blog@SQLRunner)

Josef has been a SQL practitioner for over 16 years specializing in performance & tuning. He currently works for Harpercollins Publishers designing, enhancing, and improving the sql experience for many of the data warehouse applications. He was recognized with the ’2009 Exceptional DBA’ Award.

Josef’s posts include some very specific tutorials on SSIS (that go way over my head), including:

I like Josef’s work because he gives step-by-step examples along with screenshots.  If you’re thinking about writing a book, this is a great way to gain experience through writing a blog.  If you can keep up a steady stream of blog posts with this level of quality, you can succeed with a book too.

Marlon Ribunal (Blog@MarlonRibunal)

Marlon started working with SQL Server 2000 writing ad-hoc queries as part of his tasks doing IT Support in a small document and information management company. In that same position, he also supported few software development projects as tester and troubleshooter (database connectivity issues between client & server, dataset queries, etc). In April 2007, he joined a Boeing Company subsidiary focusing on engineering data analysis. He is currently training on SQL Server 2008 Integration Services.

Marlon’s still getting up to speed as a blogger, but a good example of his work is his recent SSIS Flat File Source Issue post.  He documented a problem-solving session for others and talks a little about how Twitter helped.

I’d like to extend a warm welcome to Josef and Marlon, and I look forward to seeing their posts in the new year!

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

Performance Tuning Presentation for #SQLPASS on Jan 13th

Eric Humphrey (Blog@LotsaHelp) asked if I’d help out the Northwest Arkansas PASS chapter tomorrow and present remotely.  Because I know that you, reader, like to watch, here’s the coordinates:

  • Start Time: Weds Jan 13th 11:45 AM Central (17:45 GMT)
  • Attendee URL
  • Meeting ID: ZRW878
  • Attendee Entry Code: X/~x]ZNH3
  • Audio: will be through your computer speakers only, not the phone.  Plug in those headphones, turn off the Lady Gaga, and get your learn on.

Topic: SQL Server Performance Tuning for Race Car Drivers

Times are tough even for the best drivers: Helio Castroneves is dancing for money and Danica Patrick is doing ads for what appears to be an adult services company.  Maybe it’s time to switch careers, and I have just the thing.  Use your hard-earned knowledge of high speeds, million-dollar hardware and surviving disastrous crashes to become a SQL Server performance tuner!

In this session, I will show you:

  • Why Colin Chapman would check for indexes before adding new ones
  • The importance of well-tested safety gear to performance tuning
  • Why not monitoring your servers is like overdriving your headlights
  • Just like races are lost in the pits, uptime records are lost during maintenance windows

See you there!

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

Should We Hold #SQLPASS in Seattle?

A survey just went out to SQLPASS members and it focuses some attention on where to hold the PASS Summit each year.  In November 2010, it’ll be held in Seattle for the third year in a row, and some folks think it should stay in Seattle permanently.

I just don’t agree.

Microsoft Doesn’t Have a Lock on Good Speakers

The PASS leadership has put tremendous emphasis on how important it is to get hundreds of Microsoft speakers at the Summit, and frankly, I’ve been less than impressed with some of the Microsoft sessions I’ve watched.

Instead of giving Microsoft tons of slots, make Microsoft compete for limited slots just like the rest of us.  Even better, make Microsoft compete alongside us.  If they’ve got dozens of awesome sessions led by awesome presenters, then great – they should get lots of slots.  If Buck Woody wants an entire track, he should get it.  But not everybody from MS is Buck Woody.

Microsoft Doesn’t Have a Lock on Good Help

PASS points out that Microsoft can bring lots of employees to Seattle to help with SQL Server questions.  That’s a great thing.  If we move the event outside of Seattle, we won’t have as many Microsofties to interact with.

But is Microsoft really the only people we can ask for help?  Aren’t there people in the community who can also help answer questions?  Heck, when I’ve got a support question, I tend to post it on Twitter or ServerFault first, and those channels are dominated by the community, not Microsoft.

If you seriously have a tough support question and you want Microsoft’s help, here’s a thought: open a case with Microsoft.  Don’t wait until the PASS Summit to get your question answered.

Besides, why are we so focused on Microsoft’s costs per attendee?

Make It Cheaper for Attendees

Move the event around every year – Seattle one year, Midwest one year, East Coast the next year, then back to Seattle.  This gives people around the US a chance to attend the event for lower costs.  Midwest cities might include Chicago, St. Louis, and Houston, all of which have plenty of SQL Server people within driving distance.

After all, PASS is a volunteer organization.  If you want a conference run by Microsoft, go to TechEd.  (And that’s not a slam against TechEd – I’m just pointing out that there’s two separate conferences here.)

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

Meet the Author: Steven Wort

Steven is one of my coauthors on Professional SQL Server 2008 Internals and Troubleshooting.  He’s quite an experienced SQL Server writer – his other books include:

I interviewed him over email to learn a little more.

Tell me a little bit about yourself – what’s a typical day like for you?

Steven Wort

Steven Wort

My ideal day would go something like, up at 6, have some breakfast, drive the kids to school, go workout, arrive at work around 10, work till 5, then head home for dinner with the family and a few hours work to wrap up the day :)

The reality is that too many days start of at 5, work till 8, rush the kids to school, rush to work, work through till 7 or 8, dash home, grab a bite to eat, then back online working until 11 or 12 if not later, rinse and repeat. :(

How did you originally find out about the book?

After working on a previous book, I swore “Never Again”, then got sucked into technical-editing a couple of chapters, and then got sucked into writing a chapter at the last minute.  Now it’s done, I am swearing “Never Again” all over! ;)

What chapters did you work on, and why did you decide to write them?

I did the technical editing on chapters 1, 2, and 4, and wrote chapter 5 (CPU and Query Processing).

Writing a book is one heck of a lot of work.  What made you want to do it?

I love to share my knowledge with others, and try and find a way to explain things that makes more sense than the docs I may have struggled with.

While researching and reviewing your chapters, was there anything about SQL Server that surprised you?

We probably shouldn’t say this, but even with SQL 2008, they still don’t have a solid story with the data the DMVs expose :(

When we make the book into an epic action movie, who will play you?

Soon to Play Steven Wort

Soon to Play Steven Wort

Eddie Izzard ;)

HAHAHA, I love that guy.  When you picture somebody reading the book, what kind of person do you think of?

It’s a server room somewhere deep inside a massive data center,  Its late at night, everyone else has left, leaving the deafening drone of the thousands of cooling fans.  In a dim corner sits our DBA, all alone, struggling to figure out what’s going on, or how to do something.  BOL is no help, and he turns to our book. As he finds the right section, and reads the relevant material, a light goes on, cutting through the dim surroundings and bathing our DBA in the light of understanding.  He has figured it out and is able to fix his problem, letting him go home and have dinner with his wife and kids.

How’d you first get started with SQL Server?

This was back in 1995 / 1996 with SQL Server 4.2 running on OS2, and was because we were developing a VB app sat on top of a SQL Server DB and no one else knew anything about SQL Server, and as I expressed an interest I soon became the teams SQL expert, and things just kept on going from there.

Do you think you’ll do another book, and if so, what would you like to write about next?

“Never Again” ;)

Amen – I said the same thing.  Thanks for taking the time to be interviewed! Readers – you can find more about the book and the other authors over at SQLServerTroubleshooting.com.

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

How to Make a Dell PowerEdge Quieter

I’ve got a few servers in my home lab and I’ve always taken steps to make sure they’re quiet.  I like running my lab out of my office closet, but I don’t want to hear any of them running.  I’ve blogged about how to build a silent PC, but today I’m tackling another noisy beast – an off-the-rack server.

Dell PowerEdge 1900 Internals

Dell PowerEdge 1900 Internals

Quest got me a Dell PowerEdge 1900 to use as a virtualization host, and it’s been great.  Two quad-core CPUs, 16gb of memory, six SATA drives in a RAID 10, and about a hundred pounds of solid steel.  Seriously, the case is bulletproof and gawdawful heavy.

But it’s loud.  Deafeningly loud.  It’s got 6 92mm fans that can wake the dead.  They’re temperature-controlled, so they don’t go full blast unless the server’s working hard, but even at very light loads they’re just way too loud.  I couldn’t carry on a conversation next to this server, let alone record a podcast.  This wasn’t a problem when I had the server in the basement, but now that I’ve moved to Chicago and my “datacenter” is my home office closet, it’s a problem.  I can’t run cables inside the walls since it’s a rented condo, and I can’t run cables along the floor because I’ve got a girlfriend with a keen sense of design.

The Fix: Replacing the PowerEdge Fans

The stock fans are Nidec BetaV TA350DC 92mm fans that:

  • Move up to 150 cubic feet of air per minute
  • Spin at up to 6,000 RPM
  • Scream at 57 decibels – not quite as loud as yo momma, but close
  • Have pulse width modulation (PWM) speed control – the motherboard can control the fan speed based on how hot the server gets
Removing a Fan

Removing a Fan

Fans like this rely on very fast rotation speeds to push a lot of air, but the faster the blade spins, the more noise it makes.  Quiet-PC freaks like me turn to fans that turn slower, yet still push a lot of air.  I bought six Nexus PWM Series DF1209SL-3PWM fans from Newegg for $10 each that:

  • Move up to 43 CFM
  • Spin up to 2,500 RPM
  • Whisper at 16 decibels
  • Also allow PWM speed control

If you don’t get fans that are PWM-controlled, then the Dell motherboard will freak out upon boot-up and think there’s no fans connected.  Some models will wait for the user to hit a key to acknowledge that error, and I don’t want that happening – I leave my servers in the closet without a monitor attached.

PowerEdge Fan Cage

PowerEdge Fan Cage

The Good News: It’s Easy to Swap the Fans

Unlike some vendors, Dell’s fans use a removable cage surrounding an industry-standard fan.  Just pop the fans out of their orange cases – no tools required – and pop in the new one.

Any 92mm fan up to 38mm thick will work, and thinner fans like the Nexus work fine too.  One side of the fan cage has click-on tabs that hold the fan in, so even thin ones are fine.

The power cable is even easy to remove, but about that power cable…

The Bad News: The Power Cables are Proprietary

Unfortunately, even with PWM-controlled fans like the Nexus, the pin connections don’t match Dell’s proprietary connector.

Fan power cables aren’t plug-and-play either.  You’ll need to bust out the solder gun to cut the Dell fan cable leads and attach them to the Nexus fan’s power cables.  Both the Nexus and the Nidec fans have the same number of wires, and the same color codes.  Connecting them is just a matter of cutting the cables away from the power connectors and soldering them together.

The Result: Enjoying the Silence

I can’t believe what a difference it made.  I can hear again.  I can record podcasts with the server running in the closet right behind me.

I haven’t taken scientific measurements, but the PowerEdge now sounds roughly similar to a home-built desktop.  It’s not as quiet as my home-built silent PC or my Optiplex 360, but it’s more than quiet enough to work with in the closet.

The PWM fan controls work smoothly too, reporting back their speed to the motherboard just like the native fans.  Below is a screenshot of VMware Virtual Center showing the fan speeds, happily spinning along well below their maximum speeds.  I’ve seen them running faster (2250 RPM) during heavy load, which tells me that the motherboard is throttling down the fans.  That would seem to indicate that the motherboard isn’t overheating, because the motherboard doesn’t feel the need to ramp up fan speeds to full blast.  That’s what I call a success.

vSphere Fan Alert

vSphere Fan Alert

The Drawbacks

One problem shown above is that sometimes fans spin slow enough that they trigger Dell’s thresholds for slow-moving fans.  This isn’t a problem by itself, but since vSphere color-codes servers according to their alerts, this means that my host goes red a lot, but I have to switch over to the alert screen to find out if it’s just a slow fan or something more serious.  Gotta figure out how to fix that for good one of these days.

Because the fans are so quiet when they’re running slow, I’m also much more aware of the server’s load now.  When I start doing CPU-intensive stuff, I hear the fans start to spin up louder – something I wouldn’t have noticed before when the fans were always running full steam.  Even at their loudest, they’re still quieter than the stock fans, but the changing fan speeds can break my concentration sometimes.  (I’m easily distracted.)

Another problem is that the server isn’t any cooler.  This server lives in my office closet, but I can’t close that door or else it gets hotter and hotter in there.  I leave my office window open full time, even in the Chicago winter.

Next time we move, though, I’ll try to get a condo with a bathroom adjacent to my home office.  I’ve got this dream of using the toilet tank water and a liquid-to-liquid cooling exchange to get silent cooling.  But that’s another blog post…

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