MSSQL 2008 Checkpoint process

This question has already been asked, but the answer didn’t give detail as to what the problem could be, so I’m asking the following.

Our application currently runs using SQL Server 2005. We are in the process of testing using 2008.

The application is used for bulk data changes and database merges. The application does not login to a database when it starts up, the user needs to select one to login to first to check that no others users are logged in. At this point, a Checkpoint process is started. So far we have left this to run for over 2 hours, and still it continues to run. Restarting the server service sometimes clears this process.

We have found a solution outside of the application. Using SQL Server Management Studio, we increase the DB’s log file Autogrowth %, and then decrease it back to the original value. We then restart the server service. The checkpoint process is no longer running on the DB and we’re also able to run a manual checkpoint process (Checkpoint 1) outside of the application with it completing.

When we use the application on the DB again, the checkpoint process starts up and continues to run.

Is this a problem with SQL Server 2008, or are there settings in 2008 that we can use? The only one I’ve found is the recovery interval, and from what I’ve read I don’t think it will resolve our current problem.

If this is a problem with 2008, we could make changes to our application to ignore the checkpoint process when checking for logged on users. Would this be a concern to have the process running in the background while the application runs. Our application allows users to change code values across several related tables and merge two database together. This process uses insert into.

more ▼

asked May 13, 2010 at 12:46 PM in Default

avatar image

Chris Dennis
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Sorry, I know this is an oldish question, but I'm curious as to why you want to run a checkpoint under that scenario?

more ▼

answered May 20, 2010 at 09:17 PM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

I'm not running a checkpoint manually, it's being run when I check whether there are users logged into the DB.

May 25, 2010 at 05:43 AM Chris Dennis

I must be missing something - what do you do that starts the checkpoint process then?

May 25, 2010 at 05:48 AM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 13, 2010 at 12:46 PM

Seen: 1901 times

Last Updated: May 15, 2010 at 08:03 AM

Copyright 2018 Redgate Software. Privacy Policy