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

[#1]

Environment

• App Control 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. Download and extract the CB Analysis Script.
2. Log in to the application server hosting the Console as the Carbon Black Service Account. 
3. Open SQL Server Management Studio and connect to the SQL Server.
4. Click File > Open > File (CTRL+O) and select CB_Analysis_Script.sql 
5. Click Query > Results To > Results to Text (CTRL+T).
6. Click Execute and once the script completes, right click the results and choose Save Results As...
7. Next > expand Management > right-click SQL Server Logs > View > select SQL Server Log > check the Current log  > click Export
8. Collect a copy of the following files from the Parity Server directory:

   \Program Files (x86)\Bit9\Parity Server\ServerLog.bt9
   \Program Files (x86)\Bit9\Parity Server\Reporter\ParityReporter.log

9. Attach or Upload the collected logs to the Vault and provide an update to the case.

Related Content

App Control: Collecting Historical Logs for Server Troubleshooting (Locally)
App Control: Collecting Historical Logs for Server Troubleshooting (Remotely)
App Control: How to Collect Historical Agent Logs on Windows (Locally)
App Control: How To Collect Agent Performance Logs on Windows (Locally)