Skip to content

SQL Server

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

DBCC CheckDB and CheckTable doesn’t check In-Memory OLTP.

Special thanks to my friend Theresa Iserman for introducing me to Jos de Bruijn the Senior Program Manager for the In Memory OLTP (Hekaton) project to help get my questions answered at PASS Summit.

So, the Hekaton – In Memory OLTP tables are perhaps one of the most amazing performance improvements to SQL OLTP in a long time. The way that they are managing data with no latches, locks or spinlocks is awesome, and the performance gains are great.

However in a recent session at Pass Summit 2016 with Bob Ward, I followed up with a question on CheckDB and In Memory OLTP tables. Since the data for these are not store in the normal SQL Server data files or even in regular pages. Bob confirmed that CheckDB (and CheckTable) does not check the data associated with the In Memory OLTP tables. I even confirmed this from Books Online in a post called “Transact SQL Constructs Not Supported by In-Memory OLTP” which stated the following:

  • DBCC CHECKDB skips the memory-optimized tables in the database.
  • DBCC CHECKTABLE will fail for memory-optimized tables.

Read More »DBCC CheckDB and CheckTable doesn’t check In-Memory OLTP.

Visualizing VLF’s – Updated

A while back a wrote a blog post with a query to Visualize the VLF’s in your database. Today I have an update to that script.

Here is an updated script that has adds another column called “TextStatus” to the output to give you a better idea of what the different statuses mean. You now get 3 statuses shown, “In Use”, “Available”, and “Available Never Used”. The If you have lots of VLFs that are “Available Never Used” that may be an indication that your log file may be larger than you need. If you don’t have any that are “Available Never Used” the log may be smaller than you need.

Read More »Visualizing VLF’s – Updated