恶魔王子爱上天使,南京会斯通集团总裁,渝中区人力资源和社会保障局
selecttop50(total_logical_reads+total_logical_writes)astotal_logical_io,(total_logical_reads/execution_count)asavg_logical_reads,(total_logical_writes/execution_count)asavg_logical_writes,(total_physical_reads/execution_count)asavg_phys_reads,substring(st.text,(qs.statement_start_offset/2)+1,((caseqs.statement_end_offsetwhen-1thendatalength(st.text)elseqs.statement_end_offsetend-qs.statement_start_offset)/2)+1)asstatement_text,*fromsys.dm_exec_query_statsasqscrossapplysys.dm_exec_sql_text(qs.sql_handle)asst
orderbytotal_logical_iodesc
read_commited方法开启
--查询状态select name,user_access,user_access_desc, snapshot_isolation_state,snapshot_isolation_state_desc, is_read_committed_snapshot_onfrom sys.databases--设置数据库为single_user模式,减少锁定时间alterdatabaseprjidbzzhsetsingle_userwithrollbackimmediatealterdatabaseprjidbzzhsetallow_snapshot_isolationonalterdatabaseprjidbzzhsetread_committed_snapshotonalterdatabaseprjidbzzhsetmulti_user
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
数据库SQL---数据库、基本表、视图、索引的定义、修改、删除
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (上)
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (下)
网友评论