App Control: Should the SQLPerformanceHistory Function Explicitly Reference 'tempdev' and 'templog' Tables?
App Control Server: All Versions
SQL Server: All Versions
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?
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.