 |
 |
Archives of the TeradataForum
Message Posted: Fri, 07 Aug 2009 @ 07:37:06 GMT
| Subj: | | Re: Get History of blocking. |
| |
| From: | | Ronald Montemayor |
Robert D Meunier wrote:
| | 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. | |
I assume that a person is always manning and watching the screen, correct?
You mentioned about parsing the, is this saved into a file somewhere?
Thanks
| |
