Hardware

Hardware, SQLBits, Storage

Enter SANdman When people buy SANs, it’s often quite a large investment. Whether it’s all SSD, all flash, or there are tiers of storage that different types of data live on, those disks aren’t cheap. When people visualize their SAN, it’s usually just the server and the pool of drives. But there’s some important stuff…

New White Paper: SQL Server Performance Tuning in Google Compute Engine

March 9, 2017

Google Compute Engine, Hardware, Wait Stats

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…

What Do You Wanna Know About Storage?

January 25, 2017

#delldbadays, storage

The Great Hardware Robbery of 2016 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…

Build Me A Build: Things I’d Do Different

January 13, 2017

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…

Build Me A Build: Assembly Olympics

January 6, 2017

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…

Build Me A Build: What Would You Do?

December 28, 2016

sql server

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.…

Build Me A Build: What’s Your Hardware Budget?

December 14, 2016

hardware

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…

Is your SAN’s cache killing tempdb?

June 3, 2016

SQL Server, Storage, TempDB

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…

Moving Databases Made Easy – SQL Server on a File Share

April 15, 2015

Jeremiah Peschka

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? Every database is unique and precious. What’s the…

Reading the New Fast Track Reference Architectures from HP & EMC

November 20, 2014

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…

SSD RAID Load Testing Results from a Dell PowerEdge R720

August 20, 2013

Hardware, Load Testing, Storage

146

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…

How to Use HP System Management Homepage

August 15, 2013

Hardware, SQL Server

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…

Monitoring SSD Performance

May 16, 2013

Jeremiah Peschka

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…

How Big Are Your Log Writes? Spying on the SQL Server Transaction Log

May 29, 2012

Kendra Little

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…

Storage Protocol Basics: iSCSI, NFS, Fibre Channel, and FCoE

May 22, 2012

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…

How to Interview Storage Vendors

April 5, 2012

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,…

How Fast Does Your SAN Need to Be for SQL Server?

April 3, 2012

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…

How to Test Your Storage with CrystalDiskMark

March 29, 2012

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. Bringing the…

SQL Server Can Run Databases from Network Shares & NAS

January 10, 2012