system queries showing as ran by user in sql sentry tool

  • 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

  • Is Performance Advisor running under a developer account?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply