THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Storage Design   (RSS)
  • New Project Starting. Got Gas?

    “Storage is just like gasoline,” said a fellow DBA at the office the other day. This DBA, Mike is his name, is one of the smartest people I know, so I pressed him, in my subtle and erudite way, to elaborate. “Um, whut?” I said. “Yeah. Now that everything is shared – VMs or consolidated SQL Servers and shared storage – if you want to do a big ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on September 10, 2012
  • Scandalous II: Shh! I am De-duplicating Compressed Backups

    This is part II of two Scandalous posts. Watch, mouth agape, as I run with scissors, right up against prevailing wisdom! Unfollow me now, before it’s too late! Here’s the thing. There are two really outstanding posts out there on the ‘tubez that explain in vivid detail the problems with sending compressed data into a de-duplicating appliance. And ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on April 23, 2011
  • POSH-y SQL Disk Space Monitoring

    In a prior post I expressed my dismay that apparently Operations Manager (which I dig in other respects) has no love for SQL Server storage that uses mount points. Herewith, henceforth, forthwith is a PowerShell workaround I am using until I find out I am wrong, or there’s a management pack fix. The crux of the issue, I think, is that SQL Server ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on January 5, 2011
  • T-SQL Tuesday #004: Real World SSD’s

    A contribution for T-SQL Tuesday #004, hosted by the illustrious Mike Walsh! In the past few weeks I had some correspondence with Kendal Van Dyke leading up to his SQL Saturday presentation on SSDs, and he got me fired up to share a little of my team’s experience with a real implementation. Over the past four months or so, our IT group at work ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on March 8, 2010
  • SAN 101 for the DBA

    As will become apparent from this post, I am no Storage Admin. My apologies for offending the sensibilities of those who know this topic better than I do! I get asked occasionally about placing SQL Server data on SAN storage, and I've done it with a few systems, and a lot of smart people helping me, so here's a SAN 101 crib sheet for DBAs ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on February 16, 2010
  • New Toys (Ho! Ho! Ho!)

    So, I am just writing because I am excited about some new toys we're setting up at work: I've got three new Nehalem-based SQL servers connected to our first storage array with solid state disks (it actually has three tiers of storage: SSD, FC and SATA). Looking forward to screaming fast reads for our data warehouse/BI setup, as well as ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on December 17, 2009
  • Choices in physical storage design – EAV Case Study

    Partitioning for Fun and Profit Over the past year or so I’ve been playing with a toy SQL monitoring application, just to sharpen my dev skills a bit. Part of the app is a SQL database to store historical performance data, in order to do trending. Fooling with the design of the performance database allowed me to look at EAV (Entity Attribute ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on November 23, 2009
Privacy Statement