November 8, 2023 at 3:50 am
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!
November 8, 2023 at 3:58 pm
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