Event

Available in VPC

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:

View events

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

1. On the VPC environment of NAVER Cloud Platform console, click Services > Database > Cloud DB for MSSQL in order.
2. Click Event.
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: recovery start
     • Mirroring: configure mirroring (HA)
     • Failover: Failover occurrence
       • When a failure occurred in the principal server and triggered a Failover
     • 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: start LogShipping
     • 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 rules and notice (notification) settings

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.

Disk Free notification setting guide

You can detect the Disk Full in the MSSQL Server in advance through the Event Rule setting. The following describes how to set Event Rule:

1. On NAVER Cloud Platform console, click Services > Management & Governance > Cloud Insight (Monitoring) > Configuration > Event Rule in order.

2. Click [Create Event Rule].
   

3. Select Cloud DB for MSSQL and click [Next].
   

4. Select the resources that need to set up an event from groups or all resources you have, and click [Next].
   

5. Select the disk_free metric in the full view, and set the criteria such as levels, conditions, aggregation method, and duration. The unit of measure is MB. after setting the conditions, click [Next].
   

6. In the Send notification message, specify the notification recipients, set the notification, and click [Next].
   

7. Provide an Event rule name and description. Check the settings and click [Create] to complete the event registration.
   

8. When an event is detected, notification is sent to the target registered in the notification recipients. For detailed setup instructions, see Even Rule user guide.