Monitoring
    • PDF

    Monitoring

    • PDF

    Article Summary

    Available in VPC

    Monitoring supports four types of dashboards, allowing you to check various monitoring information about 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 the MSSQL server in operation
    • Performance: monitoring information related to performance of the MSSQL server in operation
    • DB logs: records occurrence time and content of all logs that occur from the MSSQL server in operation
    • Audit Logs: records occurrence time and content of Audit logs that occur from the MSSQL server in operation

    Through these four 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 in 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 about 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, utilize the monitoring indicators provided through the dashboard.

    Monitoring page

    The basics of using monitoring are as follows:

    clouddbformssql-monitoring-main

    FieldDescription
    ① Menu nameName of the menu currently being viewed
    ② Basic featuresCheck details for Cloud DB for MSSQL, refresh the Monitoring page
    ③ DB service listThe list of DB services in operation and the list of MSSQL servers by service
    ④ DashboardDB 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 the dashboards.

    1. From the VPC environment of the NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus, in that order.

    2. Click the Monitoring menu.

    3. Click the MSSQL server from the list of DB services.

    4. Click the button for the dashboard you want to check from the page on the right.

    5. Click and select all graphic charts you want to display and check on the dashboard in case of Performance.

    6. From the Period selection box, click and select the period you want to search, or enter it directly.

    7. 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 with the mouse on the graphic chart.
      • Print graphic chart: click clouddbforredis_ico-03_vpc_ko.png, and then click the Print chart menu.
      • Download a graphic chart to your local PC as a file: click clouddbforredis_ico-03_vpc_ko.png, 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
    Caution
    • In Step 5, the default value is Select all, and in Step 6, the default value is Recent 1H.
    • The period in Step 6 can be selected to be up to 1 year for dashboard and performance, and up to 28 days for DB logs.
    Note

    Click the server you want in the Services > Database > Cloud DB for MSSQL > DB Server menus. Clicking the [Monitoring] button will direct you 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 chartUnitDescription
    CPU Usedprocessor time(%)A figure of percentage indicating the elapsed time that the processor spends executing non-idle threads
    Execute Queries Countbatch requests/secNumber of SQL batch requests received from the server
    CPU consumption and number of memory reads compared to the number of query executionsx: 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 in 1 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 bubble to see which query it is at the bottom

    Performance graphic chart

    The following is the descriptions for the graphic charts in Performance.

    clouddbformssql-monitoring_performanceCharts_vpc_ko

    Graphic chartUnitDescription
    CPU usedprocessor time(%)A figure of percentage indicating the elapsed time that the processor spends executing non-idle threads
    disk read latencysecAverage time for data read from disk
    disk write latencysecAverage time for writing data on disk
    Page Life ExpectancysecTime a page will stay in the buffer pool without references
    execute queries countbatch requests/secNumber of SQL batch requests received from the server
    connectionsconnection countNumber of users connected using SQL server

    DB logs graphic charts

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

    clouddbformssql-monitoring_dbLogsCharts_vpc_ko

    FieldDescription
    Event occurrence timeTime when DB log occurred
    Log contentDB log content
    Note

    In DB logs, you can check the error log of the MSSQL server in operation.

    Audit logs graphic charts

    The following are the descriptions for the graphic charts configured in Audit Logs.
    clouddbformssql_monitoring_audit_log_graphchart

    FieldDescription
    Event occurrence timeTime when the event occurred
    Log contentContent audit log
    Note

    You can download the audit log from DB Server > DB Status > Download Log. The downloaded file can be further analyzed from the SSMS > File > Open > Merge Extended Event Files menu.


    Was this article helpful?

    What's Next
    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.