Monitors included into Database Servers – Microsoft SQL Database Server template
The monitors from this application template check essential services availbility and resource consumption for Microsoft SQL Database Server (2005-2014). Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications which may run either on the same computer or on another computer across a network (including the Internet). SQL Server is the foundation of Microsoft’s data platform, delivering mission-critical performance with in-memory technologies and faster insights on any data, whether on-premises or in the cloud.
In order to use this application template please replace ‘MyInstanceName’ in the monitors parameters with an actual instance. More about templates.
DB sanity check: record count query (enabled by default) Test SQL query to check database integrity. You can replace this sample query with any suitable query that can indicate the database health.
SQL Server process count (enabled by default) Shows if MSSQL Server is alive.
TCP port (enabled by default) Shows if Server answers on specified port.
MSSQL Edition check (not Express) Checks if this template is suitable for the host. Disabled by default. This is a match monitor and used only in network discovery. You don’t need to enable it, since is does not check any valuable characteristic.
Active parallel threads Number of threads used by parallel queries in the workload group. Turn off for MSSQL 2005. Replace ‘MyInstanceName’ with actual instance name in WMI class name.
Failures / sec User errors per sec. Replace ‘MyInstanceName’ with actual instance name in WMI class name.
Filestore, Kb The cumulative size of all the data files in the database. Replace ‘MyInstanceName’ with actual instance name in WMI class name.
Requests / sec Number of SQL batch requests received by server. Replace ‘MyInstanceName’ with actual instance name in WMI class name.
SQL Server Analysis Services Shows if Analysis Service is alive.
SQL Server Browser process count Shows if Server Browser is alive.
SQL Server CPU usage Total Server CPU usage.
SQL Server memory usage Total Server memory usage.
Total deadlocks detected Number of lock requests that resulted in a deadlock. Replace ‘MyInstanceName’ with actual instance name in WMI class name.
Total server memory, Kb Total server memory, Kb. Replace ‘MyInstanceName’ with actual instance name in SQL Query.
UDP admin port UDP admin port.
User connections User connections count. Replace ‘MyInstanceName’ with actual instance name in SQL Query.
IPHost Network Monitor provides application templates (or just “templates” later in document), to create multiple relevant monitors in only a few clicks. Templates facilitate adding typical monitors sets; this can be particularly useful in case of big networks, when creating same-type monitors for many same-type devices is a common task. Application templates are sets of monitors that can be added, using specific predefined parameters, for a given host at once. The said set, added for given host, is displayed as a separate node in tree view pane, and is named application.
There are predefined templates; user can as well generate templates of their own – either out of existing monitors, or by cloning a predefined template. User-added template definitions are saved in XML files and can thus be conveniently augmented or applied to specific needs.