Query backup history

As a quick script tip for today I’ll show you a script I use regularly for reporting purposes. It shows you the backup history on your instance for successful backups ordered by the most recent first: — Get the latest successful backups — Shows databasename, backup start & end time, duration, backup file, — backup size, […]

Examining PAGEIOLATCH waits

In a previous article we looked at CXPACKET waits, a wait type that is can be on the top of your server’s list if you enabled parallelism using the MDOP setting. Another wait type that you probably will be seeing in your top 10 of waits (unless you have blazing fast storage) is PAGEIOLATCH_XX where the XX is the […]

How SQL Server statistics are generated and updated

One of the easiest ways to increase query performance on your database is making sure your statistics are up-to-date. Statistics are – if you enabled the options in your database properties – automatically created and updated by the SQL Server Engine. This does not however mean that the statistics are correct or up-to-date! In this […]

Analyzing CXPACKET waits

One of the most common wait types you will see on a SQL Server is the CXPACKET wait type. This wait type is usually at the top of the list when you query the sys.dm_os_wait_stats on servers where you configured the MDOP setting to be anything but ‘1’. CXPACKET waits have everything to do with how your […]

The power of the baseline

There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines! While this is a blog about SQL Server, baseline monitoring isn’t something only DBA’s do. Actually everyone uses baselines in one way or the other. For instance, when you receive your salary you expect it […]

How wait statistics are generated

In our last article “Why wait statistics are important and how you can start collecting them now!” we discussed a method of capturing wait statistics and a way to analyze them. Some background information on how wait statistics are generated by the SQLOS will certainly help you with your analysis! Schedulers The first important part […]