![]() ![]() I’ll to show how the results look first, then how it is used afterwards. The idea is that this procedure is run every X seconds, minutes or hours and the result can be used to build graphs displaying what is going (if anything) on during a performance test, deployment or when troubleshooting system performance. ![]() The query this procedure uses are mostly already documented in my other blogs, and I’ve also added some that reads CPU usage that I found online at. You are most welcome to do so yourself, as well as modifying and improving it. It is also currently SQL Server only and as I’m leaving SAP the chances that I will be porting this to Oracle, DB2 or HANA are minimal. It’s using stuff, pivot and some other query types I’ve been testing for my own sake, and as such it may not be optimized. It can be used to detect bottlenecks, generate performance statistics, load predictions, and be a good utility for troubleshooting a system you have a halt situation or if the queue is moving along. I’ve made an experimental procedure that collects a number of what I think are useful counters about the provisioning queue and the state of the IdM system. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |