Here is what I'm running to get the cached plan for the proc of interest:

DECLARE @procName VARCHAR(1000);

SET @procName = '%xxxxxxxxxxxxx%'

SELECT

P.usecounts

,P.plan_handle

,H.query_plan

,LEFT([sql].[text], 1000) as [text]

FROM

sys.dm_exec_cached_plans P

CROSS...

Thank you, I'm actually looking at a cached plan but can't find an XML tag called PARAMETERLIST.

I also looked for "ParameterCompiledValue" but got no hits in the XML.

I should also mention that there is no other session currently running on the user database except for CHECKPOINT, so there is no user activity, neither has there been any...

But is it normal to have this SPID continuously running for so many days?

I actually issued the CHECKPOINT command and did see a spike in the perfmon counter, after which...

I'm getting 0 Checkpoint pages/sec

David Benoit (5/1/2009)

---

Marios Philippopoulos (5/1/2009)

---

I can actually do backups of the db on which the CHECKPOINT is running and run DBCC commands.

It seems the CHECKPOINT session is just hung and...

SQLBOT (4/30/2009)

---

Don't wait around too long.

IF a checkpoint is stuck that means you can't get a backup. can't run a dbcc, etc.

I've had this happen once, tried everything...

Not sure if it is an IO problem.

CPU...

SQLBOT (4/30/2009)

---

Don't wait around too long.

IF a checkpoint is stuck that means you can't get a backup. can't run a dbcc, etc.

I've had this happen once, tried everything...

Thanks for all the info!

Slightly off topic, but what other issues...

David Benoit (4/30/2009)

---

I have seen this too but only on a virtual server. I moved the database to a similarly configured physical and didn't have the issue.

I have a...

No, it's a physical server.

Thomas LaRock (4/28/2009)

---

did you also look through the discovery management packs? the SQL packs usually are in pairs, one for dscovery, one for monitoring. do a quick search through all...

I'm currently having a performance problem related to SCOM that I'm trying to resolve.

Procedure sp_spaceused appears to be consuming a lot of tempdb space in my SQL 2000 instance, to...