My name is Steffi. I started to work for SAP as support engineer for SAP Business ByDesign and SAP Cloud for Customer in Galway, Ireland in 2019. After two years, I transitioned to a new role as Developer in St. Leon-Rot, Germany. Here, I am responsible for designing, developing, enhancing, and supporting monitoring and administration tools for SAP Adaptive Server Enterprise database.
In this article, I will provide you an overview of some of the new features and enhancements of the DBA Cockpit for SAP Adaptive Server Enterprise in the past two years.
In the Diagnostics Menu, there is a new screen called Missing Statistics. This screen is based on the configuration parameter Capture Missing Statistics and on the system table sysstatistics. Once Capture Missing Statistics is enabled, this screen shows:
This screen features the possibility to activate and to deactivate Capture Missing Statistics ad-hoc and on an hourly basis (with the help of the SAP ASE Job Scheduler). In addition to it, there is also a possibility to jump to the Single Table Analysis Screen and to update statistics directly from this screen.
More information about the topic Missing Statistics will follow in a separate blog article.
In the Diagnostics menu, there is another new screen called SSL Certificates that shows:
This information comes from the table master..monSSLCertInfo which provides information about installed SSL certificates. The screen features a filter on end date to sort the end date in a way that the certificate with the smallest end date is at the top of the overview.
The reason for the re-design of the screen Dump History was that a new API to retrieve information on backups has been made available with the introduction of BALDR. The screen Dump Overview located below the Backup & Recovery Menu will provide the time of the last successful dump as well as the time elapsed since the last successful dump for each database of the database server and for each type of dump:
The screen Dump History features a summary of the number of the failed as well as of the successful database and transaction dumps, a filter to get all dumps for a specific database and for a specific status. The overview table is split into Database Dump tab where database dumps, cumulative dumps, and delta dumps and Transaction Dump tab where Transaction Dump can be monitored for a specific time frame.
If a dump with the status failed is selected in the table, it will also display an error code and description.
For all database systems where the owner of the DBA Cockpit is Baldr we show the Baldr Version on the Instance Overview Plugin and on the screen Data Collectors and Admin Procedures. For older systems where the owner is not Baldr it shows that the information is not applicable.
The Replication Plugin on the Dashboard was split into three views:
The first view will show the logical host, the HADR State and the HADR Mode. The second view will show the site 1 & site 2 as well as the Synchronisation State and the Synchronisation Mode. The third view will show the same information like the second view, but for the site 3 (if existing).
The screen IMRS Caches located in the Configuration Menu will provide an overview of the IMRS caches that have been created on a specific database system. It shows
This information comes from the table master..monIMRSCache. On this screen, you can create a new IMRS cache, change the current size of an existing IMRS cache or change the assigned database, and remove an existing IMRS cache.
Information on memory usage such as the number of rows in the cache, number of rows packed by the pack operation can be accessed via the IMRS Cache Usage screen located below the Performance Menu. This information comes from the table master..monIMRSCacheActivity which stores statistics related to In-Memory data caches.
It is possible to select and delete multiple rows at the same time on this screen.
This was a short overview of some of the new screens and enhancements of the DBA Cockpit for SAP Adaptive Server Enterprise. Which of these features and enhancement do you like? And which of these features are you planning to use? Would you like to get more information about one of these topics? Let me know in the comments. To stay current about SAP Adaptive Server Enterprise, please consider following the topic page here. Or you can also read other blogs related to SAP Adaptive Server Enterprises here. If you have a question related to this topic, you can post it here.
In this article, I will provide you an overview of some of the new features and enhancements of the DBA Cockpit for SAP Adaptive Server Enterprise in the past two years.
Missing Statistics
In the Diagnostics Menu, there is a new screen called Missing Statistics. This screen is based on the configuration parameter Capture Missing Statistics and on the system table sysstatistics. Once Capture Missing Statistics is enabled, this screen shows:
- the Date the statistic was reported as first time missing,
- the Database,
- the Table name,
- the Column name(s), and
- the Number of times the statistic was counted as missing.
This screen features the possibility to activate and to deactivate Capture Missing Statistics ad-hoc and on an hourly basis (with the help of the SAP ASE Job Scheduler). In addition to it, there is also a possibility to jump to the Single Table Analysis Screen and to update statistics directly from this screen.
Figure 1: Features of the Screen Missing Statistics
More information about the topic Missing Statistics will follow in a separate blog article.
SSL Certificates
In the Diagnostics menu, there is another new screen called SSL Certificates that shows:
- the file path,
- the start date, and
- the end date of the SSL certificate.
This information comes from the table master..monSSLCertInfo which provides information about installed SSL certificates. The screen features a filter on end date to sort the end date in a way that the certificate with the smallest end date is at the top of the overview.
Figure 2: Screen SSL Certificates
Dump Overview & Dump History
The reason for the re-design of the screen Dump History was that a new API to retrieve information on backups has been made available with the introduction of BALDR. The screen Dump Overview located below the Backup & Recovery Menu will provide the time of the last successful dump as well as the time elapsed since the last successful dump for each database of the database server and for each type of dump:
- database dumps,
- cumulative dumps,
- delta dumps, and
- transaction log dumps.
Figure 3: Screen Dump Overview
The screen Dump History features a summary of the number of the failed as well as of the successful database and transaction dumps, a filter to get all dumps for a specific database and for a specific status. The overview table is split into Database Dump tab where database dumps, cumulative dumps, and delta dumps and Transaction Dump tab where Transaction Dump can be monitored for a specific time frame.
Figure 4: Screen Dump History
If a dump with the status failed is selected in the table, it will also display an error code and description.
Figure 5: Error Information
Baldr Version
For all database systems where the owner of the DBA Cockpit is Baldr we show the Baldr Version on the Instance Overview Plugin and on the screen Data Collectors and Admin Procedures. For older systems where the owner is not Baldr it shows that the information is not applicable.
Figure 6: Baldr Version
Synchronisation State & Mode
The Replication Plugin on the Dashboard was split into three views:
- HADR Overview,
- HA/DR: HA Status, and
- HA/DR: DR Standby.
The first view will show the logical host, the HADR State and the HADR Mode. The second view will show the site 1 & site 2 as well as the Synchronisation State and the Synchronisation Mode. The third view will show the same information like the second view, but for the site 3 (if existing).
Figure 7: Replication Plugins
IMRS Cache
The screen IMRS Caches located in the Configuration Menu will provide an overview of the IMRS caches that have been created on a specific database system. It shows
- the Cache name,
- the Cache size,
- the Used Size,
- the database name, and
- the status.
This information comes from the table master..monIMRSCache. On this screen, you can create a new IMRS cache, change the current size of an existing IMRS cache or change the assigned database, and remove an existing IMRS cache.
Figure 8: IMRS Cache Configuration
Information on memory usage such as the number of rows in the cache, number of rows packed by the pack operation can be accessed via the IMRS Cache Usage screen located below the Performance Menu. This information comes from the table master..monIMRSCacheActivity which stores statistics related to In-Memory data caches.
ATM Queue
It is possible to select and delete multiple rows at the same time on this screen.
This was a short overview of some of the new screens and enhancements of the DBA Cockpit for SAP Adaptive Server Enterprise. Which of these features and enhancement do you like? And which of these features are you planning to use? Would you like to get more information about one of these topics? Let me know in the comments. To stay current about SAP Adaptive Server Enterprise, please consider following the topic page here. Or you can also read other blogs related to SAP Adaptive Server Enterprises here. If you have a question related to this topic, you can post it here.
- SAP Managed Tags:
5 Comments
