Now at the conceptual stage this new class will offer temporary and permanent solutions to run time issues in Sybase. Problems to be analyzed will include –
- Poor query performance
- Indexing suggestions
- Update Statistics suggestions
- List of greatest offending N (or all) processes with cause(s)
- Immediate actions recommended and long term actions recommended
One purpose of this tool is to provide a view into current system performance such as in a commercial DB process browsing tool. Also it takes things a step further by automatically giving generic suggestions for improvement. It can be used in a normal perl script or plugged into a CGI based GUI to provide a snapshot of server processes.