MS SQL Server Integration | Xitoring Document
Xitoring Document

MS SQL Server Integration

Microsoft SQL Server (MS SQL) is a powerful relational database management system developed by Microsoft. It supports a wide range of transaction processing, business intelligence, and analytics applications.

Monitoring MS SQL Server is essential to maintain high performance, availability, and data integrity. Xitoring provides an advanced monitoring solution for MS SQL Server, offering real-time visibility into essential performance metrics like query times, resource consumption, and active sessions.

Getting Access to MySQL Data

For gathering information and statistics from MySQL, you need to give Xitogent access to your database. As we do not recommend you give Xitogent your database root access, we are going to walk you through creating a user with the necessary privileges for Xitogent.

Supported platforms

The following guide is working on Linux and Windows servers but some details could be quite different based on the OS version.

Xitoring is currently supporting MS SQL Server 2012 and leter while the size_on_disk_bytes stat is only available in versions 2022 and later.

Create a user for Xitogent

First, execute the following command to create a login on your SQL server and set a password:

CREATE LOGIN xitoring WITH PASSWORD = '<PASSWORD>';

Then create a user for xitoring login:

CREATE USER xitoring FOR LOGIN xitoring;

Set the correct privileges

To enable the collection of metrics, Xitogent requires some privileges:

GRANT CONNECT ANY DATABASE to xitoring;
GRANT VIEW SERVER STATE to xitoring;
GRANT VIEW ANY DEFINITION to xitoring;
GRANT SELECT to xitoring;

Enable MS SQL Server Integration

There are no special requirements or software dependencies to enable this integration.

  1. To begin, run xitogent integrate and choose SQL Server from the list.

  2. Provide the IP address, port, username, and password for your MS SQL Server instance.

  3. Xitogent will test the connection and automatically complete the setup. Within moments, you'll start seeing real-time graphs and data on your Server page.

Setup Triggers for MS SQL Server Integration

With Xitoring, users can create Triggers for MS SQL Server to detect issues and respond quickly. Triggers can be set up based on a wide variety of parameters such as:

BufferCacheHitRatio
BatchRequestsPerSec
SqlCompilationsPerSec
TransactionsPerSec
UserConnections
LockTimeoutsPerSec
DeadlocksPerSec
LatchWaitsPerSec
PageLookupsPerSec
PageReadsPerSec
PageWritesPerSec
InsertsPerSec
UpdatesPerSec
DeletesPerSec
SelectsPerSec
TotalPerSec
MemoryUsage
+ many more