检查SQL锁表信息,Eventinfo 有大量的exec sys.sp_dbmmonitorupdate 信息。之前是很少的(相对其他语句锁表的问题)。
我想这个是系统运行的,但是不明白什么意思。主要内容如下:
--individual query主要描述如下:
--================================================================================================
insert into @perfcounters select counter_name, cntr_value
from sys.dm_os_performance_counters
where (object_name = @perf_instance1 or object_name = @perf_instance2 ) and
instance_name = @database_name and
counter_name IN (N'Log Send Queue KB', N'Log Bytes Sent/sec', N'Redo Queue KB', N'Redo Bytes/sec',
N'Transaction Delay', N'Log Bytes Flushed/sec', N'Transactions/sec')
-- TO DO select all perfcounters for all databases so that you only need to access them once.
--==================================================================================================
delete from msdb.dbo.dbm_monitor_data where time < @oldest_date and database_id = @database_id
--=================================================================================================
insert into msdb.dbo.dbm_monitor_data
(database_id, role, status, witness_status, failover_lsn, end_of_log_lsn, log_flush_rate,
send_queue_size, send_rate, redo_queue_size, redo_rate, transaction_delay, transactions_per_sec, time, local_time)
values( @database_id, @role, @status, @witness_status, @failover_lsn, @end_of_log_lsn, @log_flush_rate, @send_queue_size, @send_rate,
@redo_queue_size, @redo_rate, @transaction_delay, @transactions_per_sec, @time, @local_time ) -- -- R
什么原因可能会造成这种情况?之前没有这么多的。
我想这个是系统运行的,但是不明白什么意思。主要内容如下:
--individual query主要描述如下:
--================================================================================================
insert into @perfcounters select counter_name, cntr_value
from sys.dm_os_performance_counters
where (object_name = @perf_instance1 or object_name = @perf_instance2 ) and
instance_name = @database_name and
counter_name IN (N'Log Send Queue KB', N'Log Bytes Sent/sec', N'Redo Queue KB', N'Redo Bytes/sec',
N'Transaction Delay', N'Log Bytes Flushed/sec', N'Transactions/sec')
-- TO DO select all perfcounters for all databases so that you only need to access them once.
--==================================================================================================
delete from msdb.dbo.dbm_monitor_data where time < @oldest_date and database_id = @database_id
--=================================================================================================
insert into msdb.dbo.dbm_monitor_data
(database_id, role, status, witness_status, failover_lsn, end_of_log_lsn, log_flush_rate,
send_queue_size, send_rate, redo_queue_size, redo_rate, transaction_delay, transactions_per_sec, time, local_time)
values( @database_id, @role, @status, @witness_status, @failover_lsn, @end_of_log_lsn, @log_flush_rate, @send_queue_size, @send_rate,
@redo_queue_size, @redo_rate, @transaction_delay, @transactions_per_sec, @time, @local_time ) -- -- R
什么原因可能会造成这种情况?之前没有这么多的。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货