sql server监控
发布时间:2020-05-23 15:34:01 所属栏目:MySql 来源:互联网
导读:sql server监控http://www.mssqltips.com/sqlservertip/2522/sql-server-monitoring-checklist/1.查看sql server 服务运行状态:http://msdn.microsoft.com/zh-cn/library/ms189089%28v=sql.105%29.aspxexec master.dbo.xp_servicecontrol QUERYSTATE, MSSQLS
sql server监控 http://www.mssqltips.com/sqlservertip/2522/sql-server-monitoring-checklist/ 1.查看sql server 服务运行状态: http://msdn.microsoft.com/zh-cn/library/ms189089%28v=sql.105%29.aspx master.dbo.xp_servicecontrol , master.dbo.xp_servicecontrol , master.dbo.xp_servicecontrol ,2.查看sql server agent 工作执行情况: Status,(sj.name ()) (sjs.step_id ()) (sjs.step_name ()) (((,(,(,sjh.run_date)),),,) (((,sjh.run_time),),,)(((,,,) ()) sj.job_id sj.job_id sjh.job_id sjs.step_id sjh.run_status (sjh.run_date )sjh.run_time (((),(),) ) , sj.job_id sjh.run_status sjh.step_id (sjh.run_date )sjh.run_time (((),) )3.查询数据库备份情况: d.name "((,b.backupdate,),) "Last ( database_name,type,(backup_finish_date) backupdate type database_name,type) b d.name (backupdate backupdate () d.name ") "Last ( database_name,(backup_finish_date) backupdate type database_name,type) b d.name recovery_model (backupdate backupdate ())4.查看sql server 错误日志情况: () #ErrorLog (logdate (( master.dbo.xp_readerrorlog ,,,,N LogDate,Message (Message Message ) processinfo logdate #ErrorLog5.查看磁盘剩余空间: ( ( (,) ( xp_cmdshell (((line,(,line) ))) (((((line,line)(,line) )(,line)) )) ),) (,((,line) )(,) line (((line,line)) )) ),) ) ,) line #output6.sql server内存使用情况: available_physical_memory_kb (total_physical_memory_kb) " sys.dm_os_sys_memory7.sql 执行消耗情况(IO vs. CPU vs. Elapsed Time): total_physical_readstotal_logical_writes)execution_count execution_count) execution_count) "Execution "Query total_elapsed_timeexecution_count8.数据库连接情况: p.dbidd.database_id9.正在处理的请求数: counter_name DELAY (cntr_value) "Batch Requests counter_name9. (编辑:安卓应用网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |