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.