Bindplane

The Bindplane Developer Hub

Welcome to the Bindplane developer hub. You'll find comprehensive guides and documentation to help you start working with Bindplane as quickly as possible, as well as support if you get stuck. Let's jump right in!

Microsoft Azure SQL Database

Connection Parameters

Name
Required?
Description

Host

Required

The Microsoft SQL database to connect to.

Port

The port for communication to the Microsoft SQL database.

Use Active Directory

Username

Required

Password

Required

Query Count Per Database

Exclude Textless Queries

Databases

Comma-separated list of database(s) to monitor. Leave blank to monitor all databases.

Exclude Events

A comma separated list of strings. Events will not be created when their message contains any of these strings.

Max Threads

Collect Objects

Whether or not to collect Object resources.

Metrics

Database

Name
Description

Active Connections (Connections)

The number of active connections to the database

Active Transactions

Number of active transactions on database

Approximate Last Start Date

The approximate time that the database was started

Auto Close

Shows whether auto close is enabled

Auto Create Statistics

Shows whether auto create statistics is enabled.

Auto Shrink

Shows whether auto shrink is enabled.

Auto Update Statistics

Shows whether auto update statistics is enabled.

Average CPU Utilization (%)

Average compute utilization in percentage of the limit of the service tier.

Average Data I/O Utilization (%)

Average data I/O utilization in percentage of the limit of the service tier.

Average Log Write Resource Utilization (%)

Average write resource utilization in percentage of the limit of the service tier.

Average Memory Usage (%)

Average memory utilization in percentage of the limit of the service tier.

Background Processes

The current number of background processes

Blocked Processes

The current number of blocked processes

Buffer Ideal Page Life Expectancy (Seconds)

The Buffer Ideal Page Life Expectancy of the Database.

Buffer Pool Size (Mebibytes)

Total size of the buffer pool for a database

Connections (Connections)

The total number of connections to the database

Creation Date

Date the database was created or last renamed

Data Space Usage (Mebibytes)

Database data space

Dormant Processes

The current number of dormant processes

DTU Limit

Current max database DTU setting for this database during this interval.

ID

Database identification number (unique within the Azure SQL Database server)

In-Memory OLTP Storage Utilization (%)

Storage utilization for In-Memory OLTP in percentage of the limit of the service tier (at the end of the reporting interval).

Index Space Usage (Mebibytes)

Database index space

Instance Wait Time (Milliseconds)

Total wait time of the server

IOPS (Operations)

Total amount of disk write and read operations.

Maximum Concurrent Sessions (%)

Maximum concurrent sessions in percentage of the limit of the database's service tier.

Maximum Concurrent Workers (%)

Maximum concurrent workers (requests) in percentage of the limit of the database's service tier.

Maximum Storage Size (Megabytes)

Maximum storage size for the time period, including database data, indexes, stored procedures and metadata

Name

Name of the database (unique within the Azure SQL Database server)

Possible Connections (Connections)

The maximum number of possible connections to the database

Preconnect Processes

The current number of preconnect processes

Read Data (Bytes)

Disk read data for database.

Read Delay (Milliseconds)

Total time, in milliseconds, that the users waited for reads issued on files for the database

Read Only

Shows whether read only mode is enabled.

Read Operations (Operations)

This metric represents the amount of disk read operations over time.

Recovery Model

Description of the recovery model selected for the database

Reserved Space (Mebibytes)

Database reserved space

Runnable Processes

The current number of runnable processes

Runnable Tasks Count

Number of workers, with tasks assigned to them, that are waiting to be scheduled on the runnable queue

Running Processes

The current number of running processes

Server Name

Logical server name

Service Tier

Service Tier of the database

Single User Mode

Shows whether single user mode is enabled.

Size Used (Mebibytes)

Database size

Sleeping Processes

The current number of sleeping processes

Status

Description of the database state

Suspended Processes

The current number of suspended processes

thread_count

The number of workers that are associated with this database. This includes workers that are not assigned any task

Time Since Creation (Days)

Days since database was created.

Time Since Last Start (Days)

The approximate number of days since the database was started

Total Data (Bytes)

Total disk read and write data for database.

Unused Reserved Space (Mebibytes)

Database unused reserved space

User Lookups

Total number of bookmark lookups by user queries

User Scans

Total number of scans by user queries. This represents scans that did not use 'seek' predicate.

User Seeks

Total number of seeks by user queries

User Updates

Total number of updates by user queries. This includes Insert, Delete and Updates representing number of operations done not the actual rows affected. For example, if you delete 1000 rows in one statement, this count will increment by 1

Write Data (Bytes)

Disk write data for database.

Write Delay (Milliseconds)

Total time, in milliseconds, that users waited for writes to be completed on files for the database

Write Operations (Operations)

This metrice represents the amount of disk write operations over time.

Geo-Replication Database

Name
Description

Database Name

Name of the database (unique within the Azure SQL Database server)

Last Replication

The timestamp of the last transaction's acknowledgement by the secondary based on the primary database clock

Link ID

Unique ID of the geo-replication link

Modify Date

UTC time at regional SQL Database datacenter when the database geo-replication has completed. The new database is synchronized with the primary database as of this time.

Name

Name of the database and the logical server

Partner Database ID

Partner database identification number (unique within the Azure SQL Database server)

Partner Server Name

Name of the logical server containing the linked database

Replication Lag (Seconds)

Time difference in seconds between the last_replication value and the timestamp of that transaction's commit on the primary based on the primary database clock

Replication State

The state of geo-replication for this database

Replication State Description

Description of the state of geo-replication for this database

Role

The Geo-replication role for this database

Role Description

Description of the Geo-replication role for this database

Secondary Allows Connections

The secondary type

Secondary Allows Connections Description

Description of the secondary type

Server Name

Logical server name

Start Date

UTC time at a regional SQL Database datacenter when the database replication was initiated

Object

Name
Description

Average Page Lock Wait Duration (Milliseconds)

Average number of milliseconds the Database Engine waited on a page lock

Average Row Lock Wait Duration (Milliseconds)

Average number of milliseconds the Database Engine waited on a row lock

Database ID

Database identification number (unique within the Azure SQL Database server)

Database Name

Name of the database (unique within the Azure SQL Database server)

Name

Object name

Page Locks Acquired

Cumulative number of times the Database Engine waited on a page lock

Page Locks Requested

Cumulative number of page locks requested

Row Locks Acquired

Cumulative number of times the Database Engine waited on a row lock

Row Locks Requested

Cumulative number of row locks requested

Query

Name
Description

Average Execution Time (Microseconds)

The average execution time for the query

Database ID

Database identification number (unique within the Azure SQL Database server)

Database Name

Name of the database

Execution Context Name

The name of the context in which the query was executed

Execution Context Type

Type of context in which the query was executed

Execution Count

Number of times that the plan has been executed since it was last compiled

Execution Time (Microseconds)

Total amount of CPU time consumed by executions of this plan since it was compiled

Last Execution (Microseconds)

Last time at which the plan started executing

Name

The Name of the Query.

SQL Handle

A token that refers to the batch or stored procedure that the query is part of

SQL Text

The text of the query

Statement End Offset

Indicates, in bytes, starting with 0, the ending position of the query that the row describes within the text of its batch or persisted object. For versions before SQL Server 2014, a value of -1 indicates the end of the batch

Statement Start Offset

Indicates, in bytes, beginning with 0, the starting position of the query that the row describes within the text of its batch or persisted object

Unique Query Plans

The number of unique plans for this query

Server

Name
Description

Active Connections (Connections)

The total number of active connections across databases on the server.

Name

Logical server name

SQL Version

Azure SQL Version

Type

Is the server configured in a failover cluster