Category: Database Health

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

The Database Health Reports application provided free of charge to the SQL Server community. Enjoy! Today I released Beta 5 of the Database Health Reports. Beta 5 is mostly bug fixes and performance improvements. There was one new feature added, the Big Clustered Indexes report. The Big Clustered Indexes report shows clustered indexes that may be larger than optimal. Give it a try with …

Database Health Reports – Beta 5 Released Today. Read more »

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

Today, the Database Health Reports had its 300th dowload.  I would like to say thank you to everyone who is using the product, and an extra thank you to those who have provided me with feedback. Since I started  planning the Database Health Reports a year and a half ago, until the latest download release on January 10th, 2013, it …

Over 300 Dowloads of the Database Health Reports Read more »

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

Just a reminder, we are a couple weeks into beta 4 of the database health reports.  If you haven’t tried it out, take a look at http://databasehealth.stevestedman.com.   You can use the Database Health Reports to increase the overall health of your SQL Server from finding duplicate indexes to tracking down wait stats on your SQL server.  Beta 4 has …

Beta 4 of the Database Health Reports Read more »

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

Today I released Beta 4 of the Database Health Reports. It has been 2 months since Beta 3, and several bug fixes and new features have been added.  The main focus on this beta was fixing bugs, increasing stability and a new more solid setup program. My favorite part of the application is the historic waits advisor, which allows you …

Database Health Reports- Beta 4 now available. Read more »

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

When creating a table you can specify IDENTITY with the following syntax: For example The IDENTITY property is valid for data types of the integer data type category, except for the bit data type, or decimal data type.  So how many rows can you insert into that table?  It depends on the data type used. BIGINT maximum value is 9,223,372,036,854,775,807 …

Are you wasting half the capacity of IDENTITY? Read more »

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

Today I release Beta 3.1 of the Database Health Reports. Immediately after the release of Beta 3, there were 3 bugs reported that were very quick to fix.  I was able to get these fixed, along with one other bug fix, once they were all tested, I launched Beta 3.1 of the Database Health Reports. For anyone who downloaded Beta 3 …

Database Health Version 3.1 So Soon After Beta 3 Read more »

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 »

By Posted on Posted in Database Health No Comments Tagged with

Finally after a month and a half of preparation on Beta 3 of the Database Health Reports, it will be released tomorrow. The biggest feature in Beta 3 is the historic monitoring.  This process installs a small database to track wait times continuously, with a very small (less than 1%) on the database being monitored. Look for the download of …

Beta 3 of the Database Health Reports will be launched tomorrow. Read more »

By Posted on Posted in Database Health 1 Comment Tagged with , , , ,

5 days until Beta 3 of the Database Health Reports.  Coming soon, and this one is going to be cool.  Although Beta1 and Beta2 had a number of great monitoring features Beta 3 takes a whole new approach.  All of the previous features in the database Health Reports report on the current status at the time you run the program. …

5 Days Until Beta 3 of the Database Health Reports Read more »

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

Coming in the next beta of the Database Health Report is a new feature called the Historic Reports which installs a small database to track database statistics over time.  This has an extremely light load on the overall database performance, and will allow you to track down details of why the database was slow at a specific point in time. …

Database Health Reports – Historic Waits Report Sneak Preview Read more »