SQL Server with Mr. Denny:

Storage


July 28, 2011  2:00 PM

HA vs DR, what’s it all mean



Posted by: Denny Cherry
AlwaysOn, DR, SQL Server, SQL Server 11, Storage

People often get HA (High Availability) and DR (Disaster Recovery) mixed up.  There are a couple of reasons that this happens.  First is the fact that there aren’t any clear guidelines which separate the two.  There are standard terms which are used to help define HA and DR, but there’s...

July 7, 2011  2:00 PM

How HyperBac worked for me



Posted by: Denny Cherry
Backup & recovery

I recently installed HyperBac on a clients SQL Server to reduce the amount of space needed to store their backups.  Specifically we were looking to reduce the amount of space the log backups took, but I was curious to see how much space the full backups would be reduced by. The full backups...


June 27, 2011  7:39 PM

SQL Excursions Sessions



Posted by: Denny Cherry
SQL Excursions, SQL Server, Storage

As SQL Excursions is getting closer, I wanted to talk a little about the sessions that I'll be presenting at the event which I'll be doing over this week.  The sessions that I'll be presenting...


May 30, 2011  2:00 PM

How to use the WITH MOVE when you don’t know the logical database file names.



Posted by: Denny Cherry
Restore Database, SQL Server

When doing a database restore and you want to move the physical database files from one disk to another, or from one folder to another you need to know the logical file names.  But if you can’t restore the database how do you get these logical file names?  By using the RESTORE FILELISTONLY...


May 30, 2011  2:00 PM

If you have 12 disks to hold DB Data files and decide to use RAID10, would you create 1 RAID 10 group or 2 RAID 10 groups made of 6 disks each for best read/write performance?



Posted by: Denny Cherry
SQL Server, Storage

I would probably make 2 RAID 10 RAID groups one for the data files, and one for the transaction log.  Without knowing what percentage of data access will be read and what will be write I’m just guessing here.  Depending on the load RAID 5 may work just fine for the data files. Denny


May 26, 2011  2:00 PM

Running on EMC Clarion CX4 – Windows reports disks are not aligned, SAN admin says that because of caching, the partition alignment from windows does not matter (and SAN is setup per "best practices". Is this true?



Posted by: Denny Cherry
EMC, SQL Server, Storage

Caching has nothing to do with disk alignment.  It sounds like your sysadmin should have gone to my SQL PASS pre-con.  All the caching does is accept the writes from the host into D-RAM instead of writing to the disk directly. Now if the LUN is aligned on the array by setting the offset on the...


May 23, 2011  2:00 PM

On an EMC array is it possible to assign WRITE cache to wherever your transaction log files are?



Posted by: Denny Cherry
EMC, SQL Server, Storage

Yes, provided that your transaction logs have their own LUN from the other files as the write cache is enabled and disabled at the LUN level.  By default read and write cache will be enabled for every LUN which is created on the array. There aren’t to many cases where you would want to...


May 19, 2011  11:00 AM

Should a VMs virtual disks all be on the same storage?



Posted by: Denny Cherry
SQL Server, Storage, Virtualization

A question that comes up when building a new virtual SQL Server is how should the disks be laid out when using the default VMDK (VMware) or vDisks (Hyper-V)?  Should the disks be on a single LUN, or different LUNs, etc. I’m sure that it will surprise no one when I say that it depends.  On a...


May 11, 2011  4:16 PM

EMC World Day 2 (2011)



Posted by: Denny Cherry
EMC World, EMC World 2011, GreenPlum, SQL Server, VMware, VNX, VNXe

Yesterday was EMC World day 2 and it was another great day at the conference. I started the day a little late as I was out pretty late on Monday night at a party. I was abe to great some great sessions in during the day however. The first session that I hit was "SQL Server on VMware -...


May 10, 2011  2:00 PM

EMC World 2011 Day 1



Posted by: Denny Cherry
EMC World, EMC World 2011, SQL Server

So today was the first official day of EMC world. I had a great time meeting some fantastic people like Chuck Hollis from EMC. There were also some fantastic sessions. This year EMC is doing something new and putting the sessions online through an iPad app as well as putting them on their...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: