blocking

  • 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?

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

  • 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