Monthly Archives: January 2008

Disabling AOL Parental Controls

Here at the office, we inevitably end up doing some support for everybody’s home computer at one point or another.  An interesting problem had us all stumped for hours, though, and I just had to share it in case anybody else ran across it.

The symptom: the computer couldn’t surf to any web sites outside of the local subnet.  We tried using both Internet Explorer and Firefox to no avail – the connections simply timed out on both port 80 and port 443.

We tried using telnet at the command prompt, like “TELNET YAHOO.COM 80″ and that gave a connection timeout.

Finally, somebody stumbled across AOL Parental Controls in the add/remove programs, but somehow we were unable to uninstall it.  We called AOL and got routed through one phone number after another until it got escalated high enough.

The solution is to delete the following files and reboot:

  • C:\Windows\SYSTEM32\DRIVERS\spcflt.sys
  • C:\Windows\SYSTEM32\DRIVERS\spcstb.sys
  • C:\Program Files\Common Files\aol\1127593350\ee\services\ver2_0_10_16\serviceManifest.xml

Reboot, and afterwards the computer will work fine.

Ugh.  I hate desktop support.  I hate even HEARING it happen in the cubicle next to mine.

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

Getting close to moving time

The move back to Houston hadn’t really hit me until I encountered one of my to-doos today on RememberTheMilk.com: reserve a moving truck.  Suddenly I found myself staring at a big trip plan:

Buy It Now

The way U-Haul works is that when you reserve the truck, you fork over a couple hundred bucks and pick the moving date.  Ouch – that’s like, really soon now.  Really soon.  And I gotta pick a date and stick with it.  Wow.

Okay, now it’s sinking in!

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

SQL 2008 release date pushed back

Remember all the hoopla when SQL 2005 came out? Microsoft swore we’d get more frequent releases because the 5-year lag after SQL 2000 meant it wasn’t worth paying for Software Assurance on SQL Server. They promised we’d get new stuff faster.

Fast forward to today’s announcement:

“Microsoft is excited to deliver a feature complete CTP during the Heroes Happen Here launch wave and a release candidate (RC) in Q2 calendar year 2008, with final Release to manufacturing (RTM) of SQL Server 2008 expected in Q3.”

I literally just finished installing our first SQL 2008 development (non-lab) box and I was scheduling a meeting with our developers to encourage them to migrate their apps. Thank goodness they announced this before I held the meeting – I’d have looked like an idiot.

Update: the SQL Server 2008 release date is still scheduled for August.  I moderated a great webcast on SQL Server 2008′s new features with Kevin Kline, Hilary Cotter and Geoff Hiten talking about what’s coming.

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

Macworld Products – meh

Erika got me an Apple Macbook Pro for Christmas.  (Yes, fellas, you move across the country to put your girlfriend through college and it might pay off for you too.)  Being an Apple geek, I was painfully aware that rumors pointed to new Macbook Pros at this year’s Macworld show in January, so I was torn.  Should I return the Macbook Pro for a refund and wait for the show, or should I keep the laptop she bought me?

I decided to keep the one she bought me because I didn’t have any complaints about it at all.  It’s pretty much my dream machine: 4gb of ram, big hard drive, DVD burner, great LED-backlit screen, you name it, and it’s still nice and light.  I even talked to her about it and assured her that this was the one for me.

At this year’s Macworld, Steve Jobs introduced the Macbook Air.  I’ve always liked thin & light subnotebooks, and I probably would have succumbed to the hype and picked one up if I didn’t already have my Pro.  Thankfully, though, I have the Pro, and it’s a better machine for me anyway.  I run a virtual machine with Windows for those tasks I just can’t get away from, and the Pro’s 4gb of memory make that a much easier task.

The Apple TV is more enticing, especially since I’m buying a new HDTV as soon as we get to Houston, but I can’t justify it when a Tivo HD costs around the same amount yet does a lot more.

2007 was the year of mucho Apple expenditures, but I think they just might not get any moolah from me this year.  I’m surprised – I had money burning a hole in my pocket – but I just can’t bring myself to buy any of those new gadgets.

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

HP C-Class Blade Chassis Review

Our shop took a sip of the the HP C-class blade Kool-Aid in early 2007 and liked the taste of it. I’ve got SQL Server running on a few pieces of HP hardware, and over the next few blog posts, I’ll look at the strengths and weaknesses of the BL460c and BL680c from a DBA’s point of view.

Small, Medium and Large

When I quote hardware price options for a project, I like to give them options for Small, Medium and Large. The proposal will include hardware specs, prices and a ballpark range of the type of load the server can support. In the general case of database platforms, those options would be:

  • Small – BL460c – small blade with up to 2 CPU’s, 8 memory slots, 2 HBA’s and 4 NIC’s
  • Medium – BL680c – double-height blade with up to 4 CPU’s, 16 memory slots, 2 HBA’s and 4 NIC’s
  • Large – DL580 – standalone 4U server with up to 4 CPU’s, 32 memory slots, lots of HBA’s and NIC’s

(I would never quote a project the option of these three different hardware platforms, of course – I would already have an idea of which one they needed, and give them S/M/L quotes for that particular server.)

HP C7000 Blade Chassis

HP C7000 Blade Chassis

The C3000 and C7000 Chassis Compared

The core of a blade system is the chassis, and HP’s enterprise chassis for the C-Class is the C7000. The C7000 holds up to 16 half-height blades (or 8 full-height, or some combinations) in a 10u rack space.

In that chassis, we’ve got almost all half-height blades with the exception of one full-height blade. Blades can be mixed in a single chassis, but there’s a dangerous exception that we’ll talk about later.

HP does make a smaller enclosure, the C3000, but I would highly recommend against it except for the most space-challenged shops. The C3000 is 6u tall instead of 10u, but it only supports 8 half-height servers and 3 interconnect bays. Check out the cost comparison using retail prices from Insight:

  • C3000 with 2 power supplies and 4 fans – $4,300
  • C7000 with 2 power supplies and 4 fans – $6,000

The C3000 might look cheaper, but watch how the cost looks when 2 network switches are added in – after all, the blades need network connectivity:

  • C3000 with power, fans, and 2 Cisco 3020′s – $13,900
  • C7000 with power, fans and 2 Cisco 3020′s -$15,600

Suddenly, spending the extra $1,700 to get the capacity for 8 more blades seems like a great deal. The real cost on a blade chassis isn’t the chassis itself, but rather the network switches and SAN switches that get plugged into the back side of the cabinet. Speaking of which, let’s take a look at the back of a C7000.

Everything you see in this chassis is the back of a C7000. There’s two rows of fans (at the top and bottom of the chassis), a row of power supplies at the very bottom, and in the middle, the interconnects. This particular chassis has four network switches and two SAN switches. This will seem like a lot of interconnect equipment for just 16 servers, but we tend to only use blades for equipment that needs a lot of connectivity. Examples would be:

  • VMware server – each blade needs 4 network ports and 2 SAN ports
  • Standalone SQL Server – each blade needs 2 network ports and either 2 SAN ports or 2 iSCSI network ports depending on storage
  • Clustered SQL Server – each blade needs 3-4 network ports and 2 SAN ports

Choose Switch Setups Wisely, and In Advance

Here’s where things start to get a little tricky. The half-height blades like the BL460c’s have two onboard expansion slots that take things like network cards or HBA’s. A common configuration might be one dual-port network card and one dual-port HBA. With blades, though, there’s no simple cable to plug into the network card or the HBA. Instead, the connection is handled by the blade chassis, and that connection is hard-coded to specific switches.

HP C7000 Back of Enclosure

HP C7000 Back of Enclosure

If a blade is put in with the cards reversed – like with a network card in a slot that’s connected to a SAN switch – the entire chassis goes into degraded mode. There’s no way to simply reroute the traffic between slots.

This means that if the shop has more than one C7000 chassis, and they want to move a blade from one chassis to another, both chassis must have the exact same switches plugged into the exact same interconnect slots in the back of the chassis. If the shop puts Brocade SAN switches in interconnect slots 3 & 4, then every blade chassis needs to have that same setup. Otherwise, when a blade is taken from one chassis to another, the blade won’t power on, and the chassis will go into degraded mode.

Switch Ports Stay With The Blade Chassis

Blades are so easy to pull out and move around that it’s tempting to whip them all over the place. Because I’m paranoid about uptime, we’ve embarked on a project to balance mission-critical clusters between multiple C7000′s just to make sure they stay up. (We had one instance where we had to take down a C7000 to replace a backplane.)

Unfortunately, however, when a blade server is removed from one slot and popped into another slot, its network port configurations do not travel along with it. SAN ports aren’t an issue since zoning is generally done by the HBA WWN, but network ports don’t have the luxury of zoning by MAC address. C7000 users with the Cisco 3020 switches just have to involve their network staff whenever a blade with special network configurations (like VMware or a cluster heartbeat nic) is moved from one slot to another.

That’s not a defect of the chassis by any means, just something to be aware of.

Choose Blade Arrangements Wisely Too

Earlier I mentioned that a chassis can have a mix of half-height and full-height blades. The chassis uses a series of interlocking shelves to hold each blade up. These shelves must be removed in order to use full-height blades. The problem is that they’re designed in a way that if a full-height blade goes in, more than one shelf must be removed.

In our example photo above, look at the far right slots. We have four half-height blades in a grid. Those four constitute one unit of shelving. To the left of that, we have a full-height blade, neighbored by one half-height blade at the bottom and an empty unit right above that. That group also constitutes one unit of shelving: the full-height slot and its neighbor all have the same shelving setup. That means I could put two full-height blades, or one full-height and two half-heights.

However, if I use two half-heights, and if I remove the half-height blade on the bottom, the half-height blade above it will fall down!

When deciding to use full-height blades, be aware that if only one is used, then one half-height slot next to it at the top will be wasted. Either that, or just decide to never remove the blade on the bottom without removing the one on the top first.

But The Rest Is Positive

Apart from those issues, the HP c-Class blade chassis system has been reliable, easy to manage, easy to service, and a joy to interact with.

I don’t know that the blade setup is necessarily cheaper, especially when given the amount of switching infrastructure, but it’s much easier to grow and manage than a similar number of physical servers.

In my next few posts, I’ll talk about the differences between the BL460c (half-height), BL680c (full-height), and a DL580 standalone server for comparison, focusing on how they impact database administrators.

Continue to Part 2: The Cisco/Brocade Interconnect Switches

Skip to Part 3: HP Virtual Connect Review

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

Dell EMC AX150i review

Dell EMC AX150i

Dell AX150i

The iSCSI EMC AX150i is resold by Dell, and refurbished versions are available pretty inexpensively through the Dell Outlet. We just picked up our second AX150i with 12 500gb SATA drives for around $6,000 total, or about $1,000 per raw terabyte. It’s a great deal for lab or development storage, but there are a couple of gotchas that I haven’t found in other reviews.

The AX150′s Drive Pool Setup Limitations

The AX150i stores its operating system on the first four drives (bays 0, 1, 2, 3). Those 4 drives therefore have less available capacity than the other 8 drives in the AX150i. Those drives cannot be used as hot spares, either, because of their specialized roles.

This breaks the AX150′s drives into the following categories:

  • Disks 1-4: some space consumed by OS, can’t be hot spares
  • Disks 5-11: full amount of free space
  • Disk 12: hot spare (could be any disk number, but I’m picking 12 for this example)

If the user tries to create a disk pool, and tries to mix some of disks 1-4 with disks 5-11 (like creating a 6-disk array with disks 1, 2, 3, 4, 5, 6), the AX150 throws out a stern warning. It will allow the configuration, but the warning is pretty ugly.

So if the user can’t mix drives from those 3 groups (OS, empty, hot spare), that basically leaves the following possibilities:

  • One pool with disks 1, 2, 3, 4 – can either be raid 5 (roughly 1.5tb capacity) or raid 10 (1tb capacity)
  • One pool with disks 5, 6, 7, 8, 9, 10, 11 – an awkward total of 7 disks, meaning raid 5 (3tb capacity) or only use 6 disks in a raid 10 and get 1.5tb capacity plus an extra hot spare
  • One hot spare (or two, if disks 5-10 were used as a raid 10)

Total config space for raid 5 is 4.5tb, and for raid 10 is 2.5tb. That space quantity is fine, but the hard-coded setup limitations on which disks can be grouped together are a pain – especially when we’re only dealing with 12 drives.

The AXI150i Has No Load Balancing

The AX150i has two iSCSI ports, and it does support multipathing with the stock Microsoft iSCSI initiator. I’ve successfully set up both of the iSCSI ports on the same switch, set up two network cards on a Windows server with the MS iSCSI initiator, and then pulled various network cables out during I/O activity. Sure enough, the drives fail over without loss of connectivity or data. To me, that’s an astounding bargain at the sub-$10k price point.

However, with one Windows server and one AX150i, I haven’t been able to break the 90mbps bottleneck – meaning, I don’t get more than one network card of throughput. I’ve tried multiple disk pools, tried multiple drives, different drives on different network ports, and I haven’t been able to figure out how to get it to use two full network ports.

This is not a huge problem at this price point – I’m thankful enough that I’ve even got failover in an array this inexpensive. However, consumers need to be aware that two iSCSI ports doesn’t mean two 1gb network cards with 100% saturation.

It’s Not Expandable

Dell/EMC don’t claim this model is expandable, but this needs to be emphasized to the prospective buyer. Shops with two or more AX150′s can’t combine them, and can’t migrate data from one AX150 to another. If there’s a small amount of free space on two AX150′s, it can’t be combined to create a single LUN.

Again, not a big problem at this great price point, but something to be aware of. This feature is available at higher price points from companies like EqualLogic (now owned by Dell) and LeftHand Networks.

And Yet: A Big Winner At This Price Point

Shops that haven’t invested in shared storage yet can get their feet wet with an AX150 without a big capital commitment. I’d recommend it for a shop that isn’t sure whether or not they’ll go with iSCSI or fiber down the road, or if they’re just not sure about shared storage, period. This class of storage is cheaper to get into – and out of – than a LeftHand chassis. An AX150 can be had for under $10k, whereas the LeftHands and EqualLogics run at least twice that much. Granted, they offer twice as many features and much better scalability.

We took the approach that these are for development sandbox use only, never production. Our VMware lab farm is hooked up to an AX150, and so is my SQL Server data warehouse testbed. It’s a testament to their ease of use that I’m always tempted to slap a production array on one just because we’ve got the extra space.

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

New Year, new site look, new city

I made two resolutions for 2008: refresh my web site, and avoid buying any gadgets until Erika and I buy a place in Houston.

First, yes, the new site layout includes ads. I make a great living at my day job, and I would never begin to dream that I could make a living off blogging, so it’s not like I’m trying to supplement my real job.  You might ask why I’d slap ads on a personal site.

The biggest reason for the ads is that I’ve always had ads on my ServersAlive template instructions and people click on them.  The ads must represent something that people are actually interested in, because they do actually click on the ads.  So I got to thinking – what if the ads are a service to the reader in some way?  What if people are seeing ads for products they wouldn’t have otherwise been aware of? After all, that’s how most of my traffic arrives: people come here via search engines, looking for something. Typically, it’s for specific SQL Server or database administration information. If they can’t find what they need from me, maybe they can find it from an advertiser on Google.

The second reason is that I have this itching desire to start hosting a podcast on SQL Server.  I haven’t been able to find a good one with fun content and regular (meaning frequent) updates.  It’s going to cost me money to put that on, and I’d like to think I’m at least breaking even with my little side hobby.  The podcasting won’t start until after Erika and I have moved to Houston in February.

Ah, yes, Houston – thankfully, Southern Wine is going to let me telecommute, at least for a while.  As soon as I got that good news, I started thinking about spending my mornings at Kaveh Kanes again.  Kaveh Kanes was a great downtown coffee shop with robust internet access and a great atmosphere, but the key word there is “was” – turns out Kaveh Kanes closed.  Dang. Time to find a new haunt, and time to ping my buddies to see if anybody’s interested in setting up Coworking in Houston.

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