[NOTICE] Mission Control - Deprecation of Execute SQL - Performance Queries action
Optimizely Configured Commerce has deprecated Mission Control's Execute SQL - Performance Queries action for a more advanced tool, Microsoft's Query Store.
Background
Optimizely initially developed the Performance Queries action to monitor performance for Configured Commerce instances using SQL 2012. As of today, these instances no longer use SQL 2012, and the Query Store is a more accurate and sophisticated solution for monitoring performance on newer SQL versions. Given these reasons, Optimizely will retire the Performance Queries action.
Recommended approach
For SQL 2017 and later versions, use the following approach to monitor your database performance:
- Run the Generate Database Credentials actionGenerate Database Credentials action in Mission Control. This provides you with time-sensitive and read-only credentials that let you access the database to run the Query Store.
- Connect with SQL Server Management Studio (SSMS). Establish a connection using the credentials generated with the Generate Database Credentials action.
- Utilize Microsoft's Query Store. Interactively use the Query Store to identify and analyze problematic queries.
For detailed guidance, see the Microsoft documentation on Monitoring Performance by Using the Query Store.
Contact Optimizely Support if you have any questions or need more assistance.