SQL Server with Mr. Denny:

Storage


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


October 18, 2010  11:00 AM

Installing Cisco Fabric Manager on Windows 7 x64



Posted by: Denny Cherry
Storage, Windows 7

So you want to install Cisco Fabric Manager and/or Cisco Device Manager on a Windows 7 x64 computer.  Awesome, good for you.  Unfortunately like x64 VPN Cisco has in their infinite wisdom not released an x64 version of the Fabric Manger or Device Manager.  This makes installing under x64 a lot...


August 26, 2010  11:00 AM

Be careful were you place that Windows 2003 page file



Posted by: Denny Cherry
Storage, Windows 2003

If you are building a Windows 2003 cluster (yes I know it's out of support, but so is SQL Server 2000 and lots of people are still using that) you need to be very careful where you put the page file.  If you put the page file on local disk there won't be any problem, but if you put the page file...


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


August 12, 2010  6:03 PM

LaRock must be drinking on the job, I’m being allowed to speak during 24 Hours of PASS



Posted by: Denny Cherry
24 HoP, SQL PASS, SQL Server, Storage

That's right, Mr. LaRock himself (Blog | Twitter) is giving me the chance to present during the 24 Hours of...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


August 10, 2010  7:18 PM

Yesterdays Storage and Virtualization Session



Posted by: Denny Cherry
In Person Events, Storage, Virtualization

In case you missed the dozen blog posts and Twitter messages about it over the last couple of weeks yesterday was a dry run of the Storage and Virtualization session that I'll be presenting at the SQL PASS summit in Seattle this November.  We had a pretty good turn out, and I'd like to thank...