<div>
You're right. &nbsp;It cannot be killed. &nbsp;Your only option may be to stop and start SQL services. &nbsp;<br />
<br />
Greg<br />
<br />
<br />

</div>


You're right.  It cannot be killed.  Your only option may be to stop and start SQL services.  

Greg




<div>
thanks Greg, do you think since checkpoint is stuck, I am going to have loss of data?<br />

</div>


thanks Greg, do you think since checkpoint is stuck, I am going to have loss of data?


<div>
I tried manual checkpoint but it doesn't work... when I check the activity monitor, it shows that spid 10 is blocking it... (which is the same checkpoint when i run sp_who)...<br />
<br />
the database is in simple recovery mode, would that still work with restarting the database and reading it off of transaction log?<br />
<br />
Regards,
</div>


I tried manual checkpoint but it doesn't work... when I check the activity monitor, it shows that spid 10 is blocking it... (which is the same checkpoint when i run sp_who)...

the database is in simple recovery mode, would that still work with restarting the database and reading it off of transaction log?

Regards,

<div>
The recovery model doesn't matter at this point. &nbsp;This is a core function of SQL server to maintain data consistency. &nbsp;<br />
<br />
Greg<br />
<br />
<br />

</div>


The recovery model doesn't matter at this point.  This is a core function of SQL server to maintain data consistency.  

Greg




<div>
Ok, I am gonna try and see where It ends up<br />
<br />
Thanks for help!
</div>


Ok, I am gonna try and see where It ends up

Thanks for help!

<div>
Greg, thanks for your help, much appreciated<br />
<br />

</div>


Greg, thanks for your help, much appreciated



<div>
<div class="content wysiwyg-content">
Hi Experts, I ran SP_Who (since the server is crawling) and saw spid10 (checkpoint) is running in the background, it cannot be killed since it is not a user sp... but nothing else works (tried to do dbcc checktable and is being blocked by that spid10,) all selects from that table timeout as well... how do I fiX<br />
<br />
TIA...<br />

</div>
</div>


Hi Experts, I ran SP_Who (since the server is crawling) and saw spid10 (checkpoint) is running in the background, it cannot be killed since it is not a user sp... but nothing else works (tried to do dbcc checktable and is being blocked by that spid10,) all selects from that table timeout as well... how do I fiX

TIA...


Checkpoint is blocking other processes (background checkpoint)

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.