That is crazy, restart fixes everything! Thanks for the update Kumar, I'll remember this for the future.

Hi Kumar, you said that ghost records were going down when you monitored them and did update statistics and checked them again. So the ghost rows do seem to be...

What is the page_count of the indexes on the offending table?

What about avg_page_space_used in the NCIX?

Are there more databases on this server than the others? More load?

What is...

Hi Kumar, update stats isn't causing the rows to be deleted, just refreshing the view you have on the number of ghost records that exist. As the number is going...

What if you right click on the database and go tasks>shrink>files and select 'log' from file type drop down. What does it say in currently allocated space and available free...

Definitely read this if you haven't already, paul Randal seems to know an awful lot about this.

http://www.sqlskills.com/blogs/paul/post/inside-the-storage-engine-ghost-cleanup-in-depth.aspx

Is it only happening on one table?

Try running this a few times...

Are you sure ghost rows are not being deleted? we had a similar issue where a table was far larger than it should have been. This was caused by a...

Looks like the 2 groups don't failover together in case of a manual failover, you have to manually fail over each. It is whether you need to failover the quorum...

The developers have started saving packages to MSDB but there are some older packages they had saved to this disk location.

I have copied the packages to the same location...

Thanks Anthony that is spot on. As I feared the jobs exist on a disk that is not shared between the nodes in the cluster, as a result SSIS won't...

Thanks for your response Henrico. I understand that the resources belonging to each group will failover if I move the group. But as I have 2 separate groups, Cluster group...

We have three car parks at work, if you're early you get in the one closest to the building (a rarity for me!), reasonably on time you get in the...

Cool, thanks for the response Phil

haha, yeah probably Michael! I didn't hear anything either, must be for the same reason

I've sent in some pics as I am a keen cartoonist and also a DBA, the perfect combination! Just need some ideas...