February 3, 2014 at 1:41 pm
I have a SPID 18 doing checkpoing for a user database since last server reboot. There is no related error message on the SQL Server Error Log. How can I identify this problem? Thanks in advance
February 3, 2014 at 2:20 pm
If the database is online, and accessible to the users, I would say this is not a problem. The various system processes do what they do with really no intervention from the admins. You have not changed the server configuration for "recovery interval", have you?
February 3, 2014 at 2:23 pm
No, I didn't make any changes to the server configuration. The database is online, but the checkpoint process uses 171710191 CPUTime, 12279947 DiskIO, which makes me concerned.
February 3, 2014 at 3:20 pm
Those numbers (like all of the CPU and I/O numbers in the output of sp_who2) are cumulative for the life of the instance. They only matter if they are increasing very quickly in a short span of time.
February 4, 2014 at 7:54 am
So there is nothing I should do?
February 4, 2014 at 8:00 am
Grace09 (2/4/2014)
So there is nothing I should do?
This process is a background system process. SQL Server has this running in the background to cycle through your databases and ensure they are properly checkpointed.
As long as it is not blocking another process, or is not causing errors to be thrown, or (in some rare cases) blocking the log backups from occurring (which can happen if Antivirus is enabled and scanning your database files), then you don't have anything to worry about from this particular process.
In short, it sounds like you don't have any of the issues just mentioned and the checkpoint process is running normally. Therefore, you should have no real cause for concern on this process.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2014 at 8:03 am
Grace09 (2/4/2014)
So there is nothing I should do?
Why do you think you need to do something?
What led you to the conclusion that it has been actively running non-stop since the last restart?
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
February 4, 2014 at 9:48 am
When I ran sp_who2, the LastBatch column shows the date when we reboot the server.
February 4, 2014 at 10:46 am
Yup, that's how system processes run, they're in a permanent run/wait/run/wait cycle from the time an instance starts until it is stopped. If you look, all the system processes will have the same last batch 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
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply