App Control: How to Collect Database Logs for Performance Issues (SQL Server)

App Control: How to Collect Database Logs for Performance Issues (SQL Server)

Environment

  • App Control (Formerly, CB Protection) Server: All Supported Versions
  • Microsoft SQL Server: All Supported Versions

 

Objective

This article details how to collect diagnostic logs for SQL performance cases

 

Resolution

  1. Export SQL logs:
    1. Open SQL Management Studio
    2. Connect to the SQL instance hosting the DAS database
    3. Expand Management > right-click on SQL Server Logs > select View > select SQL Server Log > check the Current log  > click Export
  2. Download and extract the Database Performance Scripts
    1. Open SQL Server Management Studio
    2. Open a new script window
    3. Press CTRL+T to force output as a text file
    4. Run all attached scripts, using F5 to execute each one
  3. Export the Windows Events for Application and System:
  4. Attach all of the above to the support case, or if the files are too large, please reach out to Support for an upload link.
    • Please comment on your support case once the files are uploaded so that we are aware of the incoming files.

 

Related Content

 

Tags (2)
Attachments
Was this article helpful? Yes No
100% helpful (1/1)
Article Information
Author:
Creation Date:
‎05-09-2018
Views:
3936
Contributors