Glad to be of help. Wish I could say that it never happened to me but I have left that off a time or two and impacted users as well....

Read my previous post. Your index rebuild statement was not indexing online and would thereby kill any activity on the table being indexed.

ichbinraj (5/5/2009)

---

Hi experts,

I am running this following statement on my production . which is critical production box

I want know before running this statement on my box in the evening...

Agreed, SAN "snapshotting" is the way to go, especially considering the growth that you are looking at. Interesting struggle that you are running into with your vendor, somewhat disappointing to...

On the two 2008 instances that I have I show the checkpoint process there all the time on both. The one is working fine as I mentioned in my previous...

You should see that counter reading 0 for the most part but then periodically it should shoot way up as the checkpoint process actually...

Can you post information on the partition scheme and function as well? Did you partition both the _archive and _live tables?

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 is not...

David Benoit (5/1/2009)

---

I can't view that zip file. Not sure why. What are you zipping it with? If I just click on it I get an xml view of the...

I can't view that zip file. Not sure why. What are you zipping it with? If I just click on it I get an xml view of the plan in...

george sibbald (5/1/2009)

---

remove the need to monitor the log space used from the procedure by setting up a performance alert in SQLAgent to backup the log when it reaches a...

balbirsinghsodhi (5/1/2009)

---

Sorry about that. Here is the attached sqlplan file.

I rename to zip file because this website does not upload sqlplan file. please rename back to sqlplan extention so that...

Are you suffering from IO latency? Also curious what your CPU looks like. Can you provide some of that information?

I'm a pretty visual person so, could you attach the estimated (or actual) execution plan. Under Query > Display Estimated Execution Plan (or Cntrl L). Right click in the plan...

This definitely seems like a "case for cursors". 🙂 They're not always bad, especially for maintenance tasks. As GSquared stated you could execute log backups periodically if needed to avoid...