The user is seeing this query running constantly on the system, initiated from SQL PI:
use [master] SELECT A.request_session_id, A.request_request_id, A.resource_type, A.resource_associated_entity_id, A.resource_database_id, A.resource_subtype, convert(nvarchar(100),substring(A.resource_description,1,100)) AS resource_description FROM sys.dm_tran_locks AS A WITH ( NOLOCK ) WHERE A.request_status = 'WAIT'
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)
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center