文档中没有介绍的SQL Server DBCC命令
来源:互联网 发布:淘宝手机端详情页链接 编辑:程序博客网 时间:2024/06/05 17:10
文档中没有介绍的SQL Server DBCC命令
http://www.searchdatabase.com.cn/showcontent_11822.htm
http://www.searchdatabase.com.cn/showcontent_11823.htm
http://www.searchdatabase.com.cn/showcontent_11824.htm
--------------------------------------------------------------------------------------------
--以下代码为保存在测试过程中的CPU,IO,MEM相关 损耗情况。
--dbcc sqlperf(THREADS)
--dbcc sqlperf(waitstats)
ALTER PROCEDURE [dbo].[MP_TRACE_LOG] AS
BEGIN
SET NOCOUNT ON
declare @LgReads bigint
select @LgReads=cntr_value from master.dbo.sysperfinfo where counter_name='Page lookups/sec'
if object_id(N'tempdb.dbo.#waits') is not null GOTO InsertTb
if object_id(N'tempdb.dbo.#waits') is null GOTO CreateTb
declare @thread_qty varchar(2),@stime varchar(6)
set @stime=substring(convert(varchar(20),getdate(),120),12,5)
CreateTb:
create table #waits (type varchar(128), req bigint, waittime bigint, signal bigint) GOTO InsertTb
InsertTb:
insert into #waits exec('dbcc sqlperf(waitstats)')
insert into TST_WaitsLog (DT,CPU,Locks,Reads,Writes,Network,PhReads,PhWrites,LgReads,threads_desc)
select
getdate() AS DT,
CAST(@@CPU_BUSY * CAST(@@TIMETICKS AS FLOAT) / 1000 AS BIGINT) as CPU, -- in milliseconds
sum(convert(bigint, case when type like 'LCK%'
then waittime else 0 end)) as Locks,
sum(convert(bigint, case when type like 'LATCH%' or type like 'PAGELATCH%' or type like 'PAGEIOLATCH%'
then waittime else 0 end)) as Reads,
sum(convert(bigint, case when type like '%IO_COMPLETION%' or type='WRITELOG'
then waittime else 0 end)) as Writes,
sum(convert(bigint, case when type in ('NETWORKIO','OLEDB')
then waittime else 0 end)) as Network,
@@TOTAL_READ AS PhReads, @@TOTAL_WRITE AS PhWrites, ISNULL(@LgReads, 0) AS LgReads
from #waits
CreateStateTb:
create table #io(spid int,thread_id int,t_status varchar(100),
t_loginname varchar(100),t_io int,t_cpu int,t_mem int)
InsertStateTbData:
insert into #io exec('dbcc sqlperf(THREADS)')
insert into TST_Statelog
select GETDATE(),t_loginname,SUM(t_io) as tio,
SUM(t_cpu) as tcpu,SUM(t_mem) as tmem
from #io
group by t_loginname
union all
select GETDATE(),'All Total',SUM(t_io) as tio,
SUM(t_cpu) as tcpu,SUM(t_mem) as tmem
from #io
END
- 文档中没有介绍的SQL Server DBCC命令
- 一些有用但文档中没有介绍的sql server DBCC命令
- Sql Server中的DBCC命令详细介绍
- Sql Server中的DBCC命令详细介绍
- SQL SERVER中dbcc checkdb 命令
- SQL Server DBCC命令
- SQL Server DBCC命令
- SQL Server DBCC命令
- sql server未经确认的dbcc命令
- SQL SERVER DBCC命令解释
- SQL SERVER DBCC命令解释
- SQL SERVER DBCC命令解释
- SQL SERVER DBCC命令解释
- SQL SERVER DBCC命令解释
- SQL SERVER DBCC命令解释
- SQL SERVER DBCC命令解释
- SQL SERVER DBCC命令参考
- SQL SERVER DBCC命令解释
- 求两点之间的距离
- 图像放大方法概述
- 63_判断某一年是否是闰年
- 剡剡提供伤感QQ日志_这悲伤的悲魂曲里的音符
- linux常用命令
- 文档中没有介绍的SQL Server DBCC命令
- 二次函数求解
- 继续小测python web server
- 使用NSOperation和NSOperationQueue启动多线程的教程
- Openwrt中wan与lan接口说明
- 求圆的等数据
- 我是傻,总是一而再三的去相信。
- 使用事件驱动模型实现高效稳定的网络服务器程序
- C++ Fibonacci数列