摘要: 创建索引 CREATE NONCLUSTERED INDEX CRM_WorkflowLog_AsyncOperationID ON [dbo].[WorkflowLogBase] ([AsyncOperationID]) GO CREATE NONCLUSTERED INDEX CRM_Dupli 阅读全文
posted @ 2020-10-14 17:49 【李】 阅读(117) 评论(0) 推荐(0) 编辑
摘要: 方案一: select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' USE [mas 阅读全文
posted @ 2020-10-14 17:38 【李】 阅读(124) 评论(0) 推荐(0) 编辑