Synthetic Transaction to Measure Application Performance

This custom metric tracks the time it takes for a query to execute against one of your monitored instances. The query can be something one of your applications runs often, a query that is important to your business, etc. In the example, I use a simple query against sys.dm_exec_requests DMV. If you want to alert off this metric, ensure thresholds are also configured and create a Resource Alert against it.