is it possible to report on the last time a database was consistency checked using appinsight for sql?

templar1980

I'm looking for a way to report on the last time a database was consistency checked using dbcc checkdb is this possible? Also is there a data dictionary I can download for SAM to help in writing queries for reports?

Thanks

Find more posts tagged with

sql

apm

report

Accepted answers

All comments

aLTeReGo

AppInsight for SQL does not perform database consistency checks, nor does it report upon the result state or when the last database consistency check occurred. This can however be theoretically accomplished using the SQL User Experience Monitor.

templar1980

Thanks for this. I'm not looking for AppInsight to run the checks but just report on the last time it was ran. I will give the SQL User Experience Monitor a try.

Thanks

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of