Monitoring
- Print
- PDF
Monitoring
- Print
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
The latest service changes have not yet been reflected in this content. We will update the content as soon as possible. Please refer to the Korean version for information on the latest updates.
Available in Classic
Monitoring supports three types of dashboards for you to check various monitoring information on MSSQL server performance and history. Monitoring is a service included in NAVER Cloud Platform's Cloud DB for MSSQL, so it can be used without additional charges. The types of dashboards provided by Monitoring are as follows:
- DB dashboard: monitoring information related to MSSQL servers in operation
- Performance: monitoring information related to performance of MSSQL servers in operation
- DB logs: records occurrence time and content of all logs that occur from MSSQL servers in operation
Through these three 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 is configured with various graphic charts. You can utilize these charts in your business by printing specific graphic charts or downloading them to your local PC as files using various extensions.
Note
You can set the user to be notified when monitoring results show that a certain indicator has exceeded its threshold or met specific conditions by having them recognized as events. For detailed usage methods for event and notification settings, see Event.
Since the intuitive search and management for the MSSQL performance information is available without additional charges, if you wish to operate servers stably in an environment without a professional database manager, then we recommend utilizing the monitoring indicators provided through the dashboard.
Monitoring page
The basics of using monitoring are as follows:
| Area | Description |
|---|---|
| ① Menu name | Name of the menu currently being viewed |
| ② Basic features | Check details for Cloud DB for MSSQL, refresh the Monitoring page. |
| ③ DB service list | The list of DB services in operation and the list of MSSQL servers by service |
| ④ Dashboard | DB dashboard, performance, and DB logs of the selected server from the MSSQL server list |
View monitoring dashboards
The dashboards provided by monitoring consist of multiple graphic 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. The following describes how to use dashboards:
- From the Classic environment of NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus, in that order.
- 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 page on the right.
- 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 graphic chart: mouse-over to the specific point on the graphic chart
- If you want to see the detailed graph: double-click on the graphic chart
- Print graphic chart: click
, and then click the Print chart menu. - Download a graphic chart to your local PC as a file: click , and then click the file extension menu for the file you want to download.
- Download PNG image: image file with the .png extension
- Download JPEG image: image file with the .jpeg extension
- Download PDF document: document file with the .pdf extension
- Download SVG vector image: vector image file with the .svg extension
, and then click the Print chart menu.Caution
The default value is Recent 1H in Step 5, while up to 1 year can be selected for dashboard and performance, and up to 28 days for DB logs.
Note
From the Services > Database > Cloud DB for MSSQL > DB server menu, click and select the server you want, and then click the [Monitoring] button to go directly to the page in Step 4.
DB dashboard graphic charts
The following are some descriptions for the graphic charts configured in DB dashboard:
| Graphic 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 |
| 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 one minute y: Sum(sum_d(delta)_total_worker_time): CPU time consumed by the query during one minute (us) Bubble size: total_logical_reads: number of page reads (8 KB) during one 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 in the bottom. |
Performance graphic charts
In the existing page, click the [Set items] button, and select the graphic chart to be monitored.
In the new page, select the desired graphic chart from the dropdown list.
You can select up to 10 graphic charts.
The following is the descriptions for the graphic charts in Performance:
| Graphic 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 |
| disk read latency | sec | Average time for data read from disk |
| disk Queue length | avg. disk queue length | Average number of read and write requests waiting on queue for the selected disk during the sample interval |
| 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 packet | packets/sec | The speed at which packets are sent and received in a network interface |
| 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 loockup | page lookups/sec | Number of requests to find a page in the buffer pool |
| DB buffer writes | page writes/sec | Number of actual database page writes that are executed |
| db lock wait | ms | Total wait time for locks in the last second |
| sql re-compile | sql re-compilations/sec | The number of re-compilations triggered per second |
| availableMemory | MB | The actual memory capacity available immediately to be assigned to a process or used by the system |
| CPU Privilege | privileged time(%) | A figure displayed in percentage of the time elapsed during a process thread which executed a command in privileged mode. (A metric with low effects in determining the DB performance, which is going to be excluded when the modules will be replaced with new monitoring modules) |
| Context Switches | context switches/sec | The combined speed at which all the processors of a computer switches from one thread to another |
| disk write latency | sec | Average time for writing data on disk |
| disk read mbyte | bytes/sec | The speed at which bytes are sent from disk during a read task |
| disk free megabytes | MB | The space not assigned to a disk drive (A metric with low effects in determining the DB performance, which is going to be excluded when the modules will be replaced with new monitoring modules) |
| network out | bytes/sec | The speed at which bytes are sent through each network adapter, including frame characters |
| DB lazy write | lazy writes/sec | Number of buffers recorded by the buffer manager's lazy writer |
| 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 |
| DB buffer reads | page reads/sec | Number of actual database page reads that are executed |
| db latch wait | ms | Total latch wait time for latch requests that need to be waiting in the last second |
| sql compile | sql compilations/sec | Number of compilations run by SQL server per second |
| connections | connection count | Number of users connected using SQL server |
DB logs graphic charts
The following are the descriptions for the graphic charts configured in DB logs:
| Field | Description |
|---|---|
| Event occurrence time | Time when DB log occurred |
| Log content | DB log content |
Note
In DB logs, you can check the error log of the MSSQL server in operation.
Was this article helpful?