Skip to content

Database Health

My CheckDB Script

From time to time I get asked about checkDB, and there are many solutions out there, but I have one that I generally use that is very simple and does the job.

The script below created a stored procedure in the DBHealthHistory database that can be used to check as many databases as you can get through in a specific time interval. Here it is set to 5 minutes, but that usually gets extended for large databases.  If you set the job to daily, and the job doesn’t get through checking all the databases today, it will pick up where it left off and check the rest tomorrow.

 

Depending on the number and size of your databases you may want to run this more than once a day, or for a longer period than the 5 minutes.

Note: the 5 minute limitation is checked before starting the next check, so if you have a database that takes hours to check, that will kick off in the 5 minute interval and run until completion.

 

Read More »My CheckDB Script

February 2017 Release of Database Health Monitor

Today I had the opportunity to complete and launch the February 2017 version of Database Health Monitor.

I hope you like the latest version. Here are the Release Notes:

Version 2.5 Release Notes – February 2017.

Version 2.5 is the February 2017 release of Database Health Monitor, released on February 19, 2017.

What People Are Saying About Database Health Monitor

  • Outstanding app. Already referred it to several friends in the field. Well I do have to say the changes you have made (regarding version 2.5), seems to have made everything in the interface much snappier. Your work here is quite impressive. (Frank from Texas)
  • Outstanding! Besides enjoying the layout of your app, one thing I really like about the Quick Scan Report is each entry has a corresponding link that discusses the finding so I can go back and review recommendations, cautions, etc. (Michael)

New Features in 2.5

  • Upgraded application to use the .Net 4.5 runtime.
  • Fragmented Indexes Advisor – added buttons to rebuild or reorganize all fragmented indexes. Wow this will save some time when you have a bunch of indexes to defragment.
  • Added historic monitoring for disk space. Still need to add reports, but the tracking is there.
  • Added a menu to the main application window. Removed the big buttons for Connect, Settings, and About, and replaced them with menu items.
  • Added a menu item to link to the feedback survey.
  • Rearranged some of the columns on the What is Active report to make it easier to see what is running right away without scrolling.

Read More »February 2017 Release of Database Health Monitor

Database Health Monitor – January 2017 Version Released

Today we released the Database Health Monitor January 2017 version. You can download it for free at http://DatabaseHealth.com/Download.

This update includes  some new branding with new logos, new icons, and a new splash screen, as well as the usual feature enhancements and bug fixes.

So far since we started tracking downloads there have been 11,100 downloads of Database Health Monitor worldwide.

As part of our goal of improving Database Health Monitor, and expanding it to meet the needs of more and more DBA’s, we have created a survey to solicit input on how people are using it, and what we can do better to improve the product.  The survey is located here: https://www.surveymonkey.com/r/TJLJDXH

Here is the list of changes in the latest release.

Read More »Database Health Monitor – January 2017 Version Released

Database Health Monitor Version 2.4 Released

If you haven’t tried Database Health Monitor Version 2.4 might be a good time to try it out. Five and a half years of my development time has gone into Database Health monitor, and hopefully the features will show it.

Star_of_life

Here is what people have to say about Database Health Monitor.

Excellent – It’s the first tool I open every morning to see what is going on in my production environment! Thanks for the great work!

I personally used Database Health Monitor to manage over 100 instances of SQL Server, and it speeds up many of the daily maintenance checks.

Version 2.4 Release Notes

Over the last several months I have added several new features, and many bug fixes. Here are some of the features and fixes included in this update.

Read More »Database Health Monitor Version 2.4 Released