Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2014
    Posts
    3

    Unanswered: DBCC and update stats are running Very Slow in ASE

    Hi,
    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.

  2. #2
    Join Date
    Dec 2013
    Posts
    14
    Are you guys having disk/san issues ?
    How is the iowait ??

  3. #3
    Join Date
    Jan 2014
    Posts
    3

    DBCC and update stats are running Very Slow in ASE Reply to Thread

    Hi,
    Thanks for your reply.
    As part of quarterly server restart plan, we restarted the server.That solved the issue. Now, everything is in place.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •