https://wiki.redpeaks.io/ 2026-04-04T09:03:42+00:00 https://wiki.redpeaks.io/ https://wiki.redpeaks.io/lib/exe/fetch.php?media=wiki:logo.png text/html 2026-02-20T16:43:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.redpeaks.io/doku.php?id=products:promonitor:6.8:monitorsguide:mssql:ms-sqlautogrowth&rev=1771605785&do=diff 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 monitor files growth size, their percentage size within the disk size, the remaining free disk space after the expansion. text/html 2026-02-20T16:43:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.redpeaks.io/doku.php?id=products:promonitor:6.8:monitorsguide:mssql:ms-sqlbackups&rev=1771605785&do=diff 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. text/html 2026-02-20T16:43:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.redpeaks.io/doku.php?id=products:promonitor:6.8:monitorsguide:mssql:ms-sqlconfigurations&rev=1771605785&do=diff 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. text/html 2026-02-20T16:43:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.redpeaks.io/doku.php?id=products:promonitor:6.8:monitorsguide:mssql:ms-sqlfilesize&rev=1771605785&do=diff 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. text/html 2026-02-20T16:43:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.redpeaks.io/doku.php?id=products:promonitor:6.8:monitorsguide:mssql:ms-sqlfreediskspace&rev=1771605785&do=diff 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. text/html 2026-02-20T16:43:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.redpeaks.io/doku.php?id=products:promonitor:6.8:monitorsguide:mssql:ms-sqlfreeliststalls&rev=1771605785&do=diff 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. text/html 2026-02-20T16:43:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.redpeaks.io/doku.php?id=products:promonitor:6.8:monitorsguide:mssql:ms-sqlfreespaceinfile&rev=1771605785&do=diff 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. text/html 2026-02-20T16:43:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.redpeaks.io/doku.php?id=products:promonitor:6.8:monitorsguide:mssql:ms-sqlperformances&rev=1771605785&do=diff 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 also monitor connections, transactions, and locks. text/html 2026-02-20T16:43:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.redpeaks.io/doku.php?id=products:promonitor:6.8:monitorsguide:mssql:ms-sqlusedspaceinfile&rev=1771605785&do=diff 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.