App Control: Should the SQLPerformanceHistory Function Explicitly Reference 'tempdev' and 'templog' Tables?

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

• SQL best practices indicate there should not be any direct references to temp tables due to other applications/process sharing these tables. Should the SQLPerformanceHistory function explicitly reference the 'tempdev' and 'templog' tables?

Environment

• App Control Server: All Versions
• SQL Server: All Versions

Resolution

Yes, per the OER and SQL Server configuration guides there should be a 'dedicated SQL server instance' for the App Control Server. With a dedicated SQL Server instance to the App Control Server there will be no other resource sharing occurring.