Monitoring

Prev Next

Available in Classic

Monitoring supports three types of dashboards for you to check various kinds of 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 the performance of MSSQL servers in operation
  • DB logs: records the occurrence time and content of all logs that occur from the 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 more information on the detailed use methods for event and notification settings, see Event.

Because intuitive search and management for the MSSQL performance information are 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:

clouddbformssql-monitoring_main_vpc_ko

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 List of DB services in operation and 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

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. To use dashboards, follow these steps:

  1. In the Classic environment of the NAVER Cloud Platform console, navigate to i_menu > Services > Database > Cloud DB for MSSQL.
  2. Click the Monitoring menu.
  3. Click the MSSQL server to be monitored from the list of DB services.
  4. Click the button for the dashboard you want to check from the page on the right.
  5. From the Period selection box, click and select the period you want to search, or enter it directly.
  6. Check the results from the dashboard.
    • To see the precise indicator value of a specific point on the graphic chart: mouse over to the specific point on the graphic chart
    • To see the detailed graph: double-click the graphic chart
    • Print graphic chart: click clouddbforpostgresql-monitoring_ico-03, followed by the Print chart menu
    • Download a graphic chart to your local PC as a file: click clouddbforpostgresql-monitoring_ico-03, followed by 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
Caution

The default value is the recent 1 hour 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 i_menu > Services > Database > Cloud DB for MSSQL > DB Server , click and select the server you want, followed by the [Monitoring] button to go directly to the page in Step 4.

DB dashboard graphic charts

The following are the descriptions for the graphic charts configured in DB dashboard:

clouddbformssql-monitoring_dbDashboardCharts_vpc_ko

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 at the bottom

Performance graphic charts

Select the desired graphic chart from the dropdown list.
You can select up to 10 graphic charts.
The following are 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 executed
db lock wait ms Total wait time for locks in the last second
sql re-compile sql re-compilations/sec Number of re-compilations triggered per second
availableMemory MB Actual memory capacity available immediately to be assigned to a process or used by the system
Context Switches context switches/sec Combined speed at which all the processors of a computer switch from one thread to another
disk write latency sec Average time for writing data on disk
disk read mbyte bytes/sec Speed at which bytes are sent from disk during a read task
network out bytes/sec 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 executed
db latch wait ms Total latch wait time for latch requests that need to be waiting at the last second
sql compile sql compilations/sec Number of compilations run by the SQL server per second
connections connection count Number of users connected using the SQL server

DB logs graphic charts

The following are the descriptions for the graphic charts configured in DB logs:

clouddbformssql-monitoring_dbLogsCharts_vpc_ko

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.