Table Execution taking time?

  • Hi Everybody,

    I have 65 tables in my DB,In that one of the table is taking time to execute ,Yesterday it was fine but today only am facing the Problem..

    is there any particular things need to check?

    Can anyone help me out.

    Regards
    Chowdary...

  • What do you mean 'one table takes time to execute'?

    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
  • @Gail,

    I am trying to Execute that particular Table like "select * from XXX" at that time it is taking time(aprx 30min)...

    Regards
    Chowdary...

  • And how many rows are in that table?

    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

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

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