How CM works

Customer Support

+421-2-5465-0242

send email >>

Online support - chat (bottom right)

MS SQL availability

Availability of MS SQL can be monitored in CM at least by the following two methods :

 

1. Standard CM conditions, e.g. service status

use the Watches condition Service status for SQL services. Usually it's a service of the MS SQL server for each instance and agent services.

Configuration of the conditions Service status in C-MonitorConsole

Image: Konfigurácia podmienok Service status v C-MonitorConsole


Illustration of the view of service status on CM Portal

Image: Ukážka zobrazenia stavu služieb v CM Portáli


2. Test of access to SQL server by a prepared template from Watches

It's more efficient to determine function of all services by real access to the SQL server, C-Monitor is able to simulate access to the SQL server by using CHAT scripts. You don't need to write any script, it's already prepared and all you have to do, is to enter name of the SQL server or its instance in the correct form, and username and password for access

You must choose name of the SQL server, resp. the instance according to type of its installation. For the first SQL instance with the default configuration, write one of the following options into the field Server :
       1.  network name of the server
       2.  network name of the server\ name of instance (the name of instance only is there's only one, it's usually MSSQLSERVER or SQLSERVERor possibly SQLEXPRESS). For other instances, write name of the service for the SQL server's instance in the form  MSSQL$instance_name

The test's result is the success / failure of access to SQL. We recommend to use performance tests running on this exact same principle, through which you don't just measure the success of access to SQL server, but also the time of the SQL server's response, or even of a selected database, in miliseconds. Find out more in the article MS SQL performance by measuring of time

Test of access to SQL server - selection from the prepared templates

Image: Testu prístupu k SQL serveru - výber z predpripravených šablón



Parameters for configuration of the access test to SQL server

Image: Parametre pre konfiguráciu prístupového testu k SQL serveru

Work with the script, such as testing and signing, is described in the article MS SQL performance by measuring of time

Images: 
Konfigurácia podmienok Service status v C-MonitorConsoleUkážka zobrazenia stavu služieb v CM PortáliTestu prístupu k SQL  serveru - výber z predpripravených šablónParametre pre konfiguráciu prístupového testu k SQL serveru