The Memory Manager object provides counters to monitor overall server memory usage, which can help you to identify performance bottlenecks. The SQLServer:General Statistics object provides counters to monitor general server-wide activity (log-ins, connections, blocked processes), which can be useful when there are many clients connecting and disconnecting from an instance of SQL Server. See database user permissions above for required permissions.Ī good practice is to create a separate user for Dynatrace to query required views.Example value: my_dbĭatabase user whose credentials are going to be used to establish a connection to the database and query performance counters. Only one logical database name can be specified here. This can be any database to which the supplied database user can connect. Name of the logical database to connect to. Port on the host on which SQL Server is ready to accept connections from ActiveGate. The address of the Microsoft SQL Server host. On all other SQL Database service objectives, the VIEW DATABASE STATE permission is required in the database.Ī meaningful endpoint name.On SQL Database Basic, S0, and S1 service objectives, and for databases in elastic pools, the server admin account or the Azure Active Directory admin account is required.On SQL Server and SQL Managed Instance, requires VIEW SERVER STATE permission.This table is present in almost every version of SQL Server except for Azure SQL (PaaS). System table is required for monitoring backups per database (optional).Permissions specified in the Microsoft documentation for sys.dm_os_performance_counters are required.The following permissions must be granted to the user with which the extension connects to a SQL Server instance: Database user permissions as described below.Check the Microsoft documentation for end-of-life details. Microsoft SQL Server with mainstream or extended support by Microsoft.Monitor a Microsoft SQL Server instance remotely using the ActiveGate extension. We recommend using the new Microsoft SQL Server extension for improved functionality and support. This extension documentation is now deprecated and will no longer be updated.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |