Thanks Mate . yes i can see io/cpu is changing so am sure its not hung.

cheers ,

Bhaskar

I ran the DBCC SHOWCONTIG   but want to know what value is the indication that things are not OK I see the following values - PagesScanned ,Extents Scanned, Extent Switches,Avg. Pages...

Ya the increase is there . last time it used to run for 4 min but this time it kept on running for around 6 hrs and brought down the...