Does anyone have some type of monitoring and alerting for database integrity checks on their SQL servers.

I am trying to setup alerts right now for last backup and issues found with the DBCC. I was able to find an item in the app insight for SQL that reports on the # of days since the last backup, but i have not found anything that seems to report on the results of the DBCC. Any ideas on how to get this setup as easily as possible would be appreciated.

Well I don't believe sql has any existing counter for numbers of errors found or repaired in DBCC processes, so therefor Solarwinds can't pull the value of that counter directly, so yeah you are going to have to script it one way or another.

If I was going to do this I would probably use a combination of posh and sql scripting to gather what I wanted and get it into solarwinds, but that is just because those are the places I'm most comfortable, lots of other approaches you could take. I don't recall off the top of my head which tables contain the sql error logs but to parse out the number of errors I would try something to the effect of:

Use a similar type of logic to figure out the number of repairs, then you could either take those values directly into solarwinds with a sql user experience monitor or you could get fancier and identify specifically the difference between the two and only include entries where there is a difference.

Keep in mind that I'm not on VPN and that is just off the top of my head so double check your syntax and such, but conceptually it should work.

If the server has multiple databases you might need to come up with a scheme to break those apart but that should get you in the right ball park.

Actions

More Like This

Retrieving data ...

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining.

SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website,
you consent to our use of cookies. For more information on cookies, see our cookie policy.