Often, someone will wish to somehow terminate a thread that is causing issues. These issues could be things such as blocking threads that prevent other threads from doing work, or something that is using a lot of CPU. While the…
AWR like jobs in SQL Server
This morning when I arrived at the office, there were several emails related to a high CPU utilization issue on a SQL Server that occurred around 4:45AM this morning. Since SQL Server 2005 does not have the anticipated performance repository…
Dump ATG publishing cluster state
The ATG publishing infrastructure maintains a cluster state file on each target. This is used to sync up with the Business Control Center (“BCC”) content, and ensure they match. When troubleshooting, it can be helpful to print the contents of…
Finding rows that were locked, after the fact
In the Oracle database, if you have purchased the tuning pack, you have full access to the DBA_HIST_% views. AWR, or Automated Workload Repository, is normally accessed via grid control or another tool. However, the raw data in the DBA_HIST…
Adding the session_id to JBOSS and the ATG order repository
We wanted to be able to track the path a shopper took through the initial order creation process in ATG. The IP address is often insufficient for reasons such as a shared internet connection, proxy server, etc. We extended the…
JBOSS – Which threads have a database connection checked out of the pool?
We had an issue in ATG which was eventually traced to deadlocked sessions on checkout, each of which was attempting to decrement inventory for SKU’s in opposite order. In other words, session one wanted to decrement inventory for A and…