Post reply

blocking

  • August 7, 2012 at 11:27 am

    #260442

    Hello

    How to check blocking occurs in last days(means previous blocking)

    means i want to check transaction on Database for lat 3 days

    i check sql sever logs but it just for backup and restore only.

    is there other way to check transcriptional log with commands?

  • August 8, 2012 at 2:00 am

    #1522990

    Unless you have custom monitoring in place which captures blocking you will not find the information you require.

  • August 9, 2012 at 1:56 am

    #1523610

    you need to setup a trace file. Then you can analyze information from past transactions.

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

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