Does Spotlight run any integrity checks (dbcc checkdb)? (4332276)

There are a number of reasons why Spotlight don't run DBCC checkdb.

1. There haven't been any customers requesting it as far as we know.

2. The current architecture of Spotlight on SQL Server doesn't work well with long running tasks. Spotlight on SQL Server only executes one SQL statement at a time for a monitored instance so any long running statement will block other monitoring.

3. DBCC checkDB can be expensive and can block other processes. There are ways to circumvent this which mean simply running it against an instance may not be the best thing to do. See http://www.mssqltips.com/sqlservertip/2399/minimize-performance-impact-of-sql-server-dbcc-checkdb/