Skip to technology filters Skip to main content
Dynatrace Hub

Extend the platform,
empower your team.

Popular searches:
Home hero bg
Microsoft SQL Server (local)Microsoft SQL Server (local)
Microsoft SQL Server (local)

Microsoft SQL Server (local)

Improve the health and performance monitoring of your Microsoft SQL Servers.

Extension
Free trialDocumentation
Instance overview screen.Buffer manager monitoring.Navigation from host screen to SQL Server instance.
  • Product information
  • Release notes

Overview

Microsoft SQL Server database monitoring is based on a local monitoring approach implemented as a Dynatrace OneAgent extension. The extension uses WMI queries to collect key performance and health metrics from the SQL Server instance running on the host, extending your visibility.

Use cases

  • Understand the resource impact that your applications have on your database.
  • Understand the impact of resource shortages, locks or other database issues have on your application by observing the database server itself.
  • Track health and performance of the MS SQL servers.
  • Speed up the application problem diagnosis, where it’s caused by the database.

Get started

For more information on the installation and configuration, please see Microsoft SQL Server (local) extension in the Dynatrace Documentation.

Details

Compatibility information

Supported versions of SQL Server:

Any version of SQL Server with active extended support by Microsoft is supported by this extension. Please refer to the official Microsoft documentation about lifecycle dates for SQL Server.

Supported types of SQL Server:

  • SQL Server on Windows (editions: Enterprise, Standard, Developer)

Warnings:

  • If you have several instances on the same host, this extension could cause additional CPU utilization. For now, please use the Remote SQL Server extension in such scenarios.
  • Versions 1.1+ of the extension and later are incompatible with the verson 1.0 or the ones released earlier.
Dynatrace
DocumentationMore Information
By Dynatrace
Dynatrace support center
Subscribe to new releases
Copy to clipboard

Feature sets

Below is a complete list of the feature sets provided in this version. To ensure a good fit for your needs, individual feature sets can be activated and deactivated by your administrator during configuration.

Feature setsNumber of metrics included
Metric nameMetric keyDescriptionUnit
Processes blockedsql-server.local.general.processesBlockedNumber of currently blocked processesCount
Transactionssql-server.local.general.transactionsNumber of transaction enlistments (local, dtc, and bound)Count
User connectionssql-server.local.general.userConnectionsNumber of users currently connected to SQL ServerCount
Metric nameMetric keyDescriptionUnit
Page splitssql-server.local.accessMethods.pageSplits.countNumber of page splits that occur as a result of overflowing index pagesPerSecond
Metric nameMetric keyDescriptionUnit
Buffer cache hitsql-server.local.buffers.cacheHitRatioPercentage of pages found in the buffer cache without having to read from diskPercent
Checkpoint pagessql-server.local.buffers.checkpointPages.countNumber of pages flushed to disk by a checkpoint or other operations that require all dirty pages to be flushedCount
Page life expectancysql-server.local.buffers.pageLifeExpectancyNumber of seconds a page will stay in the buffer pool without referencesSecond
Metric nameMetric keyDescriptionUnit
Latch waitssql-server.local.latches.waits.countNumber of latch requests that could not be granted immediatelyCount
Metric nameMetric keyDescriptionUnit
Batch requestssql-server.local.sql.batchRequests.countNumber of Transact-SQL command batches receivedCount
SQL compilationssql-server.local.sql.compilations.countNumber of SQL statement compilationsCount
SQL re-compilationssql-server.local.sql.recompilations.countNumber of SQL statement re-compilationsCount
Metric nameMetric keyDescriptionUnit
Lock waitssql-server.local.locks.waits.countNumber of lock requests that required the caller to waitCount
Deadlockssql-server.local.locks.deadlocks.countNumber of lock requests that resulted in a deadlockCount
Metric nameMetric keyDescriptionUnit
Connection memorysql-server.local.memory.connectionTotal amount of dynamic memory the server is using for maintaining connectionsKiloByte
Memory grants outstandingsql-server.local.memory.grantsOutstandingNumber of processes that have successfully acquired a workspace memory grantCount
Memory grants pendingsql-server.local.memory.grantsPendingNumber of processes waiting for a workspace memory grantCount
Target server memorysql-server.local.memory.targetAmount of memory that can be consumed by memory managerKiloByte
Total server memorysql-server.local.memory.totalAmount of memory the server has committed using the memory managerKiloByte

Related to Microsoft SQL Server (local)

OneAgent logo

OneAgent

The simplest way to capture all observation signals automatically and in context.

Full version history

To have more information on how to install the downloaded package, please follow the instructions on this page.
ReleaseDate

Full version history

WARNING: Possible breaking changes and warnings - PLEASE READ before upgrading:

  • This version requires a minimum Dynatrace version of 1.338.0 and a minimum EEC version of 1.280.0
  • This version includes a breaking change for Dynatrace on Grail.
    • You must opt-in to OpenPipeline configuration via Settings API – see the documentation.

New in this version:

  • Smartscape 2.0 nodes and edges on Grail.
  • Added feature set metadata for recommended metrics.

Full version history

⚠️ NOTICE: This version requires a minimum Dynatrace Cluster version of 1.309

✨New in this version:

  • Adds dt.security_context to sql:sql_server_local_instance entity
  • Adds platform screen definitions for the I/O app
  • Adds a platform dashboard

Full version history

Improvements:

  • Host name for each SQL Server instance entity is now properly resolved. Instead of SQL Server (HOST-9A55C8D98F33TOD) the entity name is resolved to true host name: SQL Server (my-host)

Full version history

Bug fixes:

  • Instance entities now have unique names, based on the underlying HOST ID. Example: SQL Server (HOST-9A55C8D98F33TOD). Previously all entities had the same user facing name SQL Server Local (localhost).
  • Fix for validation errors that involve metrics with :smooth(skipfirst) in their name.
  • Fix for err:Exception occurred. (Invalid class): see below for added support for named instances.

Improvements:

  • Link to parent host is added on Instance screen.
  • Link to parent host is added on properties card of the Instance under the "Host" attribute.
  • Local address of the detected connection is added on properties card under the "Device" attribute.
  • Instance dimension removed from all metrics, because it was never reported.
  • Dashboard was redisigned to better fit on smaller screens.

Features:

  • Link to the detected SQL Server instance entity is added on Host screen under the "SQL Server Local Instances".
  • Support for named instances has been added.

Warning:

  • Extension is only proven to work with a single SQL Server instance (named or default) installed on host.

Full version history

  • Fixed issue with Fault retrieving dimension for key:instance err:Unknown name error.
  • Added compatibility with remote SQL Server extension.
  • All metrics had their prefix changed from sql-server. to sql-server.local. to distinguish collected metrics from those reported by remote SQL Server extension.

Full version history

Reimplementation of EF1 local WMI monitoring extension using EF2.

Dynatrace Hub
Hub HomeGet data into DynatraceBuild your own app
Dynatrace Intelligence - Agentic Operations SystemThe Dynatrace Agentic AI ecosystem
Log Management and AnalyticsKubernetesAI and LLM ObservabilityInfrastructure ObservabilitySoftware DeliveryApplication ObservabilityApplication SecurityBusiness ObservabilityDigital Experience
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed
Partner FinderBecome a partnerDynatrace Developer

65 Results

Found in 'All'

Databases logo

Databases

Monitor databases, prevent issues, and resolve incidents quickly in real time.

App
  • database
  • db
  • google cloud sql
  • hanadb
  • monitoring
  • mssql
  • MySQL
  • oracle
  • PostgreSQL
  • rds
  • saas
Oracle Database logo

Oracle Database

Observe, analyze and optimize the usage, health and performance of your database.

Extension
  • database
  • logs
  • monitoring
  • oracle
  • sql
Azure SQL Database logo

Azure SQL Database

Managed cloud database provided as part of Microsoft Azure.

Technology
  • cloud
Azure Database for MySQL logo

Azure Database for MySQL

Full observability of MySQL servers and database instances to ensure database health and performance.

Technology
  • cloud
Database Operations Agent logo

Database Operations Agent

Identify application slowdowns by automatically analyzing database performance.

Technology
  • database
  • agentic-operations-system
  • agentic-workflows
  • AI
  • db
  • MCP
  • Model Context Protocol
  • readymade-agent
  • sql
Custom database extension logo

Custom database extension

Execute generic database queries and ingest metrics and logs to Dynatrace.

Technology
  • database
  • Custom
  • extension
Azure Database for Maria DB logo

Azure Database for Maria DB

Full coverage of performance for critical workloads with AI-problem detection, availability, and more.

Technology
  • cloud
Azure Database for PostgreSQL logo

Azure Database for PostgreSQL

Full insight into database performance for critical workloads with AI-problem detection and more.

Technology
  • cloud
AWS Database Migration Service logo

AWS Database Migration Service

Makes it easy to migrate relational databases, and other types of data stores.

Technology
  • cloud
Amazon Quantum Ledger Database (QLDB) logo

Amazon Quantum Ledger Database (QLDB)

Ledger by a central trusted authority that provides an immutable, and cryptographically verifiable transaction log.

Technology
  • cloud
SAP HANA Database (remote monitoring) logo

SAP HANA Database (remote monitoring)

Easily understand the health and performance of your SAP HANA databases.

Extension
  • database
  • extension
  • hanadb
  • sap
  • sql
Amazon Relational Database Service (RDS) logo

Amazon Relational Database Service (RDS)

Instant insights and unified monitoring for optimal Amazon RDS performance.

Technology
  • database
  • log-ingest-integration-cloud:relational:database:service
  • amazon
  • aws
Couchbase logo

Couchbase

Couchbase Capella (SaaS) database monitoring.

Extension
  • database
  • full-stack
  • monitoring
  • noSQL
  • OneAgent
  • performance
IBM DB2 for LUW (remote monitoring) logo

IBM DB2 for LUW (remote monitoring)

Remotely collect monitoring metrics from your DB2 databases.

Extension
  • database
  • db2
  • ibm
  • linux
  • windows
Oracle Base DB and Autonomous DB on OCI logo

Oracle Base DB and Autonomous DB on OCI

Monitor health of the Oracle Base Service and Autonomous Database.

Extension
  • database
  • cloud
  • cloud-and-infrastructure
  • OCI
  • oracle
IBM DB2 logo

IBM DB2

Data management products, including database servers, developed by IBM.

Technology
  • database
  • ibm
  • mainframe
  • z/OS
Connection Pools: JBoss logo

Connection Pools: JBoss

Application server method of pooling and sharing connections to a database.

Extension
  • database
  • connection pool
  • java
  • jboss
  • JMX
  • OneAgent
  • open-source
  • pool
  • red-hat
  • wildfly
Connection Pools: C3P0 logo

Connection Pools: C3P0

Application server method of pooling and sharing connections to a database.

Extension
  • database
  • c3p0
  • connection pool
  • java
  • JMX
  • OneAgent
  • open-source
  • pool
Connection Pools: WebSphere Liberty logo

Connection Pools: WebSphere Liberty

Application server method of pooling and sharing connections to a database.

Extension
  • database
  • connection pool
  • ibm
  • java
  • JMX
  • liberty
  • OneAgent
  • pool
  • websphere
Connection Pools: WebLogic logo

Connection Pools: WebLogic

Application server method of pooling and sharing connections to a database.

Extension
  • database
  • connection pool
  • java
  • JMX
  • OneAgent
  • oracle
  • pool
  • weblogic
Apache CouchDB logo

Apache CouchDB

Intelligently observe and optimize health and performance of your database.

Extension
  • database
Connection Pools: Apache Commons logo

Connection Pools: Apache Commons

Application method of pooling and sharing multiple connections to a database.

Extension
  • database
  • apache
  • apache commons
  • connection pool
  • java
  • JMX
  • OneAgent
  • open-source
  • pool
Memcached logo

Memcached

Distributed caching system used to speed up dynamic database-driven websites.

Extension
  • database
  • cache
  • Memcached
Sybase ASE logo

Sybase ASE

Monitor Sybase ASE database for performance and health, using remote monitoring.

Extension
  • database
  • sap
  • sybase
MariaDB logo

MariaDB

Observe, analyze and optimize the usage, health and performance of your database.

Technology
  • database
  • full-stack
  • monitoring
Amazon Aurora logo

Amazon Aurora

Relational database service developed and offered by Amazon Web Services.

Technology
  • cloud
LanceDB logo

LanceDB

Monitor the performance of your multimodal AI database powered by LanceDB.

Technology
Pinecone logo

Pinecone

Gain insight into your Pinecone vector databases to build knowledgeable AI.

Technology
Milvus logo

Milvus

Gain insights about vector database resource utilization and cache behavior.

Technology
Java JDBC logo

Java JDBC

Application programming interface for the Java, defines access to a database.

Technology
  • java
Amazon DynamoDB logo

Amazon DynamoDB

Fully managed NoSQL database service that supports key-value and data structure.

Technology
  • amazon
  • log-ingest-integration-cloud:aws:dynamodb
Amazon Neptune logo

Amazon Neptune

Fast, reliable, fully managed graph database built for highly connected datasets.

Technology
  • cloud
Chroma logo

Chroma

Gain insights into the health of your vector and embedding databases from Chroma.

Technology
MySQL logo

MySQL

Automatically and intelligently observe, analyze and optimize how your the usage, health and performance of your database.

Technology
  • database
  • full-stack
  • monitoring
  • performance
  • web
Amazon Keyspaces for Apache Cassandra logo

Amazon Keyspaces for Apache Cassandra

Scalable, highly available, and managed Apache Cassandra–compatible database service.

Technology
  • cloud
WordPress logo

WordPress

Content management system written in PHP and paired with a MySQL or MariaDB database.

Technology
  • cms
  • php
  • web
Neo4j logo

Neo4j

Extend observability with PurePath® distributed traces by seamlessly integrating OpenTracing data emitted by the Neo4j graph database.

Technology
  • database
  • java
  • neo4j
  • opentracing
  • PurePath
Azure Synapse Analytics logo

Azure Synapse Analytics

Cloud-based, scale-out, relational database capable of processing massive volumes of data.

Technology
  • cloud
Azure SQL Managed logo

Azure SQL Managed

Full observability into cloud database performance and automated monitoring for Azure SQL Managed.

Technology
  • cloud
Amazon DocumentDB logo

Amazon DocumentDB

Amazon DocumentDB (with MongoDB compatibility) is a fast, reliable, and fully managed database service.

Technology
  • cloud
Azure Cosmos DB logo

Azure Cosmos DB

Fully managed and serverless distributed database supporting open-source PostgreSQL, MongoDB, and Apache Cassandra.

Technology
  • cloud
Snowflake for Workflows logo

Snowflake for Workflows

Access, query, and store Snowflake data to analyze further within Dynatrace.

App
  • database
  • automation
  • connector
  • connectors
  • snowflake
  • workflow
  • workflow action
  • workflow actions
  • workflows
Snowflake logo

Snowflake

Expand visibility to improve health and performance monitoring of your Snowflake.

Extension
  • database
  • logs
  • snowflake
  • sql
Elasticsearch logo

Elasticsearch

Monitor Elasticsearch Clusters, Nodes, Indexes, remotely or locally, via API.

Extension
  • database
  • Elasticsearch
  • search
Redis Enterprise - Prometheus logo

Redis Enterprise - Prometheus

Monitor Redis Enterprise with the official Redis Prometheus exporter.

Extension
  • database
  • cache
  • noSQL
  • Redis
  • redis
  • replication
  • shard
PostgreSQL logo

PostgreSQL

Monitor your Postgres performance via our new EF2.0 extension framework.

Extension
  • database
  • extension
  • logs
  • postgres
  • query
  • sql
Custom Extensions Creator logo

Custom Extensions Creator

Create custom extensions with a few clicks.

App
  • database
  • app
  • custom queries
  • datasource
  • extensions
  • JMX
  • Prometheus
  • queries
  • query
  • snmp
  • snmptraps
  • sql
  • WMI
Oracle GoldenGate logo

Oracle GoldenGate

Monitor Oracle GoldenGate for performance, usage, and availability.

Extension
  • database
  • oracle
  • sql
Oracle Exadata logo

Oracle Exadata

Monitor Oracle Exadata systems for performance, usage and availability.

Extension
  • database
  • exadata
  • oracle
MySQL (remote monitoring) logo

MySQL (remote monitoring)

Remotely monitor your MySQL instances, collect key KPIs and slow queries details.

Extension
  • database
  • MySQL