• subscribe
Denny Cherry

Troubleshooting SQL Server Storage Problems

by Denny Cherry

If you planned on turning on the globalEnforcePriv setting in your SAN fabric to improve security ... don't!

There is a setting which is available within Cisco Fiber Channel switches that I ran across while configuring some new Cisco MDS switches that looked great for security. The setting is called "globalEnforcePriv" and the basic idea as I understand it is that it globally enforces privacy on all the accounts on the switch. Read on to see how it shot me in the foot....Read the rest of entry >>
Posted @ 02/08/2012 10:00 AM By Denny Cherry
 

My SAN admin wants to put my transaction logs on FAST storage. Should we?

No... Oh you wanted more information than that? OK Here goes......Read the rest of entry >>
Posted @ 02/01/2012 10:00 AM By Denny Cherry
 

The Flooding in Thailand Is A Real Problem

An awful lot of rain half way around the world is keeping me from getting hard drives delivered to a data center in New Jersey. ...Read the rest of entry >>
Posted @ 01/25/2012 10:00 AM By Denny Cherry
 

How Can I Use Storage Replication For A Data Center Migration?

The answer to the question here will depend greatly on what storage platforms you have available to you. Assuming that you have some sort of storage array which supports replication to a remote data center you have some pretty neat options available to you....Read the rest of entry >>
Posted @ 01/18/2012 10:00 AM By Denny Cherry
 
 

Should the disks that you are backing up to be aligned?

In short, yes. The LUN or disk which hosts the backups is probably the disk which needs the most write performance....Read the rest of entry >>
Posted @ 01/05/2012 4:56 PM By Denny Cherry
 

What perfmon counters can I trust when using SAN disks?

Knowing which counters can be trusted to give you valid information and which counters can't be trusted is very important to properly monitoring and troubleshooting storage and Microsoft SQL Server....Read the rest of entry >>
Posted @ 12/28/2011 10:00 AM By Denny Cherry
 

Me and My New Crucial M4 SSD

So a few weeks ago I got a nice little present in the mail from Crucial. It was one of their nice new(ish) M4 SSDs with a massive 256 Gigs of free space. Here's a review of my experience with the drive so far......Read the rest of entry >>
Posted @ 12/21/2011 10:00 AM By Denny Cherry
 

Should I be using Fiber Channel, iSCSI or FCoE?

This is really an it depends question. There are a variety of things which can influence which technology you select....Read the rest of entry >>
Posted @ 12/14/2011 10:00 AM By Denny Cherry
 

Can the fiber channel switch be a bottleneck?

While it isn't the most common place that a performance bottleneck can happen, the fiber channel switches or Ethernet switches if you are using iSCSI or Fiber Channel Over Ethernet (FCoE) can become a performance bottleneck. The switches which run the network that the data travels over, reguardless of the technology involved can become a bottleneck....Read the rest of entry >>
Posted @ 12/07/2011 10:00 AM By Denny Cherry
 

advertisement
Check out Denny’s website for more information about his consulting services and speaking engagements.