You’re a database administrator, Windows admin, or developer. You might even be a marmot. You’re building your first SQL Servers in Google Compute Engine, and you’re stuck at the create instance screen. How many CPUs should you use? How much memory? How are you supposed to configure storage? Will it be fast enough, and what…
During Dell DBA Days 2016, we got to hang out with Doug Bernhardt of Dell’s storage team. He’s the guy who publishes Dell’s SQL Server documentation, builds their Fast Track reference architectures, and gets to play with all kinds of cool toys. Doug emailed us and asked: Is there any solutions type of info (or any…
What I started with isn’t what I ended with I started off really trying to stay close to budget. When I realized I needed to go over by a bit (storage, mostly), and that not all of my parts would even be here in the calendar year (the M.2), I started to wonder if I…
Overall, this was pretty easy I’m thankful that generations of enthusiasts have agreed (mostly) on standards, and written oodles of documentation and guides to make stuff like this easy. Seriously. To put things in some perspective, when I first started building and tinkering with desktops, I remember having to manually set IRQs when there was…
We already know what I’d do In my last post, I talked about the desktop I’m building with my hardware budget for this year (and, uh, some of next year’s, too…). Based on awesome feedback from you all, I made a few changes to the specs. And holy cow, ordering made things even more different….
UPDATED 12/15/2016 Spending Brent’s Money Reason number infinity spacetime + 1000 why working here rules is having a generous annual tax writeoff hardware budget. The first time around, I basically blew it all on working from home essentials. This time around I’m building a cool toy: a big beefy desktop. Why, in the age of…
Let’s start with definitions Many SANs have caching built in. What kind of cache is important, because if you’re dealing with non-SSD storage underneath, you could be waiting for a really long time for it to respond. Let’s start with some definitions of the most popular caching mechanisms available for SANs. I’m not going to…
We’ve all had to move a database. For databases above a small size, this is a painful process. While there are a number of ways that you can move a database without downtime, they all involve a lot of extra work. What if there were something easier? What’s the Real Problem? For most people, moving…
James Serra caught three new SQL Server 2014 Fast Track Data Warehouse Reference Architecture designs released by EMC, HP, and Lenovo. I love reading these because they show each vendor’s state-of-the-art storage infrastructure. Two of them have remarkably similar goals – to hold a 28 TB data warehouse: From HP: HP DL380 G8 with local PCI Express…
We’ve got a client that does big batch jobs every day, loading hundreds of gigabytes of data or more in short bursts. They were frustrated with slow performance on the batch jobs, and after we performed our SQL Critical Care® with ’em, it was really clear that their hardware was the bottleneck. They were using…
One of the big reasons you spend big money on server-quality hardware is to get cool stuff to make administration easier. Each hardware vendor provides their own software tools – Dell includes OpenManage, IBM includes Director, and HP includes their System Management Homepage. To illustrate how it works without violating anybody’s NDAs, I picked up…
Everyone wants to make sure they’re getting the best performance out of their solid state storage. If you’re like a lot of people, you want to make sure you’re getting what you paid for, but how do you know for sure that the drive is performing well? Watch that Average The first way to monitor…
I’m a bit of a researcher. When I want to know about a topic, I start off by doing a lot of reading. After I take a lot in, I want to make sure I understand the details. At that point, I try to think like a scientist. I come up with ways to test what…
Wanna get your storage learn on? VMware has a well-laid-out explanation of the pros and cons of different ways to connect to shared storage. The guide covers the four storage protocols, but let’s get you a quick background primer first. iSCSI, NFS, FC, and FCoE Basics iSCSI means you map your storage over TCPIP. You…
Buying SAN gear is hard work. You have to compare vendors based on performance, capacity, reliability, ease of implementation, quality of support, and of course, price. When I’m working with a client buying new storage, here’s the questions I have them ask each prospective storage vendor. Q: If we buy SSD, SAS, and SATA drives,…
Let’s oversimplify the bejeezus out of this complex problem. Suspend your disbelief for a second and work with me: We have a database server hosting just one 100GB table. Sure, in reality, we’ve got lots of databases and lots of tables, but we’re going to keep this simple. We’ve got a simple sales table that…
A few years ago, Erika and I went to the VW dealership to trade in her old Jetta and get a new one. The choice of a Jetta was already a foregone conclusion – she loved VWs at the time – and it was just a matter of picking out colors and options. We took…
Geeks love duct tape. Sure, we pride ourselves on building a rock-solid solution the right way, but when the brown stuff hits the moving metal stuff, we love to show off our ingenuity. We carry our money in duct tape wallets, wear duct tape shirts, practice ductigami, and hang our duct tape from custom metal…
Database administrators want just one kind of storage: fast. Companies want just one kind of storage: cheap. Since fast storage isn’t cheap, and we can’t put everything on slow storage either, we end up buying different tiers of storage. Let’s start by pretending that we’re buying a new HP DL370 G6 to act as a…
I wanted to love this monster from the moment I read the spec sheets: Network attached storage device with 4 or 6 hot-swappable drive bays Available empty (so you can bring your own drives, including SSDs) iSCSI server with 2 network ports, jumbo frame support, VLANs Official VMware ESX/ESXi, Hyper-V, Windows DFS compatibility RAID 0/1/5/10…
