Impact of Fusion-io based tempdb on reindex duration

Tuning tempdb performance with FusionIO cards is a given but you may not be taking full advantage if reindexing is left on default settings.

Do you have tempdb on Fusion-io (or equivalent) technology? Is your reindexing job left on default settings (re-orgs at 5-15% and full rebuilds at @ 30%)? If so, then you might be interested in the findings in this post. The benefits of flash memory as a replacement for spinning drives in order to boost SQL […]

SQL Server wait stats

SQL Server wait statistics provide the most objective indication of the perfomance of a SQL Server instance and this post explores how to use them to get more details about performance issues.

The single biggest clue to the source of a performance problem will be from something referred to as the wait stats. What are waitstats? In short wait stats are statistics gathered on what resources SQL Server is waiting on internally whilst executing queries. Why are they useful? They can often provide very quick and objective […]

The SQL Server default trace

The SQL Server default trace reveals a lot about the recent history of the system. Find out how to troubleshoot common database issues using it.

The SQL Server default trace is useful! The SQL Server default trace (introduced from SQL Server 2005 onwards) is a background trace that runs continuously and records event information that, despite the adverse comments on the web about its value, can be useful in troubleshooting problems. Not only that, but it’s there out-of-the box so […]