system queries showing as ran by user in sql sentry tool

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  June 23, 2016 at 7:16 pm

  #317370

  Hi, we use SQL Sentry tool to monitor our SQL Server Performance. When I look at the TOP SQL Queries, some times I notice the following queries. The strange thing is it shows that our developers are running the query but I know they are not actually running them.

  How would I find out what these queries are and who is actually running them?

  SELECT

  tr.name AS [Name],

  tr.object_id AS [ID]

  FROM

  sys.triggers AS tr

  WHERE

  (tr.parent_class = 0)

  ORDER BY

  [Name] ASC

  SELECT

  tr.name AS [Name],

  tr.object_id AS [ID],

  CAST(

  tr.is_ms_shipped

  AS bit) AS [IsSystemObject],

  CASE WHEN tr.type = N'TR' THEN 1 WHEN tr.type = N'TA' THEN 2 ELSE 1 END AS [ImplementationType],

  CAST(CASE WHEN ISNULL(smtr.definition, ssmtr.definition) IS NULL THEN 1 ELSE 0 END AS bit) AS [IsEncrypted]

  FROM

  sys.triggers AS tr

  LEFT OUTER JOIN sys.sql_modules AS smtr ON smtr.object_id = tr.object_id

  LEFT OUTER JOIN sys.system_sql_modules AS ssmtr ON ssmtr.object_id = tr.object_id

  WHERE

  (tr.parent_class = 0)

  ORDER BY

  [Name] ASC

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736105

  More actions

  June 25, 2016 at 7:59 am

  #1886886

  Is Performance Advisor running under a developer account?