Microsoft SQL Server Monitoring

Using ELM Enterprise Manager, you can monitor server event logs, send and receive alerts as events occur, collect performance data and system configuration data, and take corrective action when things go wrong. ELM Enterprise Manager includes a special SQL Monitor that can perform query-based monitoring of all versions of Microsoft SQL Server.

With ELM Enterprise Manager, you can take a proactive approach to managing your SQL Server infrastructure. ELM Enterprise Manager is a 32-bit, multi-threaded client/server application specifically designed for minimal system overhead, minimal network impact and maximum visibility and monitoring. You may have ELM Enterprise Manager notify you of activity or problems using a wide variety of methods, including customizable beeps and multimedia sound files, network pop-up messages, SMTP or MAPI email, posting to web forms, alphanumeric/numeric pagers, SNMP traps, and user-written batch files, scripts, command files or applications.

ELM Enterprise Manager Provides

• Rules-based Management
• Real-Time, Poll-based, and Agentless Monitoring
• Rich Notification and Corrective Action
• Data Archiving and Reporting
• Enhanced Monitoring of clustered SQL Servers

 

ELM Enterprise Manager

• Monitor your SQL Servers' system, security and application events in real-time, and store the events in a database for archiving and auditing
• Collect and store all published performance counters, including SQL-related performance counters, for baselining, trending and capacity planning
• Perform query-based monitoring of SQL Server
• Send and receive alert notifications, including via email and pager, when events occur, services fail or performance exceeds thresholds
• Automatically restart failed services, execute scripts and batch files
• Stop and start services locally and remotely.
• Kill processes locally and remotely.
• Execute SQL queries against a database and generate a variety of notification options if the results returned are different from what is expected.

 

ELM monitors SQL Server 7.0, SQL Server 2000 and SQL Server 2005 in standalone and clustered environments.

Monitor Microsoft SQL Server using any valid SQL query. The query will be executed on a schedule and you will be notified when the results are different than expected.

ELM supports integrated (Windows NT) authentication or mixed authentication (Windows NT and SQL authentication), enabling you to monitor SQL Server without modifying your existing security infrastructure.

Available in: