logo

Knowledge Base

Access official resources from Carbon Black experts

IMPORTANT ANNOUNCEMENT: On May 6, 2024, Carbon Black User eXchange (UeX) and Case Management will move to a new platform!
The Community will be in read-only mode starting April 19th, 7:00 AM PDT. Check out the blog post!
You will still be able to use the case portal to create and interact with your support cases until the transition, view more information here!

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

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

Environment

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

Question

  • 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?

Answer

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.

Related Content


Labels (1)
Labels:
Tags (2)
Was this article helpful? Yes No
No ratings
Article Information
Author:
CB_Support
Creation Date:
‎09-22-2022
Views:
274
Contributors
logo

Copyright © 2005-2023 Broadcom. All Rights Reserved. The term “Broadcom” refers to Broadcom Inc. and/or its subsidiaries.