The AppDynamics Database Monitoring product module for Microsoft SQL Server is a comprehensive 24x7 deep-dive tool used to monitor versions 2000, 2005, 2008, 2012 and 2014 of SQL Server instances running on any platform.
SQL Server is Microsoft’s proprietary RDBMS (Relational Database Management System). It comes in several versions that are targeted toward data centers (SQL Datacenter), cluster deployments (SQL Enterprise), and cloud-based frameworks and services (SQL Azure). It offers a mature feature set that includes such attributes as buffer management; pessimistic and optimistic concurrency control; an ETL (Extract-Transfer-Load) tool, OLAP (Online Analytical Processing) capabilities; messaging and alert technologies; Database Mirroring using Windows Clustering for High Availability; Remote Replication using AlwaysOn for disaster recovery; and in-memory column-store. SQL Server 2014 will include in-memory transaction processing technology, in addition to other new features.
Deep visibility into SQL Server performance
Get to the root cause quickly and resolve costly performance problems with real-time visibility into memory usage, current resource consumption, and database waits in any SQL Server instance throughout your organization.
View SQL Server instance objects
Gain a holistic view of your SQL Server objects with full visibility and correlation with SQL execution plans that display current SQL Server configuration parameters, properties, and information related to database objects including configuration values.
Historical SQL Server instance performance trends
Analyze and alert based on SQL Server instance performance trends over time, and use this information to proactively tune performance to improve resource efficiency and optimize the end-user experience.
Comprehensive performance reports
Visualize important information – like historical reporting of time series comparisons, and top SQL reports – to make data-driven decisions about your SQL Server instances.
Quickly troubleshoot issues with one-click SQL statement analysis that displays details of the SQL statement and SQL execution plan.