A SQL Server Database Engine is an installation of the Microsoft SQL Server core RDBMS service.
This may be installed on:
- A physical windows server
- A virtual windows server (e.g. VMWare or HyperV)
- A cloud IaaS server (e.g. AWS EC2 or Azure)
To add a SQL Server Database Engine instance to RockSolid please perform the following steps.
First go to Manage -> Instances in the RockSolid console. From here:
- Choose the site for which this instance is to be added from the Site drop down.
- Enter the instance name in the Instance text box. Hit search. Verify that the instance is not already listed.
- If the instance does not exist then click the + add instance button in the search header row.
This will take you to the Add Instance screen. From this screen, perform the following steps to add the instance.
- Enter the instance name in the Name text box.
- Choose the site to which the instance is being added from the site drop down.
- Select the Service Provider in the drop down for this option. The service provider defines which sites policies will be applied to this instance. If you have a single site structure accept the default.
- Choose the domain to which this instance is applied. Note: domains in RockSolid are for organisational purposes only, this information does not change the way in which instances are monitored.
- Specify the location of the instance from a timezone perspective. This is important to ensure it is correct as this is used to standardise the monitoring data into a common time series.
- Choose the appropriate Instance Group to add this instance to. The instance group will commonly have the relevant monitoring and configuration policy definitions defined which will be applied to this instance.
- Choose the relevant SQL Server engine type. In this example it should be set to the default of "SQL Server Database Services".
- Choose the Node Type for this instance. If this is a normal SQL Sever installation this should be set to "Node". If this is an availability group listener, this should be set to "Listener".
- IP Address - If name resolution between the RockSolidAgent host and the SQL Server instance to be monitored is possible (i.e. they are on the same domain), you do not need to enter the IP Address. This should only be entered if name resolution is not possible.
- Port - If the SQL Server instance is not on a default port and/or the SQL Browser service is not running then you should specify the correct port to connect to the SQL Server instance.
- Department - This can be added for administrative purposes, if you wish to document which site department this relates to.
- Branch - This can be added for administrative purposes, if you wish to document which site branch this relates to.
- Nickname - This option allows you to specify a meaningful name for this SQL Server instance. You can then search on the nickname in RockSolid to locate this instance instead of the instance name. For example, if the instance is called WIN-621KIS03P58\INS1 you may want to nickname the instance ERP as an example to make future searches easier.
- Description - Enter a general description of this instance for future documentation reference.
One these details have been added click the SAVE icon to add the instance to RockSolid.
Verifying the Added Instance
Once you have added the instance, RockSolid with automatically reconfigure the relevant agent to start monitoring the new instance. This process may take 1-2 minutes from the time of adding the instance to complete.
To verify the instance is added successfully, search for the instance from the Manage -> Instances screen. Ensure you untick the "Supported" and "Monitored" check boxes.
Once monitoring is established information pertaining to the SQL Server instance, such as version and number of user databases, will begin appearing in the RockSolid console.