IO Subsystem Archives - Page 3 of 3

Follow-up on Summer Performance Palooza 2013

Aaron Bertrand (@AaronBertrand) reflects on the presentation he gave during the PASS Performance VC Summer Performance Palooza 2013 on June 27th, including a wealth of responses to Q & A.

Aaron Bertrand ◆ July 26, 2013

5

Troubleshooting SQL Server CPU Performance Issues

Joe Sack (@josephsack) of SQLskills.com outlines his approach to troubleshooting CPU performance issues in SQL Server.

Joe Sack ◆ May 28, 2013

4

Looking at Database Snapshot Performance

Jonathan Kehayias (@SQLPoolBoy) of SQLskills.com takes a look at snapshot performance, with some surprising observations about what happens if you have more than one concurrent snapshot.

Jonathan Kehayias ◆ May 21, 2013

10

Break large delete operations into chunks

Aaron Bertrand (@AaronBertrand) discusses ways to optimize large delete operations, both to make them faster, and to minimize impact on the transaction log.

Aaron Bertrand ◆ March 13, 2013

48

A Look At DBCC CHECKCONSTRAINTS and I/O

Erin Stellato of SQLskills takes a deep look into the I/O impact of running DBCC CHECKCONSTRAINTS, including explaining why some check methods may consume a lot more I/O than others.

Erin Stellato ◆ February 28, 2013

8

Trimming More Transaction Log Fat

In my previous post on streamlining the operations of the transaction log, I discussed two of the most common causes of extra log records being generated: dead weight from unused nonclustered indexes and page split operations (that cause index fragmentation). Assuming you’ve read that post, I mentioned that there are more subtle problems that can be detrimental to transaction log performance, and I’m going to cover these here.

Paul Randal ◆ January 22, 2013

8

Potential enhancements to ASPState

Many people have implemented ASPState in their environment. Some people use the in-memory option (InProc), but usually I see the database option being used. There are some potential inefficiencies here that you might not notice on low volume sites but that will start to affect performance as your web volume ramps up.

Aaron Bertrand ◆ January 11, 2013

14

Trimming the Transaction Log Fat

In many SQL Server workloads, especially OLTP, the database’s transaction log can be a bottleneck that adds to the time it takes a transaction to complete. Most people assume that the I/O subsystem is the real bottleneck, with it not being able to keep up with the amount of transaction log being generated by the workload.

Paul Randal ◆ December 17, 2012

11

Minimizing the impact of DBCC CHECKDB : DOs and DON'Ts

Aaron Bertrand (@AaronBertrand) discusses several aspects of DBCC CHECKDB and offers suggestions to minimize the impact this crucial operation can have.

Aaron Bertrand ◆ November 29, 2012

27

Quick Tip – Speed Up a Slow Restore from the Transaction Log

Here's a quick tip for you:

During some restore operations in SQL Server, the transaction log redo step might be taking an unusually long time. Depending somewhat on the version and edition of SQL Server you've installed, you may be able to increase performance by tinkering with the readahead performance for the redo operations. To do this, you should use the MAXTRANSFERSIZE parameter of the RESTORE statement. For example, if you set MAXTRANSFERSIZE = 1048576, it'll use 1MB buffers.

Kevin Kline ◆ November 14, 2012

3

The Zombie PerfMon Counters That Never Die!

One of the things that's simultaneously great and horrible about the Internet is that, once something gets posted out in the ether, it basically never goes away. (Some day, politicians will realize this. We can easily fact check their consistency.) Because of longevity of content posted to the Internet, a lot of performance tuning topics become "zombies." We shoot 'em dead, but they keep coming back!

Kevin Kline ◆ October 17, 2012

0