Post reply

How to check if indexing is running?

  • March 14, 2010 at 11:08 pm

    #142061

    I have reporting database, which is refreshed every 3 hour. I usually get a Transaction deadlock error whenever a user tries to generate a reporting.

    We have checked, it is when the indexing on the DB is running, the user gets this error.

    Now is it possible to check if the indexing is still running?

  • March 15, 2010 at 1:56 am

    #1133551

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic882719-360-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 15, 2010 at 2:15 am

    #1133554

    Mistakenly posted to Integrated Services section as this is no way related to it and didn't find any option delete the same.

    Sorry for creating confusion.

    Thanks,

    Ajit

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply