Database monitoring in MS SQL Server

Monitoring refers to checking the database status (database), setting the owner name, file name, file size, backup schedule .

Database monitoring on SQL Server can be done primarily through SQL Server Management Studio or T-SQL, and can also be controlled in other ways such as 3rd party tools, creating Job in Server Agent .

You can check the status of the database as being connected (Online) as shown in the image below or in another state (Offiline) as shown in the image below.

Database monitoring in MS SQL Server Picture 1
The database is in connection state

Database monitoring in MS SQL Server Picture 2
TestDB is currently Offline

Previous article: How to decentralize users in MS SQL Server

Next lesson: How to start and stop services in MS SQL Server

Jessica Tanner

Update 25 May 2019

You should read it

May be interested

How to create users in MS SQL Server
the user here is an account on ms sql server to access the database (database).
How to recover the database in MS SQL Server
simply put, this is the process of retrieving the backup file and returning it to the database.
How to create a copy of data in MS SQL Server
this is the guide to create backup for database in ms sql server.
How to delete the database in MS SQL Server
to delete the database in ms sql server, we use the drop command.
How to choose a database in MS SQL Server
you can select the database to manipulate in one of the ways below.
How to create a database in MS SQL Server
ways to create user databases on ms sql server.