Troubleshooting SQL Server Storage Problems

Recently I was shown a whitepaper from EMC titled "Backup and Recovery for Microsoft SQL Server Using EMC Data Domain Deduplication Storage Systems". Over all the whitepaper isn't bad giving information about how to setup EMC's Data Domain product to be used with Microsoft SQL Server so that the backups can be taken from the SQL database and written to the Data Domain VTL and deduplicated....Read the rest of entry >>

While building a 25 instance cluster isn't the best idea, I still want to!...Read the rest of entry >>

When planning out the hardware and network configuration for a database mirroring configuration you need to plan for more than just the normal workload on the system....Read the rest of entry >>

These are three very different technologies that for the most part aren't competing with each other, but instead are complementary to each other. Read on to see how they are different from each other....Read the rest of entry >>

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

No... Oh you wanted more information than that? OK Here goes......Read the rest of entry >>

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

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

...Read the rest of entry >>

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