Event

Available in Classic

You can check the history of events that have occurred on the Cloud DB for MSSQL server in Event. The events that occur in MSSQL are saved automatically in the history and stored permanently without requiring additional settings by the user. If you create events by setting notification items and thresholds for each MSSQL server, then you can emails and SMS notifications when the events occur.

Event page

The basics of using the event are as follows.

Check events

The following describes how to check the events that occurred in an MSSQL server.

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for MSSQL.
2. Click the Event menu.
3. When the event list appears, check the required information.
   • DB service name: Name of the MSSQL Service where the event occurred
   • DB Server name: Name of the MSSQL server where the event occurred
   • Event occurrence time: time when the event occurred
   • Event type: type of the event that occurred
     • MSSQL Server: Events that have occurred in the DB server
   • Event name: name of the event that occurred
     • Backup: backup start
     • Restore: restoration start
     • Mirroring: configure mirroring (HA)
     • Failover: failover occurrence
       • When a failure occurred in the principal server and triggered a failover
       • When the user restarted the server with the failover option
     • Account: DB account creation
     • AgentJob: new SqlAgentJob created
       • When the user created a new batch job
       • When its newly created on a new server due to specification adjustment, etc.
     • Restart: restart DB server
     • LogShipping: LogShipping start
     • Config: backup settings
     • Upgrade: upgrade the database engine
   • Content: description of the event that occurred
   • Access IP: access IP address of the admin account where the event occurred
4. If the event type is MSSQL server, then click it to see the details.
   
   • DB service name: service name of the MSSQL server
   • DB status: status of the MSSQL server in operation
   • DB Role: the role of the MSSQL server in operation
   • Creation date: date that MSSQL server in operation was created

Event rule settings (Cloud Insight)

If you use Cloud Insight, NAVER Cloud Platform's specialized service for monitoring, then you can set more detailed event rules for MSSQL servers and monitor them. The events collected by the rules set by the user can be checked from the Cloud Insight dashboard.

For information on setting event rules for MSSQL servers, checking them on the dashboard, and setting event rule notifications by MSSQL server in Cloud Insight, see Cloud Insight User Guide.