Just a heads up to those in the area that I will be speaking at the (TriPASS) Raleigh SQL Server user group on the 15th of June 2010. The topic is Storage & I/O Best Practices. The abstract is listed below: SQL Server relies heavily on a well configured storage sub-system to perform at its peak but unfortunately this is one of the most ...

Brent Ozar (blog | twitter) recently made some comments about the FusionIO SSD drives.  Basically, he was able to break three drives in a row - simply by doing load testing against them (using SQLIO).  The symptom is simple: the drives go offline and disappear from the O/S, and need to be physically pulled from the machines.  Kind ...

The RML utilities from PSS have just been updated to include support for SQL Server 2008 along with various enhancement and bug fixes.  If you don't know what the RML utilities are I suggest you have a look at this link and take a few minutes to download them and play around some. ...

       One of the most common trends that I see related to performance & scalability with SQL Server is a poorly configured or implemented storage subsystem. There is a ton of information out there on this subject but in my opinion that is part of the problem.  Too much data is not always a good thing and there ...