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
All (914)Log Management and AnalyticsKubernetesAI and LLM ObservabilitySoftware DeliveryApplication ObservabilityApplication SecurityBusiness ObservabilityDigital Experience
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed
Partner FinderBecome a partnerDynatrace Developer

Infrastructure Observability

Get automatic and intelligent observability across cloud and hybrid environments with continuous auto-discovery of any type of infrastructure, all in context and with precise, AI-powered answers.

Essentials

Get automatic and intelligent infrastructure monitoring and observability across hybrid and cloud environments.

OneAgent logo

OneAgent

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

Discovery & Coverage logo

Discovery & Coverage

Ensure enterprise-wide visibility. Discover and remediate coverage gaps.

Infrastructure & Operations logo

Infrastructure & Operations

Detailed hosts, process, and network insights across the entire environment.

Databases logo

Databases

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

Clouds logo

Clouds

Gain full visibility and proactive monitoring across your cloud infrastructure.

Hybrid cloud

AWS logo

AWS

Reliable, scalable, and inexpensive cloud computing services.

Microsoft Azure logo

Microsoft Azure

Cloud computing service for building, testing, deploying, and managing services.

Google Cloud logo

Google Cloud

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

VMware logo

VMware

Monitor health and performance of VMware virtual machines.

Nutanix Clusters logo

Nutanix Clusters

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

Microsoft Hyper-V Infrastructure logo

Microsoft Hyper-V Infrastructure

Monitor health and performance of the Hyper-V clusters, hosts and VMs.

Technology coverage

F5 BIG-IP logo

F5 BIG-IP

Gain insights into the performance of your F5 BIG-IP LTM and DNS solutions.

Oracle Database logo

Oracle Database

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

Microsoft SQL Server logo

Microsoft SQL Server

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

Also popular

See more (5)
Juniper Networks (SNMP) logo

Juniper Networks (SNMP)

Gain insights into the performance of your Juniper networking solutions.

SNMP Traps logo

SNMP Traps

Supplement network monitoring with event-based data reported via SNMP Traps.

Generic Cisco Device logo

Generic Cisco Device

Monitor Cisco devices using SNMP to feed Dynatrace with metrics and alerts.

Palo Alto firewalls logo

Palo Alto firewalls

Palo Alto extension for problems detection.

Remote Windows Host Monitoring logo

Remote Windows Host Monitoring

Monitor health and performance of Windows Hosts without installing an agent.

AWS Lambda logo

AWS Lambda

Automatic and intelligent end-to-end observability of AWS Lambda traces and logs.

More resources

Amazon API Gateway logo

Amazon API Gateway

Service for developers to create, publish, maintain, monitor, and secure APIs.

Amazon AppStream 2.0 logo

Amazon AppStream 2.0

Fully managed application streaming service that provides users with instant access to their desktop applications from anywhere.

Amazon Athena logo

Amazon Athena

Interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL.

Amazon Aurora logo

Amazon Aurora

Relational database service developed and offered by Amazon Web Services.

Amazon CloudFront logo

Amazon CloudFront

Content delivery network offered by Amazon Web Services.

Amazon CloudSearch logo

Amazon CloudSearch

Set up, manage, and scale a search solution for your website or application using CloudSearch.

Amazon CloudWatch Logs logo

Amazon CloudWatch Logs

Monitor, store, and access your log files from instances, AWS CloudTrail, Route 53, and other sources.

Amazon Cognito logo

Amazon Cognito

Add user sign-up, sign-in, and access control to your web and mobile apps quickly and easily.

Amazon Connect logo

Amazon Connect

Easy to use omnichannel cloud contact center that helps you to provide superior customer service at a lower cost.

Amazon DocumentDB logo

Amazon DocumentDB

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

Amazon DynamoDB Accelerator (DAX) logo

Amazon DynamoDB Accelerator (DAX)

Fully managed, highly available, in-memory cache for your Amazon DynamoDB.

Amazon EC2 Auto Scaling logo

Amazon EC2 Auto Scaling

Amazon EC2 Auto Scaling helps you ensure that you have the correct number of Amazon EC2 instances available.

Amazon EC2 Spot Fleet logo

Amazon EC2 Spot Fleet

Spot Instances and On-Demand Instances to meet the target capacity that you specified.

Amazon Elastic Container Service (ECS) logo

Amazon Elastic Container Service (ECS)

Fully managed container orchestration service.

Amazon Elastic File Service (EFS) logo

Amazon Elastic File Service (EFS)

Cloud storage service provided by Amazon Web Services.

Amazon Elastic Transcoder logo

Amazon Elastic Transcoder

Convert and transcode media files stored in Amazon S3.

Amazon ElastiCache logo

Amazon ElastiCache

Fully managed, Redis- and Memcached-compatible service delivering real-time performance for modern applications by Amazon Web Services.

Amazon Elasticsearch Service logo

Amazon Elasticsearch Service

Fully managed service to deploy, secure, and run Elasticsearch cost effectively at scale, without the operational overhead.

Amazon EMR logo

Amazon EMR

Cloud big data platform for processing vast amounts of data using open source tools.

Amazon EventBridge logo

Amazon EventBridge

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

Amazon FSx for Lustre logo

Amazon FSx for Lustre

Makes it easy and cost-effective to launch and run the popular, high-performance Lustre file system.

Amazon FSx for Windows File Server logo

Amazon FSx for Windows File Server

Provides a managed Microsoft Windows file servers, backed by a native Windows file system.

Amazon GameLift logo

Amazon GameLift

Enables developers to deploy, operate, and scale dedicated, low-cost servers in the cloud for session-based, multiplayer games.

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.

AWS IoT logo

AWS IoT

Run local compute, messaging, data caching, and machine learning inference capabilities.

Amazon Keyspaces for Apache Cassandra logo

Amazon Keyspaces for Apache Cassandra

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

Amazon Kinesis Data Analytics logo

Amazon Kinesis Data Analytics

Transform and analyze streaming data in real time with open source framework and engine for processing data streams (Apache Flink).

Amazon Kinesis Data Firehose logo

Amazon Kinesis Data Firehose

Fully managed service for delivering real-time streaming data.

Amazon Kinesis Data Streams logo

Amazon Kinesis Data Streams

Collect log and event data from sources such as servers, desktops, and mobile devices.

Amazon Kinesis Video Streams logo

Amazon Kinesis Video Streams

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

Amazon Lex logo

Amazon Lex

Service for building conversational interfaces for applications using voice and text.

Amazon MQ logo

Amazon MQ

Managed message broker service for Apache ActiveMQ that makes it easy to migrate to a message broker in the cloud.

Amazon MSK logo

Amazon MSK

Fully managed service that enables you to build and run applications that use Apache Kafka to process streaming data.

Amazon Neptune logo

Amazon Neptune

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

Amazon Polly logo

Amazon Polly

Cloud service that converts text into lifelike speech.

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.

Amazon Redshift logo

Amazon Redshift

Data warehouse product which forms part of the larger cloud-computing platform AWS.

Amazon Rekognition logo

Amazon Rekognition

Amazon Rekognition makes it easy to add image and video analysis to your applications.

Amazon Route 53 logo

Amazon Route 53

Effectively connects user requests to infrastructure running in AWS.

Amazon Simple Email Service (SES) logo

Amazon Simple Email Service (SES)

Cloud-based service that helps developers send marketing, notification, and transactional emails.

Amazon Simple Notification Service (SNS) logo

Amazon Simple Notification Service (SNS)

Provides a simple web services interface that can be used to create topics you want to notify apps.

Amazon Simple Queue Service (SQS) logo

Amazon Simple Queue Service (SQS)

Programmatic sending of messages via web service applications.

Amazon Simple Workflow Service (SWF) logo

Amazon Simple Workflow Service (SWF)

Makes it easy to build applications that coordinate work across distributed components.

Amazon Textract logo

Amazon Textract

Makes it easy to add document text detection and analysis to your applications.

Amazon Transfer Family logo

Amazon Transfer Family

Provides fully managed support for file transfers directly into and out of Amazon S3 using SFTP, FTPS, and FTP.

Amazon Translate logo

Amazon Translate

Text translation service using machine learning to provide high-quality translation on demand.

Amazon VPC (NAT Gateway) logo

Amazon VPC (NAT Gateway)

Connect to the Internet from instances within a private subnet in an AWS Virtual Private Cloud.

Amazon WorkMail logo

Amazon WorkMail

Secure, managed business email and calendaring service with support for existing desktop and mobile email clients.

Are you looking for something different?

We have hundreds of apps, extensions, and other technologies to customize your environment

Extend your knowledge

Learn the Dynatrace Query Language

Learn the Dynatrace Query Language

Explore data, discover patterns, anomalies and outliers, and create statistical modeling with DQL, our powerful query language..
Learn DQL
Get certified and advance your career

Get certified and advance your career

Go to Dynatrace University for practical, on-demand courses and learning paths -- from platform basics to key certifications.
Build skills