010-68421378
sales@cogitosoft.com
Categories

ApexSQL Monitor

The future of SQL monitoring

Monitor, detect, and solve SQL Server performance problems

 

?Monitor multiple SQL Server instances

?View system performance metrics

?Identify performance issues and deadlocks

?Use comprehensive dashboard for viewing metrics

?Monitor AlwaysOn availability groups and failover clusters

?Analyze query waits and review query execution plans

?Calculate baselines and thresholds

?Monitor index performance

Features

SQL Server, system and database metrics monitoring

Monitor the most important SQL Server, system and database performance parameters such as longest running transactions, page life expectancy, buffer cache hit ratio, processor utilization, available memory, database size, log growth and many more

 

Query waits and blocking queries monitoring and alerting

Capture query wait times for individual and blocking queries. Review query performance history. Get alerted whenever a wait time exceeds predefined threshold values

 

Monitor SQL query performance

Detect the slowest queries by CPU, execution time or I/O

 

Wait type statistics

Review collected wait statistics including detailed information on the top 5 wait stats categories to quickly identify performance issues and bottlenecks

 

Query execution plan viewer

Analyze problematic queries by displaying the query execution plan using an integrated query execution plan viewer.

 

Reporting

Analyze SQL Server performance by generating different report types.

 

Performance base lining

Configure server performance baselines for a desired date range.

 

SQL Server and database status monitoring

Monitor servers and databases to ensure availability and identify issues early

 

Custom metrics

Create custom metrics to be monitored along with standard metrics. Use set of predefined Windows OS system metrics or add custom SQL Server or database metrics

 

Metric history

Easily navigate through the charts history via the date/time slider

 

Alerts

Get alerted when a metric reaches its predefined threshold value with 24/7 notifications

 

Individual alert management

Review, resolve or add comments on resolutions for individual alerts. Create reports for resolved alerts

 

Email alerting

Send an email whenever an alert is raised. Send individual or summary alert reports via multiple email profiles

 

Alert actions

Execute SQL scripts, shell commands, or use SNMP notifications when an alert is raised

 

User security

Define users assigned to different roles to increase monitoring security and reliability

 

Configurable monitoring

Enable or disable metrics and customize details

 

Server information summary

Check information and alert summary for one, some, or all SQL Servers

 

Custom charts view

Create custom tabs with preferred charts and metrics

 

Logarithmic scale y-axis

Display large data ranges without hiding small but critical variations.

 

Deadlock analysis

Set up a deadlock alert action and save details, including a graphical presentation of the deadlock

 

Maintenance periods

Set recurring or one-time maintenance period intervals schedule to suspend alerting or monitoring of specified SQL Server instances

 

SQL Server grouping

Group servers with similar properties to aggregate alerts and details for all servers in the group

 

Themes

Choose between dark and light colored layout

 

Web interface

The 2017 version of ApexSQL Monitor will feature a fully Web interface for dynamic viewing and configuration.

System requirements

Hardware requirements Quad-core 3.0 GHz CPU (the specification considers monitoring of 5 SQL Server instances with medium to high activity)

 4 GB memory

 30 GB disk space (for 7 days data retention policy - this is an average requirement based on real word use cases, but this could further vary depending on the monitoring instances state/activity) 

SQL Server Microsoft SQL Server 2016, 2014, 2012, 2008, and 2005 

OS Windows Vista/Server 2008 and above

Required  Microsoft .NET Framework 4.5 

Note

Central instance requires Microsoft SQL Server 2008 or greater

 Native support for the x64 architecture

 Microsoft SQL Server Express edition is not recommended for the central repository, due to the database size limitation

 The additional requirements are described in the  ApexSQL Monitor - Permissions and requirements knowledgebase article 

 

 

Compare

  ApexSQL Idera Solarwinds SQL Sentry
Monitoring
      AlwaysOn Availability Groups  
      Custom SQL metrics
      Custom system metrics
      Failover clusters  
      Indexes    
      SQL Agent status  
      Query performance  
      Query waits
      VMware 2017 R2
      Hyper-V 2017 R2  
Alerting
      Alert actions  
      Alert baselines
      SNMP traps
      Query level alerts  
Reporting
      Exporting to PDF, Excel  
      Internal report viewer
      Report generation
      Scheduled reports 2017 R2
Performance issues analysis
      Metric troubleshooting  
      Tips
      Analysis 2017 R2  
Configuration
      Alerts
      Alert snoozing*  
      Databases    
      Devices    
      Maintenance periods
Web
      Web console 2017 R1    
      Full web version 2017 R1  
Other
      Blocking detection
      Deadlock detection
      Graphical query execution plans
      Repository purging
      Server grouping
      User profiles
 
Quick Navigation;

© Copyright 2000-2017  COGITO SOFTWARE CO.,LTD. All rights reserved.