Post reply

Trunc table intermittently runs very slowly

  • November 4, 2005 at 11:27 am

    #152608

    Good morning,

    Question:  What are the possible causes for a truncate table command from Query Analyzer to run slowly?

    Scenario:  We are using SQL 2000, running the command from QA with Admin privileges.  Ordinarily, truncating the table is virtually instantaneous, but sometimes it takes 1-3 minutes.  As far as we can tell, there are no other processes hitting these test tables.

    Right now, this is just an annoyance, but it would be good to understand what is going on.

    Thanks,

    Elliott

  • November 4, 2005 at 12:30 pm

    #602430

    I would guess the only reason for this would be some kind of blocking.  Next time you get this 3 minutes wait, run sp_lock to determine if your TRUNCATE TABLE is being blocked.



    A.J.
    DBA with an attitude

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

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