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

194 Results filtered by:

Palo Alto firewalls logo

Palo Alto firewalls

Palo Alto extension for problems detection

Extension
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
Nutanix Clusters logo

Nutanix Clusters

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

Extension
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
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
Snyk logo

Snyk

Ingest Snyk vulnerability findings, scans, and audit logs.

Extension
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
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
Databricks Workspace logo

Databricks Workspace

Remotely monitor your Databricks Workspaces!

Extension
Uptime logo

Uptime

Monitor the uptime of your hosts

Extension
UPS Device logo

UPS Device

Monitor your Uninterruptible Power Supplies (UPS) over SNMP

Extension
Google App Engine (integration) logo

Google App Engine (integration)

Insights into Google App Engine service metrics collected from Operations API

Extensioncoming soon
Traceroute logo

Traceroute

Run traceroute commands and collect step performance metrics

Extension
[Deprecated] Kubernetes PVCs logo

[Deprecated] Kubernetes PVCs

Monitor your Kubernetes persistent volume claims and alert on capacity limits.

Extension
Google Cloud Storage Transfer logo

Google Cloud Storage Transfer

Get insights into Google Cloud Storage Transfer metrics collected from the Google Operations API to ensure health of cloud infrastructure.

Extension
NVIDIA GPU logo

NVIDIA GPU

Monitor base parameters of the GPU, including load, memory and temperature

Extension
Oracle Database logo

Oracle Database

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

Extension
Cisco ACI/APIC logo

Cisco ACI/APIC

Get insights into your Cisco Application Centric Infrastructure (ACI)

Extension
Dell iDRAC logo

Dell iDRAC

Connect to the Redfish API to get insights into your Dell iDRAC environment

Extension
Azure Managed Apache Cassandra logo

Azure Managed Apache Cassandra

Gain insights into your Azure Managed Cassandra Instance health and performance

Extension
PayShield HSM Device logo

PayShield HSM Device

Monitor PayShield Payment Hardware Security Module (HSM) Devices through SNMP.

Extension
NetApp OnTap (Remote) logo

NetApp OnTap (Remote)

Remote extension that collects NetApp OnTap metrics from the OnTap 9.6+ API.

Extension
Google Firestore in Datastore mode logo

Google Firestore in Datastore mode

Get insights into Google Firestore in Datastore mode metrics collected from the Google Operations API to ensure health of infrastructure.

Extension
Redis (2.0) logo

Redis (2.0)

Collect important additional data for your Redis instances.

Extension
PHP-FPM logo

PHP-FPM

Monitor the PHP-FPM status of your applications with this extension.

Extension
Timedrift Monitoring logo

Timedrift Monitoring

Monitor your host's NTP/Chrony Time Offset!

Extension
Apache Kafka logo

Apache Kafka

Automatic and intelligent observability with trace and metric insights.

Extension
MongoDB (local or remote monitoring) logo

MongoDB (local or remote monitoring)

Monitor your MongoDB servers either locally or remotely!

Extension
Connection Pools: C3P0 logo

Connection Pools: C3P0

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

Extension
AWS Entities for Metric Streaming logo

AWS Entities for Metric Streaming

Analyse metrics in the context of an entity based on AWS Metric Streaming.

Extension
MongoDB Atlas logo

MongoDB Atlas

Remotely monitor your SaaS installation of MongoDB (Atlas)

Extension
Microsoft SQL Server logo

Microsoft SQL Server

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

Extension
IBM MQ Appliance logo

IBM MQ Appliance

Monitor your IBM MQ Appliances over SNMP

Extension
Google Apigee logo

Google Apigee

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

Extension
Oracle Autonomous Database on OCI logo

Oracle Autonomous Database on OCI

Monitor health and performance of the Oracle Autonomous Database.

Extension
Google Pub/Sub Lite logo

Google Pub/Sub Lite

Get insights into Google Pub/Sub Lite service metrics collected from the Google Operations API to ensure health of the cloud infrastructure.

Extension
Infoblox DDI logo

Infoblox DDI

Monitor Infoblox DDI using SNMP

Extension
SAP HANA Database (remote monitoring) logo

SAP HANA Database (remote monitoring)

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

Extension
Connection Pools: WebSphere Liberty logo

Connection Pools: WebSphere Liberty

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

Extension
Google Cloud Composer logo

Google Cloud Composer

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

Extension
Google Cloud Spanner logo

Google Cloud Spanner

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

Extension
IBM i logo

IBM i

Collect performance data from your IBM i Hosts via this Remote extension.

Extension
Google reCAPTCHA Enterprise logo

Google reCAPTCHA Enterprise

Get insights into Google reCAPTCHA Enterprise metrics collected from the Google Operations API to ensure health of your cloud infrastructure

Extension
.NET logo

.NET

Automatic end-to-end observability for .NET applications and processes.

Extension
Google Cloud's operations suite logo

Google Cloud's operations suite

Get insights into Google Cloud's operations suite metrics collected from the Google Operations API to ensure health of cloud infrastructure.

Extension
Google Vertex AI logo

Google Vertex AI

Get insights into Google Vertex AI service metrics.

Extension
Oracle Exadata logo

Oracle Exadata

Monitor Oracle Exadata systems for performance, usage and availability

Extension