Queries. The top 5 most time-consuming queries are displayed with a graph, giving you an immediate place to observe the potential problems. You can click o refresh and update the top 5 queries list. • TOP 5 QUERIES BASED ON TOTAL TIME - The query statement. • COUNTS - The number of times that the query has been executed. • TOTAL TIME - The cumulative execution time for all executions of the query. • USER@HOST - The user who executed the query. Query Table The query table provides the summary information for all of the queries executed. Occurrence statistics are calculated and the result is displayed. Hover over a query to show the full query statement and click Copy Query to copy it. If your instance is PostgreSQL, you can also click Create New Trace in SQL Profiler to create a new trace using that query. Click SHOW / HIDE COLUMNS and select the columns that you want to hide. Select Restore Default to restore the table to its default settings. Queries can be filtered and sorted. Simply enter a search string in the Search for a query box to filter the table and click the column name to sort the table. To change the number of queries per page, click X / PAGE and select a predefined number. To change the total number of queries in the table, click TOTAL NO. OF QUERIES and select a predefined number. Long Running Queries About Long Running Queries In the Query Analyzer page, click the Long Running Queries chart. The Long Running Queries page uses historical data to help you identify long running queries that are consuming resources and investigate the root cause of performance issues. Data is collected every second and automatically condensed over time. All monitored instances are shown in the left pane. Select an instance to view its Long Running Queries chart. Navicat Monitor provides several additional information about the queries. Click on a tab to show the corresponding chart. The available tabs depend on the server type of the selected instance.
Appears in 2 contracts
Samples: License Agreement, License Agreement
Queries. The top 5 most time-consuming queries are displayed with a graph, giving you an immediate place to observe the potential problems. You can click o refresh and update the top 5 queries list. • TOP 5 QUERIES BASED ON TOTAL TIME - The query statement. • COUNTS - The number of times that the query has been executed. • TOTAL TIME - The cumulative execution time for all executions of the query. • USER@HOST - The user who executed the query. Query Table The query table provides the summary information for all of the queries executed. Occurrence statistics are calculated and the result is displayed. Hover over a query to show the full query statement and click Copy Query to copy it. If your instance is PostgreSQL, you can also click Create New Trace in SQL Profiler to create a new trace using that query. Click SHOW Show / HIDE COLUMNS Hide Columns and select the columns that you want to hide. Select Restore Default to restore the table to its default settings. Queries can be filtered and sorted. Simply enter a search string in the Search for a query box to filter the table and click the column name to sort the table. To change the number of queries per page, click X / PAGE and select a predefined number. To change the total number of queries in the table, click TOTAL NO. OF QUERIES and select a predefined number. Long Running Queries About Long Running Queries In View Deadlocks The Deadlock page displays all deadlocks detected on the Query Analyzer page, click the Long Running Queries chart. The Long Running Queries page uses historical data to help you identify long running queries selected instance that are consuming resources and investigate the root cause of performance issues. Data is collected every second and automatically condensed over timeNavicat Monitor has information about. All monitored instances are shown in the left pane. Select an instance to view show its Long Running Queries chartdeadlocks. By default, the deadlock list refreshes every 5 seconds automatically. If you want to change the auto-refreshing time, use the REFRESH TIME drop-down menu. To pause the auto refresh, click . Deadlocks can be filtered. Simply enter a search string in the Search for a deadlock box to filter the list. To change the number of deadlocks shown per page, click X / PAGE and select a predefined number. View Process List The Process List page displays all processes currently running on the selected instance. You can check which queries are currently being executed. The process list provides the following detailed information. ID - The thread ID. User@Host - The user who issued the statement. DB - The database that the user is currently used. Command - The type of command that the user issued. Time - The time in seconds that the thread has been in its current state. State - The state that indicates what the thread is doing. Info - The statement that the user issued. All monitored instances are shown in the left pane. Select an instance to show its process list. By default, the process list refreshes every 5 seconds automatically. If you want to change the auto-refreshing time, use the REFRESH TIME drop-down menu. To pause the auto refresh, click . The list of threads can be filtered and sorted. Simply enter a search string in the Search for a thread box to filter the list and click the column name to sort the list. To change the number of threads shown per page, click X / PAGE and select a predefined number. End Process You may find slow or long running queries use lots of available CPU and memory resources and may block other valid queries. To stop a thread instantly, click in the Action column, and then click End Process in the pop-up dialog. Chapter 7 - Replications Monitored Replications The Monitored Replications page displays all information related to monitored replication. You can monitor the health of replication, diagnose replication issues and ensure the replication works seamlessly. Navicat Monitor provides several additional detailed information about on status, configuration and performance of slaves. Navicat Monitor supports 2 replication views: Diagram View and List View. To switch the queriesview, click or . Click If you want to view the detailed information of a replication, click on a tab slave to show the corresponding chart. The available tabs depend on the server type of the selected instanceredirect to its details page.
Appears in 1 contract
Samples: License Agreement
Queries. The top 5 most time-consuming queries are displayed with a graph, giving you an immediate place to observe the potential problems. You can click o refresh and update the top 5 queries list. • TOP 5 QUERIES BASED ON TOTAL TIME - The query statement. • COUNTS - The number of times that the query has been executed. • TOTAL TIME - The cumulative execution time for all executions of the query. • USER@HOST - The user who executed the query. Query Table The query table provides the summary information for all of the queries executed. Occurrence statistics are calculated and the result is displayed. Hover over a query to show the full query statement and click Copy Query to copy it. If your instance is PostgreSQL, you can also click Create New Trace in SQL Profiler to create a new trace using that query. Click SHOW / HIDE COLUMNS and select the columns that you want to hide. Select Restore Default to restore the table to its default settings. Queries can be filtered and sorted. Simply enter a search string in the Search for a query box to filter the table and click the column name to sort the table. To change the number of queries per page, click X / PAGE and select a predefined number. To change the total number of queries in the table, click TOTAL NO. OF QUERIES and select a predefined number. Long Running Queries About Long Running Queries In View Deadlocks The Deadlock page displays all deadlocks detected on the Query Analyzer page, click the Long Running Queries chart. The Long Running Queries page uses historical data to help you identify long running queries selected instance that are consuming resources and investigate the root cause of performance issues. Data is collected every second and automatically condensed over timeNavicat Monitor has information about. All monitored instances are shown in the left pane. Select an instance to view show its Long Running Queries chartdeadlocks. By default, the deadlock list refreshes every 5 seconds automatically. If you want to change the auto-refreshing time, use the REFRESH TIME drop-down menu. To pause the auto refresh, click . Deadlocks can be filtered. Simply enter a search string in the Search for a deadlock box to filter the list. To change the number of deadlocks shown per page, click X / PAGE and select a predefined number. View Process List The Process List page displays all processes currently running on the selected instance. You can check which queries are currently being executed. The process list provides the following detailed information. MySQL / MariaDB • ID - The thread ID. • USER@HOST - The user who issued the statement. • DB - The database that the user is currently used. • COMMAND - The type of command that the user issued. • TIME - The time in seconds that the thread has been in its current state. • STATE - The state that indicates what the thread is doing. • INFO - The statement that the user issued. SQL Server • SPID - SQL Server session ID. • LOGIN - Login name. • HOST_NAME - Name of the workstation. • DB - ID of the database currently being used by the process. • COMMAND - Command currently being executed. • LAST_BATCH - Last time a client process executed a remote stored procedure call or an EXECUTE statement. • STATUS - Process ID status. • DISK_IO - Cumulative disk reads and writes for the process. • CPU_TIME - Cumulative CPU time for the process. • BLOCKED_BY - ID of the session that is blocking the request. • REQUEST_ID - ID of request. • PROGRAM_NAME - Name of the application program. All monitored instances are shown in the left pane. Select an instance to show its process list. By default, the process list refreshes every 5 seconds automatically. If you want to change the auto-refreshing time, use the REFRESH TIME drop-down menu. To pause the auto refresh, click . The list of threads can be filtered and sorted. Simply enter a search string in the Search for a thread box to filter the list and click the column name to sort the list. To change the number of threads shown per page, click X / PAGE and select a predefined number. End Process You may find slow or long running queries use lots of available CPU and memory resources and may block other valid queries. To stop a thread instantly, click in the ACTION column, and then click End Process in the pop-up dialog. Chapter 7 - Replications Monitored Replications The Monitored Replications page displays all information related to monitored replication. You can monitor the health of replication, diagnose replication issues and ensure the replication works seamlessly. Navicat Monitor provides several additional detailed information about on status, configuration and performance of slaves. Navicat Monitor supports 2 replication views: Diagram View and List View. To switch the queriesview, click or . If you want to view the detailed information of a replication, click on a slave to redirect to its details page. Hint: Click to set schedule to send report email. Filter Replications Navicat Monitor displays all replication relationship of the monitored instances. To show the replications for a specific server type, check the server type checkbox. Occasionally, you may want to hide healthy replications and focus on the unhealthy replications. You can enable the Hide healthy replications option in Diagram View. MySQL / MariaDB Replications Diagram View This view visually displays the hierarchy and relationship of master servers and their slaves. Hover over a slave to show its I/O thread and SQL thread statuses. The instance blocks and the arrows are color-coded to represent the different states of the replication. • Green block indicates that the server is up (stable). • Red block indicates that the server is down. • Green arrow indicates that the replication is up and the slave is up-to-date with its master. • Red arrow indicates that the replication is down (disconnected) and the slave may be not up-to-date with its master. Hint: Zoom in/out of the graph using the mouse wheel. Click on and drag the graph to move it. List View This view shows all registered master servers and slave servers and illustrates the replication details in a tab table. It groups all master servers with their slaves. Common status information is displayed in columns. Click the arrow to the left of each master name to expand or collapse its slaves status and configuration. The color bar represents different states of the replication slaves: stable (green), disconnected (red). Hover over it to show the corresponding charttime. SQL Server Transactional / Merge Replications Diagram View This view visually displays the hierarchy and relationship of Publishers and their Subscribers. Hover over a Subscriber to show its synchronization status. The available tabs depend on instance blocks are color-coded to represent the different states of the servers. • Green block indicates that the server type is up (stable). • Red block indicates that the server is down. • Green arrow indicates that transactional replication is up and the Subscriber is up-to-date with its master. • Red arrow indicates that transactional replication is down (disconnected) and the Subscriber may be not up-to-date with its master. • Black arrow indicates merge replication. Hint: Zoom in/out of the selected instancegraph using the mouse wheel. Click and drag the graph to move it. List View This view shows all registered Publishers and Subscribers and illustrates the replication details in a table. It groups all Publishers with their Subscribers. Common status information is displayed in columns. Click the arrow to the left of each Publisher name to expand or collapse its Subscriber information. The color bar represents different states of the replication: success / stable (green), fail / disconnected (red). Hover over it to show the time. Export Replications You can export the replication diagram and list as a PDF file. To export the replication, click . Replication Diagram Replication List View Replication Details The Replication Details page displays the detailed replication information for a slave / subscriber you chosen in the Monitored Replication page.
Appears in 1 contract
Samples: License Agreement
Queries. The top 5 most time-consuming queries are displayed with a graph, giving you an immediate place to observe the potential problems. You can click o refresh and update the top 5 queries list. • TOP Top 5 QUERIES BASED ON TOTAL TIME Queries Based on Total Time - The query statement. • COUNTS Count - The number of times that the query has been executed. • TOTAL TIME Total Time - The cumulative execution time for all the executions of the query. • USER@HOST User@Host - The user who executed the query. Query Table The query table provides the summary information for all of the queries executed. Occurrence statistics are calculated and the result is displayed. Hover over a query to show the full query statement and click Copy Query to copy it. If your instance is PostgreSQL, you can also click Create New Trace in SQL Profiler to create a new trace using that query. Click SHOW Show / HIDE COLUMNS Hide Columns and select the columns that you want to hide. Select Restore Default to restore the table to its default settings. Queries can be filtered and sorted. Simply enter a search string in the Search for a query box to filter the table and click the column name to sort the table. To change the number of queries per page, click X / PAGE Rows to Display and select a predefined number. To change the total number of queries in the table, click TOTAL NOTotal no. OF QUERIES of Queries and select a predefined number. Long Running Queries About Long Running Queries In View Deadlocks The Deadlock page displays all deadlocks detected on the Query Analyzer page, click the Long Running Queries chart. The Long Running Queries page uses historical data to help you identify long running queries selected instance that are consuming resources and investigate the root cause of performance issues. Data is collected every second and automatically condensed over timeNavicat Monitor has information about. All monitored instances are shown in the left pane. Select an instance to view show its Long Running Queries chartprocess list. By default, the deadlock list refreshes every 5 seconds automatically. If you want to change the auto-refreshing time, use the Refresh Time drop-down menu. To pause the auto refresh, click . Deadlocks can be filtered. Simply enter a search string in the Search for a deadlock box to filter the list. To change the number of deadlocks shown per page, click Rows to Display and select a predefined number. View Process List The Process List page displays all processes currently running on the selected instance. You can check which queries are currently being executed. The process list provides the following detailed information. ID - The thread ID. User@Host - The user who issued the statement. DB - The database that the user is currently used. Command - The type of command that the user issued. Time - The time in seconds that the thread has been in its current state. State - The state that indicates what the thread is doing. Info - The statement that the user issued. All monitored instances are shown in the left pane. Select an instance to show its process list. By default, the process list refreshes every 5 seconds automatically. If you want to change the auto-refreshing time, use the Refresh Time drop-down menu. To pause the auto refresh, click . The list of threads can be filtered and sorted. Simply enter a search string in the Search for a thread box to filter the list and click the column name to sort the list. To change the number of threads shown per page, click Rows to Display and select a predefined number. End Process You may find slow or long running queries use lots of available CPU and memory resources and may block other valid queries. To stop a thread instantly, click in the Action column, and then click End Process in the pop-up dialog. Chapter 7 - Replications Monitored Replications The Monitored Replications page displays all information related to monitored replication. You can monitor the health of replication, diagnose replication issues and ensure the replication works seamlessly. Navicat Monitor provides several additional detailed information about on status, configuration and performance of slaves. Navicat Monitor supports 2 replication views: Diagram View and List View. To switch the queriesview, click or . Click If you want to view the detailed information of a replication, click on a tab slave to show the corresponding chart. The available tabs depend on the server type of the selected instanceredirect to its details page.
Appears in 1 contract
Samples: License Agreement
Queries. The top 5 most time-consuming queries are displayed with a graph, giving you an immediate place to observe the potential problems. You can click o refresh and update the top 5 queries list. • TOP 5 QUERIES BASED ON TOTAL TIME - The query statement. • COUNTS - The number of times that the query has been executed. • TOTAL TIME - The cumulative execution time for all executions of the query. • USER@HOST - The user who executed the query. Query Table The query table provides the summary information for all of the queries executed. Occurrence statistics are calculated and the result is displayed. Hover over a query to show the full query statement and click Copy Query to copy it. If your instance is PostgreSQL, you can also click Create New Trace in SQL Profiler to create a new trace using that query. Click SHOW / HIDE COLUMNS and select the columns that you want to hide. Select Restore Default to restore the table to its default settings. Queries can be filtered and sorted. Simply enter a search string in the Search for a query box to filter the table and click the column name to sort the table. To change the number of queries per page, click X / PAGE and select a predefined number. To change the total number of queries in the table, click TOTAL NO. OF QUERIES and select a predefined number. Long Running Queries About Long Running Queries In View Deadlocks The Deadlock page displays all deadlocks detected on the Query Analyzer page, click the Long Running Queries chart. The Long Running Queries page uses historical data to help you identify long running queries selected instance that are consuming resources and investigate the root cause of performance issues. Data is collected every second and automatically condensed over timeNavicat Monitor has information about. All monitored instances are shown in the left pane. Select an instance to view show its Long Running Queries chartdeadlocks. By default, the deadlock list refreshes every 5 seconds automatically. If you want to change the auto-refreshing time, use the REFRESH TIME drop-down menu. To pause the auto refresh, click . Deadlocks can be filtered. Simply enter a search string in the Search for a deadlock box to filter the list. To change the number of deadlocks shown per page, click X / PAGE and select a predefined number. View Process List The Process List page displays all processes currently running on the selected instance. You can check which queries are currently being executed. The process list provides the following detailed information. MySQL / MariaDB ID - The thread ID. USER@HOST - The user who issued the statement. DB - The database that the user is currently used. COMMAND - The type of command that the user issued. TIME - The time in seconds that the thread has been in its current state. STATE - The state that indicates what the thread is doing. INFO - The statement that the user issued. SQL Server SPID - SQL Server session ID. LOGIN - Login name. HOST_NAME - Name of the workstation. DB - ID of the database currently being used by the process. COMMAND - Command currently being executed. LAST_BATCH - Last time a client process executed a remote stored procedure call or an EXECUTE statement. STATUS - Process ID status. DISK_IO - Cumulative disk reads and writes for the process. CPU_TIME - Cumulative CPU time for the process. BLOCKED_BY - ID of the session that is blocking the request. REQUEST_ID - ID of request. PROGRAM_NAME - Name of the application program. All monitored instances are shown in the left pane. Select an instance to show its process list. By default, the process list refreshes every 5 seconds automatically. If you want to change the auto-refreshing time, use the REFRESH TIME drop-down menu. To pause the auto refresh, click . The list of threads can be filtered and sorted. Simply enter a search string in the Search for a thread box to filter the list and click the column name to sort the list. To change the number of threads shown per page, click X / PAGE and select a predefined number. End Process You may find slow or long running queries use lots of available CPU and memory resources and may block other valid queries. To stop a thread instantly, click in the ACTION column, and then click End Process in the pop-up dialog. Chapter 7 - Replications Monitored Replications The Monitored Replications page displays all information related to monitored replication. You can monitor the health of replication, diagnose replication issues and ensure the replication works seamlessly. Navicat Monitor provides several additional detailed information about on status, configuration and performance of slaves. Navicat Monitor supports 2 replication views: Diagram View and List View. To switch the queriesview, click or . If you want to view the detailed information of a replication, click on a slave to redirect to its details page. Hint: Click to set schedule to send report email. Filter Replications Navicat Monitor displays all replication relationship of the monitored instances. To show the replications for a specific server type, check the server type checkbox. Occasionally, you may want to hide healthy replications and focus on the unhealthy replications. You can enable the Hide healthy replications option in Diagram View. MySQL / MariaDB Replications Diagram View This view visually displays the hierarchy and relationship of master servers and their slaves. Hover over a slave to show its I/O thread and SQL thread statuses. The instance blocks and the arrows are color-coded to represent the different states of the replication. Green block indicates that the server is up (stable). Red block indicates that the server is down. Green arrow indicates that the replication is up and the slave is up-to-date with its master. Red arrow indicates that the replication is down (disconnected) and the slave may be not up-to-date with its master. Hint: Zoom in/out of the graph using the mouse wheel. Click on and drag the graph to move it. List View This view shows all registered master servers and slave servers and illustrates the replication details in a tab table. It groups all master servers with their slaves. Common status information is displayed in columns. Click the arrow to the left of each master name to expand or collapse its slaves status and configuration. The color bar represents different states of the replication slaves: stable (green), disconnected (red). Hover over it to show the corresponding charttime. The available tabs depend on the server type of the selected instance.SQL Server Transactional / Merge Replications
Appears in 1 contract
Samples: License Agreement
