Unanswered: DBCC and update stats are running Very Slow in ASE
In my production server, we are used to maintenance activity on a weekly basis.The maintenance script does the followings:
1.reorg rebuild, update statistics and sp_recompile for all tables in all databases.
2.dbcc checkdb, dbcc checkcatalog and dbcc checkalloc for all databases.
Last week it took more than 1 day to complete all these tasks, earlier it was taking average of 3 to 4 hrs to complete.
We checked for any process which is blocking, any deadlock, CPU utilization, locking and it was normal.
Please suggest if you have came across this kind of situations.