SQLDBManager Plus monitors sql queries plans in a MS SQL database. This allows the DBA to find out which plans are being used the least. Thus the DBA can further optimize these plans and ensure that they are used correctly. The Cache Object Type enables the DBA to find out if the query plans are being compiled every time every time they are used. By providing details such as this, the DBA can ensure that each query plan is being properly executed without affecting the performance of the database. SQLDBManager Plus monitors the following performance metrics:
- Plan Usage
- Cache Object Type
- Query
- DB Name
- Last Execution Time
