Ms Sql Server 简明教程
MS SQL Server - Monitor Database
监控指检查数据库状态、设置,这些可以是所有者的名称、文件名、文件大小、备份计划等。
Monitoring refers to checking database status, settings which can be the owner’s name, file names, file sizes, backup schedules, etc.
SQL Server 数据库主要可以通过 SQL Server Management Studio 或 T-SQL 监控,也可以通过创建代理作业和配置数据库邮件、第三方工具等各种方法进行监控。
SQL Server databases can be monitored mainly through SQL Server Management Studio or T-SQL, and also can be monitored through various methods like creating agent jobs and configuring database mail, third party tools, etc.
可以检查数据库的状态,即它是否在线或处于任何其他状态,如下面的截图所示。
Database status can be checked whether it is online or in any other state as shown in the following snapshot.
根据上面的屏幕,所有数据库都在“在线”状态。如果任何数据库处于任何其他状态,则该状态将显示出来,如下面的截图所示。
As per the above screen, all databases are in 'Online' status. If any database is in any other state, then that state will be shown as shown in the following snapshot.