Microsoft SQL Server
By monitoring SQL from the AppManager® console, you can ensure your SQL database infrastructure is performing and available for end users. This module's extensive alerting capabilities inform you immediately when incidents arise so you can take action. By responding proactively, you reduce downtime and ensure compliance with Service Level Agreements to better meet the needs of customers and end users.
Features & benefits
Analyzes SQL Server resource usage down to the SQL statement level and stores performance data directly in a SQL database.
Provides proactive event management with robust fault management, detecting potential problems that could impact the availability of your SQL Servers.
Allows for easy automation, letting you set up automatic event-driven notifications and corrective actions.
Lowers support costs by enabling you to view the health and status of distributed SQL Servers from a central location.
AppManager for Microsoft SQL Server includes out-of-the-box Knowledge Scripts that track simple or complex events and collect data for real-time or historical performance analysis. Examples of Knowledge Scripts include:
Accessibility. Immediately alerts if the SQL Server or any specified database within the server is not accessible.
BlockedProcesses. Detects when processes are blocked.
EventLog. Detects when the SQL Server has written critical error messages to the Windows event log. Support is also available for monitoring SQL Server's own log file.
TopCPUUsers. Analyzes the CPU being consumed by SQL Server users and correlates CPU usage and SQL statements being executed by users.
TopLockUsers. Identifies locking activity by user and identifies the SQL statements causing locks.
TopMemoryUsers. Tracks memory usage by SQL Server users and correlates memory utilization to SQL statement activity.
DBGrowthRate. Tracks the rate at which databases are growing.
DBSpace. Tracks trends and raises alerts on the available space your SQL Server databases.
LogSpace. Detects whether you are running low on SQL Server log space and provides an option to automatically truncate the transaction log file.
RunSQL. Lets you invoke any SQL statement or stored procedure as a Knowledge Script or corrective action.
NearMaxContent. Tells you whether available connections are running low.
NearMaxLocks. Identifies whether SQL Server is almost out of locks.
ServerThroughput. Measures key I/O statistics, such as transactions per second.
ProcessingTime. Tracks the amount of time required to process a user-defined SQL statement.
UserConnections. Tracks who connects into the SQL Server and how many connections each person is using.
CacheHitRatio. Keeps watch of the SQL Server buffer cache, alerting you if you need to increase the memory allocated to SQL Server.