The user is seeing a query beginning with the following SQL running every second on the system, initiated from SQL PI:
use [master]
SELECT
top (?)
t2.spid,
t2.login_time,
t2.request_id,
t1.start_time AS [request_starttime],
t1.[sql_handle] AS [sql_handle],
t1.statement_start_offset AS [syntax_start_key],
t1.statement_end_offset AS [syntax_end_key],
How can a user configure SQL PI so that the query runs less often?
How to make the SQL PI collections run less often (every five seconds instead of every one second)