(Be sure to join our community to get our monthly newsletter with exclusive content, advance notice of classes with discount codes, and other SQL Server goodies!) A while ago I blogged about disk partition alignment, and how the default alignment of 31.5Kb on Windows Server 2003 can lead to enormous I/O performance problems (see Are [...]
Paul S. Randal
In Recovery...
Using diskpart and wmic to check disk partition alignment
Posted on: February 28, 2010 9:40 am
Sample corrupt databases to play with
Posted on: February 26, 2010 12:02 pm
The very worst piece of advice I ever saw on the Internet was in response to someone asking on a SQL newsgroup ‘how can I create a corrupt database?’. The first response was: When I want to corrupt a database to play with, I go into the data center, find a hard-drive and flick the [...]
Benchmarking: 1-TB table population (part 3: separating data and log files)
Posted on: February 15, 2010 12:24 pm
Blog posts in this series: For the hardware setup I'm using, see this post. For the baseline performance measurements for this benchmark, see this post. For the increasing performance through log file IO optimization, see this post. In the previous post in the series, I optimized the log block size to get better throughput on the transaction [...]
Script: open transactions with text and plans
Posted on: February 1, 2010 4:37 pm
(Edited 2/27/10 to add database name to the output) Here's a little script I knocked up this afternoon to tell me who has open transactions on the server – not just the single oldest active transaction that DBCC OPENTRAN returns. It gives back: session ID login name database context transaction begin time how many log [...]
