I checked the code behind sp_dbmmonitorupdate
system stored procedure which is called every minute by the mirror monitoring job. The SP has the following code within it:
exec @retcode = sys.sp_dbmmonitorMSgetthelatestlsn @database_name, @end_of_log_lsn output
I can see sp_dbmmonitorupdate is calling this SP. however i cannot see dbmmonitorMSgetthelatestlsn SP in any of the databases including master/msdb/mirrored databases.
Top 10 CPU intensive queries says this SP is created too frequently. How do i find which process is creating this SP?
sp_dbmmonitorupdate does not have the code to create the other sp. it's just invoking it(and i cannot find that SP).
Anyone has any ideas about it?