The key monitoring capabilities for SAP HANA database encompass

1. Comprehensive Visibility: Monitors On-Premises, Cloud, and Container Database KPIs and Metrics, ensuring a holistic view of performance.
2. Secure Global Access: Offers secure web access to database performance data from any data center, supporting global monitoring.
3. Historical Metrics Access: Enables access to historical metrics even when the HANA Database is offline, using features like Flashback or Time Slicing for past analysis.
4. Reporting for Compliance: Generates audit reports to meet security and privacy compliance requirements, tracking SQL, login issues, and more.
5. Health Window: Monitors critical aspects like CPU usage (User/System/Wait), volume I/O, memory usage, memory components, and instance information.
6. Top Column Store Tables: Provides insights into column store table memory usage (actual, estimated, delta), status of delta merges and loads, and memory breakdown.
7. Currently Running: Displays active statements, SQL plans, ongoing operations, transactions, delta merges, and loads on column store tables.
8. Space Usage: Monitors memory utilization (overall, column store, service memory), disk and volume usage (data vs. log), and transaction-related metrics.
9. Connections: Tracks network I/O, app tier connections, login details, current SQL, and SQL plans.
10. Configuration: Offers insights into default, system, host, and tenant configurations.

This comprehensive suite of monitoring capabilities ensures efficient management, optimization, and security of SAP HANA databases across different deployment scenarios.

Product Functionality

Surveillance RS Features

Advanced Latency Monitoring: Utilize RS_TICKET for real-time data flow optimization.
Efficient Queue Management: Easily dump queue contents from Surveillance Health View for a smooth data pipeline.
Metadata Accessibility: Access critical information through the monitor GUI.
Comprehensive Replication Agent View: Gain insights with ASE statistics, status, and configuration data.
Precise Queue Analysis: Analyze transaction blocks in the queue, optimizing data flow.
Exception Handling: Navigate through enhanced views for prompt issue resolution.

Key Alerts

RepServer Status: Instantly detect RepServer issues for uninterrupted data replication.
Thread Health: Receive alerts for Replication Server thread problems.
Partition Monitoring: Stay proactive with alerts for partition space usage and growth rates.
Queue Length Management: Prevent excessive queue growth with alerts.
Throughput Optimization: Receive alerts when throughput falls below expected levels.
Memory Efficiency: Gain insights into memory usage with alerts.
Exception Tracking: Stay informed about new exceptions and errors for effective troubleshooting.

ASE Monitoring

Primary Database:

Real-time Agent Tracking: Monitor replication agent processing time and transaction log for data availability.
Log File Growth: Track log file growth rate and utilization for preemptive availability alerts.
Replication Agent Status: Detect disruptions in streaming transaction log.

Replicate Database:

DSI Thread Health: Get alerts for excessive blocking or log suspension in DSI executor threads.
Latency Management: Visualize transaction latency and receive alerts for excessive delays.
Transaction Tracking: Stay alerted to incoming transactions and communication issues.
Log Utilization: Monitor transaction log utilization, avoiding capacity concerns.

Experience a new era in database monitoring with our revamped Microsoft SQL Server solution, meticulously designed for diverse database landscapes. Monitor any SQL Server performance counter, ensuring adaptability across a variety of database environments.

Gain a holistic view of your infrastructure with enterprise-wide, dashboard monitoring. Stay informed about the real-time status of servers and entities at a glance. Stay ahead of potential problems with pre-defined or customizable rules, enabling Database Administrators (DBAs) to receive proactive alerts and address issues before they impact the database.

Dive deep into the historical snapshots of real-time data using Data FlashBack. Identify the root cause behind system slowdowns or outages with precision. Effortlessly generate high-quality reports from the Surveillance Centralized Repository Database, tailoring reports to specific platforms with a range of pre-defined options.

List of Features and Metrics:

Health Window: Top-level view of performance and utilization metrics, including database and log segment usage, CPU, IO, cache performance, top timed event statistics, Tempdb Storage, and currently executing long-running SQL queries.

User-Specified Monitoring Metrics: Support for DMVs, direct counters, and system tables, offering versatile monitoring options.

Timed Event Monitoring for SQL Server and Processes: Keep track of timed events for SQL Server and processes.

Process Overview: Detailed insights by user, active processes, waiting processes, databases, logins, and more.

Globalstatistics Graphs: Visual representation for easy analysis on CPU,IO,Processes,jobs,locks and more

Blocked Process View: Graphical display for quick identification and resolution of blocked processes.

Process Detail Drilldown View: In-depth analysis of individual process performance.

Database Storage Analysis: Identify and manage capacity issues for optimal performance.

Snapshot of Executing SQL and SQL History: Resolve performance issues with insights into executing SQL, historical statements and SQL plan

Errorlog Analysis: Thorough scanning for important error messages to ensure system health.

AG Group Monitoring: Specialized features for monitoring AG (Availability Group) environments.

Database and Filegroup Usage: Detailed monitoring of database and filegroup usage inlcuding index statistics.

Elevate your monitoring capabilities and gain a deeper understanding of your system’s performance across diverse database environments. Experience the power of proactive resolution and precision monitoring with our comprehensive solution.

Key Features and Benefits for MySQL

1. Real-Time Monitoring: Surveillance DB provides real-time monitoring capabilities, allowing you to keep a constant watch on your database’s performance and health.

2. Event Management: Surveillance DB offers robust event management features, making it easy to schedule and automate tasks within your database.

3. Historical Data Analysis: Surveillance DB, you can analyze historical data to gain insights into past database performance and trends.

4. Forensic Analysis: Surveillance DB forensic analysis tools enable you to investigate and troubleshoot database issues, helping you identify and resolve problems efficiently.

5. Overall Health Insights: Gain a comprehensive view of your database’s overall health, including instance information, activity monitoring, statement timings, disk I/O statistics, and logical reads.

6. Detailed Process Information: Surveillance DB provides detailed process information, giving you insights into what’s happening at the individual process level within your database.

7. Statement Execution and SQLTEXT: Easily track and analyze SQL statement execution, allowing you to optimize query performance and troubleshoot issues effectively.

8. Engine Utilization: Monitor and optimize the utilization of database engines to ensure optimal performance and resource usage.

9. Configured Resources: Keep tabs on your database’s configured resources to ensure they align with your application’s requirements and make necessary adjustments.

10. System Settings Management: Surveillance DB allows you to manage and adjust system settings to fine-tune database performance and meet specific workload demands.

In summary, Surveillance DB offers a powerful set of features and benefits for real-time monitoring, historical analysis, and overall database health management, making it a versatile and reliable choice for database administrators and developers.

Key Benefits

Surveillance DB for PostgreSQL Key Benefits

Proactive Issue Reporting.Automated monitoring ensures real-time detection of issues within PostgreSQL databases, providing immediate alerts and reports for timely responses to maintain database health.

Continuous Database Uptime.Surveillance DB unattended monitoring guarantees uninterrupted operation of PostgreSQL databases, supporting various company solutions and ensuring business continuity.

Detailed Process Monitoring.Gain unparalleled insights into database processes, including active transactions, locks, and blocked processes, facilitating a deep understanding of system behavior for effective optimization.

Current Executing Statements.Real-time visibility into actively executing SQL statements enables immediate troubleshooting, allowing quick identification and resolution of performance bottlenecks.

Open Transactions Management.Monitor and manage open transactions to prevent issues related to data consistency, ensuring the smooth operation of concurrent transactions within the database.

Locks and Blocked Processes.Identify and address locking issues and blocked processes promptly to enhance system responsiveness by resolving contention for resources.

Database Overview.Obtain comprehensive insights into the status of all databases, including size, connections, and usage, facilitating efficient resource allocation and management.

Tablespace Monitoring.Monitor and manage tablespaces for effective storage utilization, ensuring optimal performance through organized and efficient storage management.

System Settings.Access and modify system settings to align PostgreSQL with organizational requirements, allowing for tailored configurations for optimal performance and resource utilization.

Recently Executed Statements. Track and review recently executed SQL statements for debugging and analysis, enhancing visibility into database operations for troubleshooting.

Top SQL Over Time.Analyze and address the most resource-intensive SQL queries over time, optimizing query performance for sustained efficiency.

Surveillance DB provides a robust solution for ensuring the continuous operation of databases. With detailed insights into processes, transactions, and system settings, organizations can proactively address issues, optimize performance, and maintain reliable and efficient PostgreSQL-based solutions. Single Solutions for all versions of PosgreSQL

Feature Set for Informix

1. Global Statistics: Monitor and analyze CPU usage, buffer utilization, lock activity, ISAM access, deadlocks, and more for comprehensive database performance insights.
2. Session Management: Gain visibility into active sessions and their details, allowing you to track resource usage and troubleshoot performance issues effectively.
3. Lock Monitoring: Easily identify and manage locks in real-time to prevent contention and optimize database performance.
4. Blocked Sessions: Quickly identify and resolve blocked sessions to minimize disruptions and maintain a responsive database environment.
5. Statement Executions: Track statement executions and access their SQL text to pinpoint and optimize resource-intensive queries.
6. DBSpaces & Partitions Stats: Monitor database storage and partition statistics to ensure efficient data management and allocation.
7. Chunkspace Analysis: Analyze chunk I/O activity to optimize storage and ensure data availability and reliability.
8. Buffer Pool Management: Fine-tune buffer pool settings to optimize data caching and improve query performance.
9. Table Activity: Keep an eye on table activity and partitions to identify hotspots and optimize data distribution.
10. Table Statistics: Access table statistics for daily, weekly, and monthly performance trends to make informed decisions on indexing and optimization.
11. Configuration Settings: Easily review and modify configuration settings to tailor the database environment to your specific needs.
12. Recent Executed SQL: View recently executed SQL statements to troubleshoot issues and improve query performance.
13. SQL Analysis by Timerange: Analyze SQL queries based on specified time ranges to identify trends and performance variations.
14. Top SQL Queries: Identify top SQL queries based on average elapsed time to prioritize optimization efforts effectively.

Inventory Management

Stay on top of every aspect of your inventory in every geographical location. Your agents can track each asset that is in use, offering visibility throughout the lifecycle of the asset.

ITCC is highly customizable. System administrators can define the different types of assets that are being managed and the categories for each asset type. The system also allows for custom attributes of each asset type, including both data input from scanning tools like IP addresses and Bios, as well as manually input data like invoice numbers or warranty information.

The robust inventory management tool tracks asset changes, such as ownership and location. It also assigns assets to inventory locations, so you can easily find the assets that have returned.

Your IT team can use the system to manage inventory levels, set minimum stock numbers, and manage cycle counts. They can also create barcodes for each asset, making it easier to track assets.

The system maintains a log for every asset, including software assets, providing a complete history of the company’s IT assets

Fully Integrated Modules

Improving IT Efficiency and Automation

Your organization’s service catalog can be created in just minutes, helping to automate repetitive processes throughout the company.

The IT team can create custom, multi-stage workflows with approval tasks to speed up fulfillment. These custom workflows can fully automate processes, such as a new hire process, to ensure that onboarding runs smoothly.

IT members can create dynamic forms per catalog request, and attach SLAs to the different activities, ensuring processes are completed on time. They can approve requests via email, as well as add links to external forms that function as catalog requests.

Integration

The Service Catalog item’s workflow can launch REST APIs and automate processes from end-to-end.

End-User Experience
The Service Catalog module creates an improved user experience for all users within the organization. The self-service platform is searchable, and only displays services that the user is entitled to, based on role. End users are also able to create and track service requests, providing them with full visibility into the status of their requests.

Analytics
The Service Catalog’s robust analytics features allows IT to measure the services they provide, as well as calculate and track the cost of those services.

Informational Accessibility Throughout the Organization

Designed to make information available to end-users, agents, and technicians, items are published in a variety of formats, making it easy for team members to find solutions to their issues.

The system uses Google search tools, accessible to both end-users via the portal and help desk agents through ticket assistance. All knowledge items, which include documents, articles, and email messages, are indexed by the system, enhancing search results.

Knowledge Base Management

This module is ideal for both self-service and technician-aided interventions, thanks to a robust management system. The system associates knowledge base articles to the different service categories and classifies each item as a resolution, workaround, known issue, or other organizational categories.

Knowledge base items include HTML-based articles, email that is converted into articles, and document attachments, including Microsoft Office or PDF files.

IT departments have the option to maintain advanced technical solutions that are only accessible by authorized technicians, which can help reduce resolution times. They can also document solutions for repeating issues.

Project Management

Our searchable knowledge base assists end-users in handling their own issues without opening tickets. It also provides helpdesk workers with a repository of information that they can use to resolve issues. All users can check their history, making it easy to find solutions to problems they have searched for in the past.

Continuously Improving Knowledge Management Process

Users who try the solution can send comments to the knowledge item contributor. Feedback can be used to update out-of-date solutions, help clarify directions, and improve the user experience.

Detect Problems

Problems are detected in a number of ways, including through integration with the Incident Management module. Problems can also be entered manually, through a Problem Record. Problem Records include the impact of the problem, the urgency for resolution, and a priority level.

The system is also capable of detecting problems proactively, through a process called incident trending.

Logging Problems

Each problem is logged in the Problem Management module. Logs enable users to attach documents and configuration items (CI), as well as problem management processes that can be used to resolve the issue.
Closing Problems
Once problems are resolved, the system sends notifications to affected parties, informing them of the solution. The system also generates both category-based trend reports and incident related reports.

Investigation and Diagnosis

The system enables your team to perform an investigation into the root cause of the problem. It provides access through search functionality to historical records, as well as known error data, both of which can be used during the investigation.

Findings from the investigation are recorded in the log and can be used to prevent similar IT infrastructure issues from arising in the future.

Any workarounds that are found to deal with the issue are also recorded in the Problem Management module, providing a fast solution if the problem should occur again.

Major problems can be escalated using the module’s configurable escalation rules, reassigning the problem to more experienced problem resolution teams. The system also facilitates management and documentation of major problem reviews.

The system maintains a tiered problem classification schema, allowing for the identification of a problem with a service, system, and component. Problems are classified by category and can be attached to a service or CI, ensuring that the classification is consistent across the organization.

Measure and Improve Your SLA

These management tools ensure that your team meets their agreed-upon SLA in every circumstance. The system enables users to define their response and resolution SLA KPIs to meet the organization’s or specific department’s needs.

Once a ticket has been opened, there are multiple protections in place to protect against SLA violations. Predefined escalation paths are put in place to ensure that tickets requiring a higher level of assistance are directed to the right help desk expert. Help desk agents also receive alerts as they are approaching the SLA deadline. Additionally, the system’s online dashboard provides teams with a real-time view of tickets, further ensuring that incidents are resolved on time.

Upon closing a ticket, users are prompted to answer a satisfaction survey, providing critical feedback to the help desk agents. The fast response and commitment to meeting SLAs drive an improved user experience throughout the organization.

Improving Up Time with a Comprehensive Self Service Knowledge Base

Our searchable knowledge base assists end-users in handling their own issues without opening tickets and provides helpdesk workers with a repository of information that they can use to resolve issues. Users can also check their history, making it easy to find solutions that they have researched in the past.

Knowledgebase items are organized by category, in a question-answer format. The self-guided solutions provide step-by-step instructions for resolution.

Flexible Configuration

Our incident response module makes it easy to configure the intake form based on your organization’s requirements. System administrators can create new call types and configurations, as well as add new fields for each call type.

To improve efficiency and effectiveness, each call type can have its own SLA and escalation rules. Email templates can also be associated with specific call types.

Utilize an Omnichannel Incident Management Solution

System users can reach out to the IT Help Desk and open incident tickets using a number of channels. Incident reporting can be done via email, mobile device, or the self-service portal (including our user-friendly chatbot).

Emails are automatically converted into incidents, as the system uses keywords to route the incident into the correct category and support group.

Enabling Self Service for Improved User Experience

The self-service portal empowers end-users to resolve their own issues and stay informed when incidents need IT assistance.

In the portal, users can submit any incident and gain visibility into both the status and progress of their ticket. Any email exchange between the portal and an end-user is captured in the incident log.

The knowledge base is part of the self-service portal, providing categorized topics that are searchable, allowing users to resolve their own issues without turning to the IT help desk.

The portal is configurable and can be customized for different departments within an organization. It also includes a chatbot, which can aid end-users as they try to resolve issues they are facing and templates, which can be used to make engagements run more efficiently.

After using the system, users are asked to respond to a satisfaction survey, enabling the IT team to monitor the effectiveness of the portal.

Improving Agent Efficiency

The Incident Management module was designed to improve your agent efficiency. It assists agents throughout their response, by providing customer configuration items (CI), related asset data, and similar incidents that have happened in the past.

Tickets are managed using a drag-and-drop interface, and each support team member can view the tickets in their queue. When needed, tickets can be reassigned or escalated, and new sub-tasks can be added without reassigning the case. Dynamic, self-defined grids simplify agent views into incidents.

Administrators can create incident templates for the most common types of incidents and can open new incidents using templates.

When multiple tickets stem from a single incident, or if multiple incidents stem from a related problem, all tickets can be worked on simultaneously and resolved at the same time.

If an incident is resolved upon opening the ticket, Help Desk members can open and close the ticket at the same time. When closing a ticket, the system enables root-cause analysis (RCA) to give you a better understanding of the source of your incidents. Easy-to-use templates are available when closing tickets, allowing agents to meet SLAs by saving time with their responses and quickly moving on to the next incident.

The portal makes it easy to create chatbot-driven resolutions, document solutions for repeating issues, and prioritize issues by category. The analytics engine shows opportunities for individual and group improvement.

Maximizing Automation

Automation is a key element of the Incident Management module, improving work processes, and eliminating repetitive tasks so your agents can focus on resolving issues.

Dynamic routing rules automatically assign incidents to agents as soon as they are created. Incidents that are emailed to the team are automatically routed to the right agent using keywords and rules. As incidents near their SLA, escalation paths are automatically generated to ensure an on-time resolution.

For incidents that can be resolved by end-users, the steps required to resolve the issue are automatically sent to the user. Templates are automatically generated and used for notes, resolutions, and reassignments.

Major incidents involving multiple reported issues can be updated on one single record, and automatically updated on all related incidents.

End users and agents receive automated notifications and status updates as incidents are processed, and when relevant, the knowledge base is automatically updated with new solutions.