--计划缓存中存储过程的逻辑写排名 (SQL 2008 and 2008 R2 适用) ,主要是读操作的压力,并且在内存中 SELECT p.name AS [SP Name] , qs.total_logical_reads AS [TotalLogicalReads] , qs.total_logical_writes AS [TotalLogicalWrites] , qs.execution_count , qs.cached_time FROM sys.procedures AS p INNER JOIN sys.dm_exec_procedure_stats AS qs ON p.[object_id] = qs.[object_id] WHERE qs.database_id = DB_ID() AND qs.total_logical_reads > 0 ORDER BY qs.total_logical_reads DESC;
--计划缓存中存储过程的逻辑写排名 (SQL 2008 and 2008 R2 适用) ,主要是读操作的压力,并且在内存中 SELECT p.name AS [SP Name] , qs.total_logical_reads AS [TotalLogicalReads] , qs.total_logical_writes AS [TotalLogicalWrites] , qs.execution_count , qs.cached_time FROM sys.procedures AS p INNER JOIN sys.dm_exec_procedure_stats AS qs ON p.[object_id] = qs.[object_id] WHERE qs.database_id = DB_ID() AND qs.total_logical_reads > 0 ORDER BY qs.total_logical_reads DESC;版主 别骂我,我刚试了好久 不知道你这句话怎么用 我把这段代码加进一个存储过程里面,不会显示,我想想只好不耻下问了!
--计划缓存中存储过程的逻辑写排名 (SQL 2008 and 2008 R2 适用) ,主要是读操作的压力,并且在内存中 SELECT p.name AS [SP Name] , qs.total_logical_reads AS [TotalLogicalReads] , qs.total_logical_writes AS [TotalLogicalWrites] , qs.execution_count , qs.cached_time FROM sys.procedures AS p INNER JOIN sys.dm_exec_procedure_stats AS qs ON p.[object_id] = qs.[object_id] WHERE qs.database_id = DB_ID() AND qs.total_logical_reads > 0 ORDER BY qs.total_logical_reads DESC;版主 别骂我,我刚试了好久 不知道你这句话怎么用 我把这段代码加进一个存储过程里面,不会显示,我想想只好不耻下问了!就是一个存储过程名称,总的逻辑读,总的逻辑写,执行次数,缓存的时间等信息
版主大神8:00上班~鉴定完毕!
关于级联大神可否给些详细的资料。我10点上班,起来看书而已。英语好的话http://www.it-ebooks.info/这里一堆
版主大神8:00上班~鉴定完毕!
关于级联大神可否给些详细的资料。我10点上班,起来看书而已。英语好的话http://www.it-ebooks.info/这里一堆
版主大神8:00上班~鉴定完毕!
关于级联大神可否给些详细的资料。我10点上班,起来看书而已。英语好的话http://www.it-ebooks.info/这里一堆版主太勤奋了,向版主学习
是的 被版主识破了。 可能是我没有完全理解老师的意图, CHECK 约束能实现什么 网上很容易就能查到, 难就难在如何让CHECK 约束 实现 级联和触发器做的事情,我很无语啊 这是什么天才的脑子能想出来的触发器去做级联删除更新的 都很容易做到!
触发器 logical reads =212SET STATISTICS IO ON 对了 这个只能统计逻辑读,有没有办法统计逻辑写的?
SELECT p.name AS [SP Name] ,
qs.total_logical_reads AS [TotalLogicalReads] ,
qs.total_logical_writes AS [TotalLogicalWrites] ,
qs.execution_count ,
qs.cached_time
FROM sys.procedures AS p
INNER JOIN sys.dm_exec_procedure_stats AS qs ON p.[object_id] = qs.[object_id]
WHERE qs.database_id = DB_ID()
AND qs.total_logical_reads > 0
ORDER BY qs.total_logical_reads DESC;
SELECT p.name AS [SP Name] ,
qs.total_logical_reads AS [TotalLogicalReads] ,
qs.total_logical_writes AS [TotalLogicalWrites] ,
qs.execution_count ,
qs.cached_time
FROM sys.procedures AS p
INNER JOIN sys.dm_exec_procedure_stats AS qs ON p.[object_id] = qs.[object_id]
WHERE qs.database_id = DB_ID()
AND qs.total_logical_reads > 0
ORDER BY qs.total_logical_reads DESC;版主 别骂我,我刚试了好久 不知道你这句话怎么用 我把这段代码加进一个存储过程里面,不会显示,我想想只好不耻下问了!
SELECT p.name AS [SP Name] ,
qs.total_logical_reads AS [TotalLogicalReads] ,
qs.total_logical_writes AS [TotalLogicalWrites] ,
qs.execution_count ,
qs.cached_time
FROM sys.procedures AS p
INNER JOIN sys.dm_exec_procedure_stats AS qs ON p.[object_id] = qs.[object_id]
WHERE qs.database_id = DB_ID()
AND qs.total_logical_reads > 0
ORDER BY qs.total_logical_reads DESC;版主 别骂我,我刚试了好久 不知道你这句话怎么用 我把这段代码加进一个存储过程里面,不会显示,我想想只好不耻下问了!就是一个存储过程名称,总的逻辑读,总的逻辑写,执行次数,缓存的时间等信息
select * from sys.trigger_event_types
select * from sys.trigger_events
select * from sys.triggers