Archives of the TeradataForum
Message Posted: Thu, 30 Jul 2009 @ 20:55:12 GMT
| Subj: | | Re: Get History of blocking. |
| |
| From: | | Robert D Meunier |
If you don't need to see all of the blocking that went on in your system, but just those that lasted for a long time, you can use the Session
Information application under the Monitor menu in Teradata Manager. Select a report type of Blocked and then under Tools select Log to File. Under
Tools -> Options I set the PC Refresh Rate to something like 5 minutes. Then if the same entries are in the log multiple times in a row you know
the blocking lasted longer the 5 minutes.
The down side to this is that you have to leave Session Information running all the time to log the information and you won't get the small
interval blocking that goes on. You'll also need to visually scan the log or write a script to parse it for you.
The up side is that you don't have to enable Locking Logger (you won't be able to at some sites/configurations) and take the performance hit
against your DBMS that Locking Logger adds.
If you can enable Locking Logger that will provide you with the best information, but if you can't this is a way around it. At least for
detecting long term blocking.
Robert Meunier
| 
