SQL Scripts automatically invoked

  • When detecting the processes in the SQL Server 2012, I found there was a SQL scrit executed automatically automatically many times, the following as attachment,

    do you know when the script will be executed and when it will be executed? thanks a lot!

  • sorry , as sql type file is not allowed, adding its txt file

    Attachments:
    You must be logged in to view attached files.
  • Looks like a monitoring query. It's probably being run from a monitoring tool. I've no idea how to tell you when it will next be executed. I'd suggest you use Extended Events to capture the query and see where it's coming from there.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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