![]() When you add a new SQL Server connection or edit the details of an existing connection, Spotlight Cloud tests its ability to connect. To apply a template to an existing SQL Server connection, see configuration templates. The alarms template option is applicable only when creating a new SQL Server connection. Select from any of the SQL Server configuration templates that you have created through configure alarms. Select the alarms configuration template to apply to this connection or select Factory Settings Template to apply the factory settings shipped with Spotlight Cloud. Refer to Add/edit VMware connection details or Add/edit Hyper-V connection details. See Manage Windows Server connections for more information.Ĭonfigure whether to monitor the virtual server hosting the SQL Server.ĭo not monitor - Select Do not monitor if you do not want Spotlight Cloud to monitor the virtual Server.Ĭlick Add hypervisor server to add a host for montitoring. Verify each Windows node is in the list of Windows Server connections.Ĭlick Add to add a Windows server to the list. Therefore each Windows node in the cluster must be monitored by Spotlight Cloud. Spotlight Cloud uses the current host node name to select the operating system connection. ![]() ![]() SQL Server HostĬonfigure whether to monitor the physical Windows server hosting the SQL Server.ĭo not monitor - Select Do not monitor if you do not want Spotlight Cloud to monitor the Windows Server.Ĭluster (monitor active node) - Select Cluster (monitor active node) for a Microsoft Cluster Server (MSCS). If the number of times Spotlight should attempt to connect to the SQL Server instance before raising an alarm is greater than 9 then type that number into the given field. Set the connection timeout and the number of times Spotlight should attempt to connect to the SQL Server instance before raising the Connection Failure alarm. Failure to select this option when required will result in some data not being collected for the secondary replica. ![]() Select this option if the SQL Server instance hosts a secondary replica of an availability group and for this secondary replica ApplicationIntent=ReadOnly. The connection will fail if the account permissions are insufficient to allow Spotlight Cloud to collect the data it needs. If this is not feasible in your environment, see How to grant SQL Server account permissions to a trusted user. It could be a SQL Server login (such as ‘sa’). Typically the account will be a member of the sysadmin server role. Ensure the database user has sufficient account permissions to retrieve performance data from the SQL Server instance and host by WMI. When using Windows authentication to connect to a SQL Server, and that SQL server is in a different domain to the Spotlight Cloud Diagnostic Server, the domain the SQL Server is in must trust the domain the Spotlight Cloud Diagnostic Server is in.Īlternatively, fill in the Database User and Password fields. Ensure this account is trusted by the SQL Server instance. Select Windows Authentication (using Diagnostic Server credentials) to use the Windows user configured to run the Spotlight Cloud Diagnostic Server (as a Windows service). Specify the authentication for Spotlight Cloud to use to connect to the SQL Server instance. Prefix the port number with the server name or IP address. Add the port number in one of the following formats.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |