Templates: Database Servers – Microsoft SQL Express Database Server

Monitors included into Database Servers – Microsoft SQL Express Database Server template

The monitors from this application template checks essential services availbility and resource consumption for Microsoft SQL Express Database Server (2005-2014). Microsoft SQL Server Express is a version of Microsoft’s SQL Server relational database management system that is free to download, distribute and use. It comprises a database specifically targeted for embedded and smaller-scale applications. More about templates.

Monitors list

Monitors description

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 MSSQL Server answers on specified port. Default is 1433.

MSSQL Edition check (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 Express 2005.

Failures / sec User errors per sec.

Filestore, Kb The cumulative size of all the data files in the database.

Requests / sec Number of SQL batch requests received by server. Number of Transact-SQL command batches received per second. This statistic is affected by all constraints (such as I/O, number of users, cache size, complexity of requests, and so on). High batch requests mean good throughput.

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.

Total server memory, Kb Total server memory, Kb.

UDP admin port UDP admin port. Default is 1434.

User connections User connections count.

Templates overview

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.