SQL Databases on File Shares – It’s time to reconsider the scenario.

For those who have been around databases for any length of time, the idea of putting a database that you care about from either a reliability or performance perspective on an  (SMB – Server Message Block) file share seems like a crazy idea, but recent developments have made SMB-based file shares a very viable platform… Read more

SQLIOSim available for download

  There has already been a great deal of excitement over the release of SQLIOSim, and I know everyone is hungry for more details.  First the final cut of SQLIOSim is available for download at the Microsoft Download center.   http://download.microsoft.com/download/3/8/0/3804cb1c-a911-4d12-8525-e5780197e0b5/SQLIOSimX86.exe http://download.microsoft.com/download/6/5/2/65286f65-bff2-42b8-b0c9-87f117855069/sqliosimX64.exe http://download.microsoft.com/download/2/c/f/2cf8fb0a-a943-456b-9cf5-68ce426180a1/SQLIOSimIA64.exe    Inside the package you’ll find 2 executable files, SQLIOSim.exe and SQLIOSim.com.  The… Read more

Why are those IOs taking so long?

Ever see something like this in your SQL Errorlog? SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:MSSQLDATAtempdb.mdf] in database [tempdb] (2).  The OS file handle is 0x00000838.  The offset of the latest long I/O is: 0x000000ebdc0000 You may hear this referred to as a… Read more