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.

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

Extension content

Content typeNumber of items included
screen chart groups
12
screen injections
1
screen properties
1
document dashboard
1
screen layout
1
list screen layout
1
screen entities lists
3
generic relationship
1
screen dql table
1
screen actions
2
dashboards
1
metric metadata
18
generic type
1

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
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
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

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

⚠️ 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
Log Management and AnalyticsKubernetesAI and LLM ObservabilityInfrastructure ObservabilitySoftware DeliveryApplication ObservabilityApplication SecurityDigital ExperienceBusiness Observability
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed
Partner FinderBecome a partnerDynatrace Developer

All

769 Results filtered by:

Chroma logo

Chroma

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

Technology
Amazon Kinesis Video Streams logo

Amazon Kinesis Video Streams

Provides you SDKs to install on your devices to make it easy to stream media.

Technology
Fluentd logo

Fluentd

Stream log data to Dynatrace via Fluentd for analysis.

Technology
Palo Alto firewalls logo

Palo Alto firewalls

Palo Alto extension for problems detection

Extension
AWS Elastic Beanstalk logo

AWS Elastic Beanstalk

Quickly deploy and manage applications in the AWS Cloud without having to learn about the infrastructure beneath.

Technology
Workflows logo

Workflows

Automate tasks in your IT landscape, remediate problems, and visualize processes

App
Security Posture Management logo

Security Posture Management

Detect, prioritize, and remediate security and compliance findings with SPM.

App
Amazon Route 53 logo

Amazon Route 53

Effectively connects user requests to infrastructure running in AWS.

Technology
Amazon Inspector logo

Amazon Inspector

Tests the network accessibility of your EC2 instances and the security state of your applications that run on those instances.

Technology
NGINX Plus logo

NGINX Plus

All‑in‑one web server, load balancer, content cache, and media streaming.

Technology
Databases logo

Databases

Easily monitor, troubleshoot, and optimize your entire database fleets.

App
Amazon DocumentDB logo

Amazon DocumentDB

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

Technology
Dynatrace MCP Server logo

Dynatrace MCP Server

Fuel your AI agents with high quality data and real-time production insights

Technology
IBM IMS SOAP Gateway logo

IBM IMS SOAP Gateway

Intelligently monitor your transactions end-to-end and analyze the performance of your IMS SOAP Gateway.

Technology
Amazon Keyspaces for Apache Cassandra logo

Amazon Keyspaces for Apache Cassandra

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

Technology
Apache Camel logo

Apache Camel

Intelligently monitor, analyze, and optimize your integration framework and all applications deployed in your stack.

Technology
Amazon Elastic Kubernetes Service (EKS) logo

Amazon Elastic Kubernetes Service (EKS)

Harness automation and AI to simplify Kubernetes observability at scale.

Technology
WordPress logo

WordPress

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

Technology
Azure Cosmos DB logo

Azure Cosmos DB

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

Technology
AWS Glue logo

AWS Glue

Fully managed extract, transform, and load (ETL) service.

Technology
Azure Event Hub Clusters logo

Azure Event Hub Clusters

Big data streaming platform and event ingestion service. It can receive and process millions of events per second.

Technology
Confluent Cloud (Kafka) logo

Confluent Cloud (Kafka)

Remotely monitor your Confluent Cloud Kafka Clusters and other resources!

Extension
Kong - Prometheus logo

Kong - Prometheus

Monitor Prometheus metrics exposed by Kong and proxied upstream services

Extension
BOSH bpm logo

BOSH bpm

Automated monitoring of platform processes running in BOSH bpm containers.

Technology
Prometheus in Kubernetes logo

Prometheus in Kubernetes

Collect metrics from Prometheus exporters in Kubernetes for Dynatrace analytics

Technology
Nutanix Clusters logo

Nutanix Clusters

Monitor Nutanix clusters' performance, usage and availability, with Nutanix API.

Extension
Azure Service-Fabric logo

Azure Service-Fabric

Intelligent end-to-end observability for serverless and hybrid environments using Azure Service Fabric.

Technology
Luna Network HSM Device logo

Luna Network HSM Device

Monitor your Luna Network Hardware Security Module (HSM) Devices through SNMP.

Extension
Consul Service Mesh (StatsD) logo

Consul Service Mesh (StatsD)

Extend visibility into your Consul Service Mesh instances to monitor health and improve performance.

Extension
Azure Relays logo

Azure Relays

Enables you to securely expose services that run in your corporate network to the public cloud.

Technology
Microsoft IIS logo

Microsoft IIS

Flexible and secure web server for hosting with Windows Server.

Extension
Kubernetes Monitoring Statistics logo

Kubernetes Monitoring Statistics

Troubleshoot your Dynatrace Kubernetes monitoring and Prometheus integration.

Extension
Google Cloud logo

Google Cloud

Meet your business challenges head on with cloud computing services from Google.

Technology
Snyk logo

Snyk

Ingest Snyk vulnerability findings, scans, and audit logs.

Extension
Amazon EventBridge logo

Amazon EventBridge

Serverless event bus to connect applications together using data from your own applications, integrated SaaS applications, and AWS services.

Technology
Ruby logo

Ruby

Dynatrace monitors your Ruby applications and services on the process level.

Technology
Apache OpenEJB logo

Apache OpenEJB

Automatically and intelligently monitor, analyze and optimize your applications based on Apache OpenEJB.

Technology
Log ingestion API logo

Log ingestion API

Stream your logs and log records to Dynatrace via the log ingest API

Technology
Citrix DaaS & Virtual Apps and Desktops logo

Citrix DaaS & Virtual Apps and Desktops

Gain insight into your Citrix DaaS & Virtual Apps and Desktops environments

Extension
Azure Device Provisioning Service logo

Azure Device Provisioning Service

Helper service for IoT Hub that enables just-in-time provisioning to the right IoT hub without human intervention.

Technology
Milvus logo

Milvus

Gain insights about vector database resource utilization and cache behavior

Technology
Google Memorystore logo

Google Memorystore

Get insights into Google Memorystore service metrics collected from the Google Operations API to ensure health of your cloud infrastructure.

Extension
Azul Platform Core (Zulu) logo

Azul Platform Core (Zulu)

Automatically and intelligently monitor, analyze, and optimize the performance of your virtual machine.

Technology
VirusTotal logo

VirusTotal

Enrich observables with threat intelligence from VirusTotal.

App
AWS Outposts logo

AWS Outposts

Fully managed service extending AWS infrastructure, services, APIs and more.

Technology
Databricks Workspace logo

Databricks Workspace

Remotely monitor your Databricks Workspaces!

Extension
LlamaIndex logo

LlamaIndex

Monitor your LLM-powered agents and workflows built with LlamaIndex framework.

Technology
UPS Device logo

UPS Device

Monitor your Uninterruptible Power Supplies (UPS) over SNMP

Extension
TensorFlow Keras logo

TensorFlow Keras

Observe the training progress of TensorFlow Keras AI models

Technology
Amazon Elastic Container Service (ECS) logo

Amazon Elastic Container Service (ECS)

Fully managed container orchestration service.

Technology