--获取磁盘读写情况 select @@total_read as '读取磁盘的次数', @@total_write as '写入磁盘的次数', @@total_error as '磁盘写入错误数', getdate() as '当前时间'
--查看SQL SEVER CPU活动,工作情况 select @@cpu_busy,--自上次启动以来的工作时间 @@timeticks, --每个时钟周期对应的微秒数 @@cpu_busy*cast(@@timeticks as float)/1000 as 'cpu工作时间(秒)', @@idie*cast(@@timeticks as float)/1000 as 'CPU空闲时间(秒)' getdate() as '当前时间'
select
@@total_read as '读取磁盘的次数',
@@total_write as '写入磁盘的次数',
@@total_error as '磁盘写入错误数',
getdate() as '当前时间'
select
@@cpu_busy,--自上次启动以来的工作时间
@@timeticks, --每个时钟周期对应的微秒数
@@cpu_busy*cast(@@timeticks as float)/1000 as 'cpu工作时间(秒)',
@@idie*cast(@@timeticks as float)/1000 as 'CPU空闲时间(秒)'
getdate() as '当前时间'