Tag: WRITELOG

By Posted on Posted in Database Health No Comments Tagged with , , ,

The Waits Types page has been updated on the T-SQL Wiki. The wait type documentation works will with the Database Health Reports historic wait time monitoring (Free download).  Below is a screenshot of the Historic Waits Query Advisor in the Database Health Reports project. Here is the current list of waits that have documentation available.  

By Posted on Posted in Database Health No Comments Tagged with , , , , , , ,

One big new feature in Beta 3 of the Database Health Reports, the historic monitoring. The way that the historic monitoring works is that it continuously monitors your SQL Server database and logs the details around queries that are causing waits. Here is an example, the following ugly block of TSQL updates a table with a few million rows in …

Beta 3 is Now Available. Read more »