We have a real challenge where we have a large developer community with a wide variety of experience. This has resulted in several occasions where someone has accidentally created an app that performs so badly that it slows the entire environment.
Does anyone have any recommendations in terms of both real time notifications and historic analysis.
What we really want to be able to do is have a notification that there is an issue (such as CPU going above a threshold) and then the ability to identify exactly which app is causing the problem so that we can reach out quickly to the owner.
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Monitoring all applications and servers is surely a good idea but IMO it's too late to prevent badly performing applications. Better would be to create a set of rules and conventions how to develop data-models (like only star-schemes, no synthetic keys / circular references, no island-tables) and UI objects (no aggr() and nested if-loops, no button magic). Further each application should be audited from a senior developer that the main-rules are properly considered.
