Paul Randal
12 Aug 2010
SQL Benchmarking Introducing SSDs Random Inserts with Wait Stats Details
Paul Randal writes
"...You can see my benchmarking hardware setup here, with the addition of the Fusion-io ioDrive Duo 640GB drives that Fusion-io were nice enough to lend me...In this set of tests I wanted to see how the SSDs behaved for random reads and writes. To do this my test harness does the following:..."
Read post »
Paul Randal
23 Jul 2010
Survey Results on Use of Solid State Disks - Drives (SSDs)
Paul Randal writes
"...The results reflect what I've been hearing when teaching classes and talking to customers/conference attendees over the last six months. People are becoming more interested in SSDs but there's still a lot of wariness about them and of course the whole money issue of being able to buy them. I'm also not surprised...by the number of people who've analyzed their IOPS requirements and concluded that..."
Read post »
Paul Randal
07 Jul 2010
Surprising Sample Survey Results on Log File Configurations
Paul Randal writes
"...I'm impressed. 75% of all databases in the sample have less than 100 VLFs, and 97.4% have less than 500 VLFs...was very surprised by the 50/50 split of SIMPLE/non-SIMPLE recovery model for user databases. My guess is that more of these *should* be in FULL to comply with..."
Read post »
Paul Randal
22 Jun 2010
Do Multiple Data Files Make a Difference?
Paul Randal writes
"...Just for kicks, I put some of my test hardware to use to do some experimentation...it's pretty clear that with both test setups, having more data files definitely does produce a performance improvement, but only up to a point..."
Read post »
Paul Randal
18 Jun 2010
How to Hack-Attach a Damaged SQL Database
Paul Randal writes
"...how to re-attach a damaged database if someone's detached it accidentally while performing disaster recovery...reasons why you may have a damaged database that you're trying to attach to SQL Server...To attach the database you need to fool SQL Server into thinking it's already attached. The set of steps to go through are as follows:..."
Read post »