微软对ice服务器事件看法,icechen
适用于05/08:
with tb
as
(
select blocking_session_id,
session_id,db_name(database_id) as dbname,text from
master.sys.dm_exec_requests a
CROSS APPLY master.sys.dm_exec_sql_text(a.sql_handle)
),
tb1 as
(
select
a.*,login_time,program_name,client_interface_name,login_name,cpu_time,memory_usage*8
as memory_usage(KB),
total_scheduled_time,reads,writes,logical_reads
from tb a inner join master.sys.dm_exec_sessions b
on a.session_id=b.session_id
)
select a.*,connect_time,client_tcp_port,client_net_address from tb1
a inner join master.sys.dm_exec_connections b on
a.session_id=b.session_id
适用于2000/05/08:
查看具体进程对应的东西：
dbcc inputbuffer(进程号) --这个只能显示事件的前 4000 个字符
适用于05/08: with tb as ( select blocking_session_id, session_id,db_name(database_id) as dbname,text from master.sys.dm_exec_requests a CROSS APPLY master.sys.dm_exec_sql_text(a.sql_handle) ), tb1 as ( select a.*,login_time,program_name,client_interface_name,login_name,cpu_time,memory_usage*8 as memory_usage(KB), total_scheduled_time,reads,writes,logical_reads from tb a inner join master.sys.dm_exec_sessions b on a.session_id=b.session_id ) select a.*,connect_time,client_tcp_port,client_net_address from tb1 a inner join master.sys.dm_exec_connections b on a.session_id=b.session_id 适用于2000/05/08: 查看具体进程对应的东西： dbcc inputbuffer(进程号) --这个只能显示事件的前 4000 个字符