SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Checkpoint Background Process?


Checkpoint Background Process?

Author
Message
azenon
azenon
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

Group: General Forum Members
Points: 76 Visits: 301
Hi All,

I'm new to SQL DBA tasks. I noticed in sp_who2 output a database is showing checkpoint as shown below. Is this process hung since it shows date of 03/08/13? I assume checkpoint is a regular automatic process.

SPID Status DBName Command CPUTime DiskIO LastBatch
13 BACKGROUND Micro_AB CHECKPOINT 3861851 123296 2013/03/08 10:43

Thanks-

Alison
MyDoggieJessie
MyDoggieJessie
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6728 Visits: 7394
This is a rather long time to see a checkpoint running. Is it possible something BIG happened on that particular day?

Checkpoints occur (by default) all the time and are trigger by many internal SQL server operations.

Please check out this article, it might help you understand what is going on - http://msdn.microsoft.com/en-us/library/ms188748(v=sql.100).aspx

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" ;-)
jay81
jay81
SSC Journeyman
SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)

Group: General Forum Members
Points: 95 Visits: 243
I have had checkpoint process running into hours after nightly restores of some reporting databases. We figured that the issue was related to disk performance and it had to be resolved at that level. you can use perfmon to know the disk performance.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search