27,579
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
playyuer 2004-03-30
- 打赏
- 举报
up
Ouyangyifeiczy 2004-03-30
- 打赏
- 举报
不知SP_MONITOR够不够用.
在客户端执行服务器端SP_MONITOR,显示返回的多结果集.
在客户端执行服务器端SP_MONITOR,显示返回的多结果集.
chushicheng 2004-03-30
- 打赏
- 举报
UP
playyuer 2004-03-29
- 打赏
- 举报
在远程 MSSQL Server ,DataBase: Master 上创建如下视图:
create view v_busy
as
select @@SERVERNAME as SERVERNAME
,@@CPU_BUSY as CPU_BUSY
,@@IO_BUSY as IO_BUSY
,@@IDLE as IDLE
在本地 MSSQL Server 执行:
SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=远程MsSQLServerName;User ID=sa;Password=xxxx'
).master.dbo.v_busy
create view v_busy
as
select @@SERVERNAME as SERVERNAME
,@@CPU_BUSY as CPU_BUSY
,@@IO_BUSY as IO_BUSY
,@@IDLE as IDLE
在本地 MSSQL Server 执行:
SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=远程MsSQLServerName;User ID=sa;Password=xxxx'
).master.dbo.v_busy
