![]() ![]() The health (Clear, Warning, Critical) of the MS SQL server. Click on the monitor name to see all the MS SQL Database metrics listed under the following tabs: Provided below is the list of different metrics monitored with SQL monitoring. Visit our page on SQL performance tuning where you can get detailed information on the parameters used to optimize your SQL database and how to monitor them using Applications Manager. List view enables you to perform bulk admin configurations.Performance tab gives the Health Status and events for the past 24 hours or 30 days.Availability tab gives the Availability history for the past 24 hours or 30 days.Displayed is the MS SQL bulk configuration view distributed into three tabs: Click on MS SQL under the Databases Table. Go to the Monitors Category View by clicking the Monitors tab. Once enabled, you can also customize the polling interval of these metrics. Note: Applications Manager's SQL Server Performance monitoring allows you to enable/disable data collection of critical SQL metrics like Jobs, Backup and Replications. This discovers MS SQL database server from the network and starts monitoring them. You can choose multiple groups to associate your monitor. Choose the Monitor Group from the combo box with which you want to associate MS SQL database server Monitor (optional).Choose jTDS JDBC Driver or Microsoft JDBC Driver option in Driver for SQL Server Connection field to choose the required driver for connecting to the database for data collection.Choose Force Encryption option if the server is configured for encrypted connections. ![]() If you want to connect using a Named Instance, check the Connect using Named Instance checkbox and specify the instance name.Select the Enable Kerberos Authentication checkbox, if you want to monitor MS SQL server through Kerberos authentication.Alternatively, you can provide the Windows Authentication details (give the User Name like domainname\username) also. The user name specified for collecting the data from MS SQL Server should have either System Administrator role or the user should be the DB owner for master database. Provide the User Name and Password of user who has permission to access the MS SQL database.If you are adding a new monitor from an Admin Server, select a Managed Server.Enter the polling interval time in minutes.Enter the Port number in which the MS SQL is running.To add MsSQL as a cluster type monitor, enter the Virtual IP Address or the Listener IP Address of the cluster. Enter the IP Address or Hostname of the host.To create a MS SQL database server Monitor, follow the given steps: Prerequisites to create a new monitor: Click here It is an agentless monitoring solution that provides out-of-the-box performance metrics making sure that the SQL server runs efficiently. Applications Manager's SQL Server monitoring feature helps database administrators monitor the performance and availability of production databases. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |