How to generate SQL server trace logs to troubleshoot and verify SQL server functionality and performance.
SQL Server tracing can be used to generate logs containing information on all of the SQL transactions initiated on a SQL server. These logs can be useful in troubleshooting many Symantec Endpoint Protection Manager (SEPM)/SQL issues including:
The following steps can be used to create a SQL server trace log. This type of reporting is only available from a Microsoft SQL server - not an embedded Sybase database.
Note: The following procedure requires a SQL user with SA level permissions.