Available in VPC
Monitoring supports 5 types of dashboards for you to check various kinds of monitoring information on MSSQL Server performance and history. Monitoring is included in NAVER Cloud Platform's Cloud DB for MSSQL and is a free service. Monitoring provides the following dashboards:
- DB Dashboard: Monitoring information related to the MSSQL Server in operation
- Query performance: Query monitoring information for the MSSQL Server in operation
- Performance: Performance‑related monitoring information for the MSSQL Server in operation
- DB logs: Timestamps and details of all logs generated by running MSSQL Servers
- Audit Logs: Timestamps and details of all audit logs generated by running MSSQL Servers
Through these 5 types of dashboard, you can check the average value of performance of the MSSQL Server in the last year as well as the log information for the last 28 days. Each dashboard consists of multiple graph charts. You can print specific charts or download them to your local PC in various extensions for effective use.
You can set the user to be notified when monitoring results show that a certain metric has exceeded its threshold or met specific conditions by having them recognized as events. For more information on the detailed usage for event and notification settings, see Event.
Because intuitive search and management for the MSSQL performance information is available without additional charges, we recommend utilizing the monitoring metrics provided through the dashboard for stable server operations, particularly in environments without professional database managers.
Monitoring interface
The basics of using Monitoring are as follows:
| Component | Description |
|---|---|
| ① Menu name | The name of the current menu. |
| ② Basic features | Check details for Cloud DB for MSSQL, refresh the Monitoring interface. |
| ③ DB service list | List of DB services in operation and list of MSSQL Server by service. |
| ④ Dashboard | DB Dashboard, Query Performance, performance, DB logs, and audit logs of the selected server from the MSSQL Server list. |
View Monitoring dashboards
Dashboards provided by Monitoring consist of multiple graph charts. You can display and intuitively check only the information you need from the dashboard of each server. The information shown in the dashboard is collected every minute to be displayed, but it shows only the average values. To use dashboards:
- In the VPC environment of the NAVER Cloud Platform console, navigate to Menu > All services > Database > Cloud DB for MSSQL.
- Click the Monitoring menu.
- Click the MSSQL Server to be monitored from the list of DB services.
- Click the button for the dashboard you want to check from the interface on the right.
- Click and select all graph charts you want to display and check on the dashboard in case of Performance.
- From the period selection box, click and select the period you want to search, or enter it directly.
- Check the results from the dashboard.
- If you want to see the precise indicator value of a specific point on the graph chart: Hover over a specific point on the graph chart.
- To view a detailed graph: Double-click the graph chart.
- Print a graph chart: Select
, then click Print chart. - Download a graph chart to your local PC: Select , then click the file extension menu to download.
- Download PNG image: An image file with a PNG extension.
- Download JPEG image: An image file with a JPEG extension.
- Download PDF document: A document file with a PDF extension.
- Download SVG vector image: A vector image file with an SVG extension.
- Step 6, the default is the last 1 hour.
- The period in step 6 can be selected to be up to 1 year for dashboard and performance, up to 7 days for query performance, and up to 28 days for DB logs.
Navigate to Menu > All services > Database > Cloud DB for MSSQL > DB Server, select the desired server, and click [Monitoring] to go directly to the interface in Step 4.
DB Dashboard graph charts
The following are some descriptions for the graph charts configured in DB Dashboard:
| Graph chart | Unit | Description |
|---|---|---|
| CPU Used | processor time(%) | A figure of percentage indicating the elapsed time that the processor spends executing non-idle threads |
| Execute Queries Count | batch requests/sec | Number of SQL batch requests received from the server |
Query performance graph charts
The following are the descriptions for the graph charts in query performance:
| Graph chart | Unit | Description |
|---|---|---|
| CPU consumption and number of memory reads compared to the number of query executions | x: Sum(sum+d(delta)_execution_count): Number of query requests during 1 minute y: Sum(sum_d(delta)_total_worker_time): CPU time consumed by the query during 1 minute (us) Bubble size: total_logical_reads: Number of pages (8 KB) read per minute |
Tuning is required for queries with high CPU consumption (y) or memory reads (bubble size) compared to the number of query executions (x) Click the bubble to see which query it represents at the bottom |
Performance graph charts
The following are the descriptions for the graph charts in performance:
| Graph chart | Unit | Description |
|---|---|---|
| CPU used | processor time(%) | A figure of percentage indicating the elapsed time that the processor spends executing non-idle threads |
| CPU Queue length | processor queue length | Number of threads in a processor queue |
| Context Switches | Context Switches/sec | The total number of times all processors in a computer switch from one thread to another. |
| disk read latency | sec | Speed at which bytes are sent from disk during a read task |
| disk write latency | sec | Average time for writing data on disk |
| disk Queue Length | count | Average number of read and write requests waiting in the queue for the selected disk |
| disk read mbyte | bytes/sec | Speed at which bytes are sent to the disk during a read task |
| disk write mbyte | bytes/sec | The speed at which bytes are sent to disk during a write task |
| network in | bytes/sec | The speed at which bytes are received through each network adapter, including frame characters |
| network out | bytes/sec | Speed at which bytes are sent through each network adapter, including frame characters |
| network packet | packets/sec | The speed at which packets are sent and received in a network interface |
| DB lazy write | lazy writes/sec | Number of buffers recorded by the buffer manager's lazy writer |
| Free Memory | KB | Memory capacity not in use by server |
| Memory Grants Pending | memory grants pending | Number of current processes waiting to be granted workspace memory |
| DB buffer lookup | page lookups/sec | Number of requests to find a page in the buffer pool |
| DB buffer reads | page reads/sec | Number of actual database page reads executed |
| DB buffer writes | page writes/sec | Number of actual database page writes executed |
| db latch wait | ms | Total latch wait time for latch requests that need to be waiting at the last second |
| db lock wait | ms | Total wait time for locks in the last second |
| sql compile | sql compilations/sec | Number of compilations run by the SQL server per second |
| sql re-compile | sql re-compilations/sec | Number of re-compilations triggered per second |
| Page Life Expectancy | sec | Time a page will stay in the buffer pool without references |
| execute queries count | batch requests/sec | Number of SQL batch requests received from the server |
| availableMemory | MB | Actual memory capacity available immediately to be assigned to a process or used by the system |
| connections | connection count | Number of users connected using SQL Server |
DB logs graph charts
The following are the descriptions for the graph charts configured in DB logs:
| Field | Description |
|---|---|
| Event time | Time when the DB log occurred. |
| Log content | DB log details. |
In DB logs, you can check the error log of the MSSQL Server in operation.
Audit logs graph charts
The following are the descriptions for the graph charts configured in audit logs:
| Field | Description |
|---|---|
| Event time | Time when the event occurred |
| Log content | Audit Log content. |
You can download the audit log from DB Server > DB status > Download log. The downloaded file can be further analyzed from SSMS > File > Open > Merge extended event files.