SQL Database Performance Monitoring
SQLDBManager Plus displays in-depth information on Database Name, Data File Size (in MB), Percentage of Log Used, Status of Databases, Availability and Health of Databases, etc. Through 7/30 reports, you can identify the growth patterns for various databases and use it for capacity planning according to the need. In addition, the following performance metrics for Data File and Log File is also displayed in the Database tab.
By configuring alarm for specific databases which needs utmost care, DBAs can avoid cases where the database is full without his/her knowledge resulting in loss of queries or delays in query execution. By monitoring the percentage of log used, DBA can now ensure know before hand whether the particular database in question is being overused and if they need to increase the size of the database or not. This also presents the user with an insight into the growth patterns of the database and help re-design databases to perform more efficiently and effectively.
- Database Name
- Data File size (MB)
- Percentage of Log Used
- Creation Date
|
- Status
- Availability
- Health
- Ability to Configure Alarms for specific Database
|
SQLDBManager Plus also pulls in Log Shipping Status information for the DBA to view. It gathers information such as Database Name, Agent Type, Status, Time Elapsed (in min), Log Time, Error Log Time and Error Message.
