Validation of SQL Server DB Trace Configuration

If you do not see the database metrics on the Applicare dashboard, after the configuration of SQL server database monitoring, Please check the following configuration.

• The MSSQL server and the Applicare agent should run in the same machine.
• Agent will create a SQLTraceProfiling.trc file in the agent installed directory to capture SQL data. If this file is not created then it means the user may not have the Sysadmin permission. If the user has the right permission and still the trace file is not created for that user then login into MSSQL Server with different sysadmin account and provide the grant Alter Trace permission for that user. Replace the <User> with Applicare login user and execute the below query.

Grant Alter Trace Permission

Syntax:
use master;
grant alter trace to <User>;

Example:
use master;
grant alter trace to appms;