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
- Download and extract the CB Analysis Script.
- Log in to the application server hosting the Console as the Carbon Black Service Account.
- Open SQL Server Management Studio and connect to the SQL Server.
- Click File > Open > File (CTRL+O) and select CB_Analysis_Script.sql
- Click Query > Results To > Results to Text (CTRL+T).
- Click Execute and once the script completes, right click the results and choose Save Results As...
- Next > expand Management > right-click SQL Server Logs > View > select SQL Server Log > check the Current log > click Export
- 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
- Attach or Upload the collected logs to the Vault and provide an update to the case.
Related Content