Products documentation - products:cockpit:1.0:monitorsguide:mssql

MS-SQL Autogrowth

Anonymous (anonymous@undisclosed.example.com) — 2026-02-20T16:43:05+00:00

MS-SQL Autogrowth Purpose

SQL Server engine expands the size of a database file when it runs out of space, the amount by which a database file grows is based on settings.

It is then very important to be able to monitor files growth size, their size percentage within the disk size, the remaining free disk space after the expansion.

MS-SQL Backups

Anonymous (anonymous@undisclosed.example.com) — 2026-02-20T16:43:05+00:00

MS-SQL Backups Purpose

When a disaster strikes SQL Server databases, a efficient working backup is essential in order to recover from most disasters

Backup will also help to protect against database upgrades that go bad, table corruption, and other system problems.

Monitoring database backup execution results becomes then crucial in order to guarantee Database Administrators that a full database recovery is possible, database damages etc..

MS-SQL Configurations

Anonymous (anonymous@undisclosed.example.com) — 2026-02-20T16:43:05+00:00

MS-SQL Configurations Purpose The default setting for min server memory is 0, and the default setting for max server memory is 2,147,483,647 MB. The minimum memory amount allowable for max server memory is 128 MB. By default, SQL Server can change its memory requirements dynamically based on available system resources.

MS-SQL File size

Anonymous (anonymous@undisclosed.example.com) — 2026-02-20T16:43:05+00:00

MS-SQL File size Purpose To monitor database files size, with the ability to filter by type of file and specific filenames if necessary. Context SQL Server files can grow automatically from their originally specified size. When you define a file, you can specify a specific growth increment. Every time the file is filled, it increases its size by the growth increment. If there are multiple files in a filegroup, they will not autogrow until all the files are full.

MS-SQL Free disk space

Anonymous (anonymous@undisclosed.example.com) — 2026-02-20T16:43:05+00:00

MS-SQL Free disk space Purpose SQL Server files can grow automatically from their originally specified size. When you define a file, you can specify a specific growth increment. Every time the file is filled, it increases its size by the growth increment.

MS-SQL Free List Stalls

Anonymous (anonymous@undisclosed.example.com) — 2026-02-20T16:43:05+00:00

MS-SQL Free List Stalls Purpose To troubleshoot IO issues within SQL Server, it is necessary to determine if IO response times and throughput are within expected ranges and if they impact SQL Server performance. Being able to monitor those performance items become then crucial to rapid and efficiently react to troubleshoot.

MS-SQL Free space in file

Anonymous (anonymous@undisclosed.example.com) — 2026-02-20T16:43:05+00:00

MS-SQL Free space in file Purpose The disk space allocated to a data file is logically divided into pages and extents Being able to monitor database files free space evolution becomes then important to stablish a good database storage strategy.

MS-SQL Performances

Anonymous (anonymous@undisclosed.example.com) — 2026-02-20T16:43:05+00:00

MS-SQL Performances Purpose Most of the indicators that provide the information needed are operating system counters, especially those that deal with CPU activity, memory, paging, and the network interface. In SQL Server, you should monitor connections, transactions, and locks.

MS-SQL Used space in file

Anonymous (anonymous@undisclosed.example.com) — 2026-02-20T16:43:05+00:00

MS-SQL Used space in file Purpose The disk space allocated to a data file is logically divided into pages and extents Being able to monitor database files used space evolution becomes then important to stablish a good database storage strategy.