SQL Server with Mr. Denny:

Storage


January 4, 2011  2:00 PM

Ever have this conversation?



Posted by: Denny Cherry
In Person Events, SQL Saturday, SQL Saturday 62, SQL Server, Storage, Virtualization

Have you ever had this conversation with your storage admin? [kml_flashembed movie="http://www.youtube.com/v/yZlbLkD46Kc" width="425" height="350" wmode="transparent" /] If you have, then do I have a session for you to attend.  On January 14, 2011 in Tampa, FL I'll be presenting...

January 3, 2011  2:00 PM

If you are going to provide SQL Server support, you should probably know what you are doing.



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, RackSpace

So the other day I got a ticket opened by my companies Managed Service Provider.  There was a backup failure on one of our databases.  The response from the hosting provider was:

This failed due to a "Error: 3041, Severity: 16, State: 1." error. This is because you...


December 30, 2010  2:00 PM

We are currently running on an EMC SAN. Did I hear you correctly, we should have databases, backups, temp, and logs on the same LUN? Thanks.



Posted by: Denny Cherry
EMC, SQL Server, Storage

No, you want to put them on different LUNs.  IBM is currently recommending that on the XIV array that everything can be put on a single LUN as the LUN is spread over all the disks in the array.  For an EMC array you’ll want to have separate LUNs for each. Denny


December 23, 2010  2:00 PM

Do you have any affordable recommendations (mid-size company) for DR to a secondary site, about 11 TB of storage?



Posted by: Denny Cherry
DR, EMC, Storage

It depends on how you are going to handle your data replication.  If you are going to use native array based replication then you’ll need to either use array’s data replication options or look at EMC’s recover point. If however you are going to handle the replication outside of the...


December 20, 2010  2:00 PM

Database Restores and Torn Pages



Posted by: Denny Cherry
Log Shipping, SQL Server, Storage

This weekend I was migrating some databases from one server to another.  As these were rather large databases (about 2 TB in size) and I didn't have the clusters setup on a SAN (using DAS instead) I needed to setup log shipping from one cluster to another so that the downtime when moving was kept...


December 9, 2010  2:00 PM

Do we have to worry about disk alignment if we have an EMC san?



Posted by: Denny Cherry
EMC, Storage

Yes.  Every storage platform no matter what vendor makes it needs to be correctly aligned.  If the disks aren’t correctly aligned then you are doing twice as much work for every read and write operation than you need to be doing. Fortunately new volumes created on a Windows 2008 or higher...


December 2, 2010  2:00 PM

Will separation of data file and log file of SQL sever help if all are on the SAN? From performance perspective not management.



Posted by: Denny Cherry
EMC, IBM, SQL Server, Storage

Most likely yes, but it really depends on the storage array and the storage array configuration.  If the array is a shared everything array like an IBM XIV then their may not be any benefit to breaking everything onto separate disks as each LUN is spread over every spindle in the device.  However...


November 29, 2010  11:00 AM

I’ll be presenting a pre-con at #sqlsat62 in Tampa, FL.



Posted by: Denny Cherry
In Person Events, SQL Saturday, SQL Server, Storage, Virtualization

If you wanted to go to my pre-con at the SQL PASS Summit, but you couldn't make it, or you couldn't get the boss to approve the $400 price tag that PASS was charging do I have a deal for you.  I'll be presenting the same pre-con (hopefully better after integrating feedback from the PASS summit) as...


November 25, 2010  11:00 AM

What are the best counters or KPIs to identify what dirves woudl benefit from EFD’s and can be used to reflect before and after performance metrics?



Posted by: Denny Cherry
SQL Server, Storage

EFDs (Enterprise Flash Disks) or SSDs (Solid State Disks) are all the rage today for systems which have very high IO load requirements.  But knowing if your disks would benefit from this technology can be a bit of a problem if you don't know where to look.  After all these disks are not...


November 22, 2010  11:00 AM

What should be done for a Transaction log drive (array) to make sure the log records are ON the disk, even if the power fails?



Posted by: Denny Cherry
Cache, SQL Server, Storage

This is a great question that I got a while back during a web cast that I did during the 24 Hours of PASS.  Most storage arrays, at least the better quality ones, have a battery within them which will keep a portion of the array online in the event of a power outage.  While the array won't be...


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: