Need to monitor single schema of a dB instance

Ranjith_Kumarka — Fri, 02 Jun 2023 07:29:57 GMT

We are now monitoring MS SQL database instances that have numerous schema, however our requirement is to simply monitor the performance of a single schema.

I submitted a request at the help site for that, and I got the below response.

Problem statement:
Wanted to monitor only dB instead of complete MSSQL dB server
Next steps:
By default, agent will monitor all dBs in the MySQL server instance.

The option available to restrict not to monitor certain databases are available. For this you need to exclude unwanted databases using "Exclude Databases" option in collector configuration. Refer: https://docs.appdynamics.com/appd/23.x/latest/en/database-visibility/add-database-collectors/configure-microsoft-sql-server-collectors and look for "Exclude Databases" option.

However, omitting the database is not a solution because doing so will make it harder to monitor the remaining databases.

Please give us your suggestions so we can solve this problem more quickly.

Re: Need to monitor single schema of a dB instance

iamryan — Tue, 06 Jun 2023 15:38:54 GMT

Hi @Ranjith.Kumarkar,

Did you tell the Support Agent that? Did they say anything about what you said?

topic Re: Need to monitor single schema of a dB instance in Splunk AppDynamics

Need to monitor single schema of a dB instance

Re: Need to monitor single schema of a dB instance