Just Published! Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

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)
Tags (2)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎09-22-2022
Views:
70
Contributors