MyDoggieJessie (8/24/2013)
Whenever I look at the SQL logs after a service restart I see that every database has had a checkdb run against it by a system spid ...
Nope. How long does a CheckDB take and how long does startup take? That alone should tell you that there's no checkDB running, startup does not take hours....
Starting up database 'X'.
Recovery is writing a checkpoint in database 'X' (10). This is an informational message only. No user action is required.
CHECKDB for database 'X' finished without errors on 2013-08-18 18:05:19.123 (local time). This is an informational message only; no user action is required
Look at the datetime stamps for the log entry and the time it list CheckDB having finished at.
From a database on my server (emphasis mine)
Date2013/08/21 14:57:35
LogSQL Server (Current - 2013/08/24 00:00:00)
Sourcespid20s
Message
CHECKDB for database 'Testing' finished without errors on 2012-08-28 22:10:11.457 (local time).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability