![]() Associate appropriate database credentials to the discovered database.From the Add Device window, provide the required details such as Device Type and Management Profile.To add a resource manually to the inventory: Optionally, add a database server manually to the infrastructure inventory. Use one of the following mechanisms to discover MS SQL servers to add them to your inventory: For Windows authentication support, install gateway version 7.0.0 or later. To monitor the MS SQL database, install gateway version 5.0.0 or later. The gateway establishes a connection to the database using Java Database Connectivity (JDBC) Java API and collects monitoring metrics using SQL queries. You can also apply agent-based templates to initiate MS SQL monitoring. Services related to SQL server information.Processes related to SQL server information.SQL server instances - Information about all SQL Server instances.The installed agent auto-discovers the MS SQL database and collects the following metric information: The administrator can deploy an agent or gateway to support MS SQL server agent-based or agentless monitoring. JDBC(Java Database Connectivity): 8.2.2.jre11.The Port, Connection TimeOut, and Is Secure values are not used while creating credentials. Create credentials with type as Database before assigning a template to a resource.A gateway management profile mapped to a resource. ![]() For more information, see Monitoring Privileges. serveradmin privilege to monitor the database.Database and port(1433) can be accessed by the gateway.Take proactive steps to resolve issues before it affects the end-users.Check metric graphs to view the monitoring updates.Monitoring the MS SQL database can help database administrators to: Microsoft SQL Server is a relational database management system developed by Microsoft. Describes the steps to monitor your MS SQL database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |