DBCC CHECKDB scalability and performance benchmarking on SSDs
Back in February I ran a bunch of performance tests of DBCC CHECKDB on SSDs, to evaluate the effects of degree-of-parallelism (DOP) and various options
Menu
Back in February I ran a bunch of performance tests of DBCC CHECKDB on SSDs, to evaluate the effects of degree-of-parallelism (DOP) and various options
[Edit 2016: The team ‘fixed’ the problem in SQL Server 2016 by skipping consistency checking these indexes unless WITH EXTENDED_LOGICAL_CHECKS is used.] It’s no secret
At the SQL Connections conference earlier this month, at the start of my talk on Making SQL Server Faster, Part 1: Simple Things, I talked
It’s been a long time since the last blog post on SSD benchmarking – I’ve been busy! I’m starting up my benchmarking activities again and hope
Last time I posted about SSDs I presented the findings from sequential inserts with a variety of configurations and basically concluded that SSDs do not provide
Over the last month we've been teaching in Europe and I haven't had much time to focus on benchmarking, but I've finally finished the first
Many times I'm asked whether having multiple data files can lead to an improvement in performance. The answer, as with all things SQL (except concerning
In the previous post in the series I introduced SSDs to the mix and examined the relative performance of storing a transaction log on an
Well it's been almost 6 weeks since my last benchmarking blog post as I got side-tracked with the Myth-a-Day series and doing real work for clients :-)
Blog posts in this series: For the hardware setup I'm using, see this post. For an explanation of log growth and its effect on perf, see this
Blog posts in this series: For the hardware setup I'm using, see this post. For an explanation of log growth and its effect on perf, see this
Christmas comes but once a year… really? Then mine just came early on this afternoon's UPS truck. The very nice folks at Fusion-io just sent
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
(For the hardware setup I’m using, see this post. For the baseline performance measurements for this benchmark, see this post.) In my previous post in the
(For the hardware setup I’m using, see this post.) As part of my new benchmarking series I first wanted to play around with different configurations of
I'm running some performance tests on the hardware we have (more details on the first of these tomorrow) and I was surprised to see some
It's been a few weeks since my last posts but I've got a bunch in the pipeline coming up. Firstly, I've got it together to
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.