SQL Server with Mr. Denny:

EMC


April 18, 2011  2:00 PM

For SQL, best practice is to have data on one array, logs on another array and tempdb on another array. how does this work in san world? SAN people don’t really give all these options when assigning storage for database server.



Posted by: Denny Cherry
EMC, SQL Server, Storage

Even when using a storage array it is typically best practice to have the data on one LUN, logs on another LUN, and tempdb on another LUN.  Especially if you have the option to putting each LUN on different physical disks.  If you I talked a little more about this a

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


August 20, 2010  11:00 AM

Lessons Learned from reinstalling EMC’s Replication Manager



Posted by: Denny Cherry
EMC

EMC has a very nice, and very expensive piece of software called Replication Manager.  Replication Manager is basically a giant scheduler that helps you create storage clone and snapshots on a regular schedule.  Pretty much everything that it does, can be handled via batch files if you have the...


June 3, 2010  11:00 AM

Getting EMC Navisphere working on x64



Posted by: Denny Cherry
EMC, Windows 7

So a while back I got a new laptop and also upgraded by desktop from Windows 7 32bit to Windows 7 64bit.  Everything worked great, but there was one thing which took me some time to get...


May 27, 2010  11:00 AM

When using an EMC CX array don’t plan on changing the port that you use for MirrorView



Posted by: Denny Cherry
CLARiiON, EMC

If you are using an EMC CX storage array, and you plan on using MirrorView to replicate data between two storage arrays there are a few catches which you need to keep in mind that aren't all that obvious unless you read through literally hundreds of pages of documentation. When you go to use...


May 15, 2010  12:59 AM

EMC World Day 4 (The final day)



Posted by: Denny Cherry
EMC World, EMC World 2010, Samuel Adams, Tech Ed, Tech Ed 2010

Well yesterday was the final day of EMC World 2010. This was a great conference (see posts for Days -1, 0,


May 13, 2010  4:39 PM

EMC World Day 3



Posted by: Denny Cherry
Celerra, EMC World, EMC World 2010, Emulex, Exchange 2010, FAST, VMware, Xsigo

Yesterday was Day 3 of EMC World, and there were more great sessions packed full of technical information.  Yesterday was also the last day of the exhibit hall being open so it was Apple iPad giveaway day as well, sadly I didn't win one. The first session that I want to recap here was the SAN...


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: