SQLDM Mobile helps you diagnose and fix SQL Server performance issues at any time from your smart phone or other mobile devices.

Here, all the options that are available to you through SQLDM Mobile dashboards:

Active alerts

SQLDM Mobile tracks the active alerts for the SQLDM operations you are monitoring. The Active Alerts view provides a summary of each active alert so you can easily triage the corresponding performance issues. The alert summary includes the alert name and description, as published by SQLDM.

To get to the Active Alerts view for each section, tap the Dashboard tab and tap the alert area you want to review. The following alerts are displayed this dashboard:

All the active alerts displayed in the SQLDM Mobile are arrange by severity.

To see alert details, such as the affected SQLDM component and the complete alert message, tap the active alert for more information.

You can get the server profile view by tapping the Dashboard tab and then tap the status of active alert you want to explore.

Database details and databases dashboard

Database details

The Database view displays key performance metrics for the selected database, such as:

The Databases view lists all of the user and system databases hosted by the selected SQL Server instance, and provides a status summary for each database that includes the overall health and total number of connected sessions.

You can swipe this list to quickly assess the health of the server or search for a specific database whose performance concerns you.

To see more performance metrics about a database, tap the appropriate database in the list.

Database dashboard

The databases view lists all of the user and system databases hosted by the selected SQL Server instance, and provides a status summary for each database that includes the overall health and total number of connected sessions.

You can swipe this list to quickly assess the health of the server or search for a specific database whose performance concerns you.

To see more performance metrics about a database, tap the appropriate database in the list.

Home Page

The Home Page provides shortcuts to the key features available in SQLDM Mobile, as well as quick access to your favorite coworkers and servers. 

To access to your home page, log in to SQLDM Mobile and tap Home on the action menu in the upper right hand corner of your screen.

In the Home Page you can perform the following actions:

Key resource metrics

The Resources view gives you access to the key metrics you need to monitor for optimal resource performance.

You can view the current value of these metrics or plot them from now up to 12 hours in the past. These charts can help you identify performance patterns or unexpected peaks in activity.

Some resource metrics are OS metrics. To successfully monitor OS metrics, ensure OLE Automation is enabled on the monitored SQL Server instance and in the SQLDM Console.

Summary

The Summary filter presents key metrics representing the most important performance indicators across all resources. When this server is a virtual machine (VM), the Summary filter displays the CPU and memory usage consumed by the VM workload.

CPU Metrics

The CPU filter presents key metrics representing the most important performance indicators for the processors on this server.

Disk Metrics

The Disk filter presents key metrics representing the most important performance indicators for the physical disk on this server.

Memory Metrics

The Memory filter presents key metrics representing the most important performance indicators for your server memory.

Session Metrics

The Session filter presents key metrics representing the most important performance indicators for sessions connected to this server.

My Servers

The My Servers view shows a summary of all the monitored SQL Servers you monitor and their current health. Critical servers are marked with a red X while servers in good health are marked with green checks. This helps you to identify which instances are in critical state and focus your attention on the servers that they need inmediate attention.

Use the filter control to group your servers by severity or by the servers you are following.

You load this view by default when you log on to SQLDM Mobile using either a mobile devide or your smartphone. Also, you can access this view from the SQLDM Mobile home page by tapping My Servers. Then, tap an individual server to access its dashboard.

Server dashboard charts

The Charts version of the Dashboard tab on the Server view is modeled after the Server Overview in the SQLdm Console. This duplication allows you to track the same performance metrics from the same charts whether you are at your desktop or away from your environment. Consistent monitoring is key to understanding the true performance and status of your SQL Server instances.

These charts are grouped, per performance category, into the following dashboards:

To get more information about the metrics in a specific chart, tap the chart to drill down to the associated, detailed views. On the server profile view, tap the Dashborad tap. The charts version loads by default on tablet devices and on your desktop browser. To get to the traditional Server Dashboard tap the status link located next to the server status.

The chart server view is not available on small form devices such as smart phones.

Server dashboard status

The Status version of the Dashboard tab on the Server view provides a quick synopsis of the health of the server you are monitoring. From this view, you can:

On the server profile view, tap the Dashboard tab, the status version loads by default on smar phone devices. On other devices, such as tablets and desktop browser tap the Status link on the Dashboard tab.

You can check the current alert status without waiting until the next shedule refresh. In the action menu, tap the Refresh Alerts option.

SQLDM Dashboard

The SQLDM Dashboard view in SQLDM Mobile displays the overall health of the servers monitored by your SQLDM application. You can assess server health by its status or by alphabetical order.

Each server summary display the three most recent alerts. Simply, tap the server summary to open the server dashboard view. To get to the SQLDM dashboard from your directory, tap the SQL Diagnostic Manager icon.

Sessions

The Session view displays the following information about the session you selected:

In this view, you can kill a user session to prevent ongoing or escalating performance issues.

Sessions by type

The sessions view displays sessions per the selected type and provides a summary of their current status. Each session summary includes the following metrics:

The following are the type of sessions you can view:

Also, you can access to the black chain view. This view displays a hierarchical list of the order in which session are blocked. The list starts with the lead blocker abd expands the subsequently blocked sessions. In this way, you can see the relationships between blocking and blocked sessions and determine how extensive is the block.

Tap the blocked or blocking session you want,  to view more details.

In SQLDM Mobile, session performance metrics, including the number of sessions, are collected and displayed in real-time as you navigate from view to view. The connection lifespan of a session is typically brief, that may cause discrepancy between sessions.

Sessions Dashboard

The Dashboard tab on the Sessions view presents the most important performance indicator for sessions.

You can view the current value of these metrics from now up to 24 hours in the past. This allows you to identify performance patterns or unexpected peaks in activity.

Metrics available from this dashboard tab include:

Sessions details

The Details tab on the Sessions view provides a launch-pad-like interface that lets view more details about a session.

SQL Server Agent

The SQL Server Agent tab on the Services view displays the overall status of the SQL Server Agent as well as a status summary for each job. Swipe down the list to quickly see which jobs are currently running, which are scheduled to run later, and which have failed.

You can filter the list to show only those jobs that are running or have failed, or search for a specific job. You can also stop or restart the SQL Server Agent from this tab.

The Agent Job view provides detailed information about the job properties, the status of its last run, and its performance history. You can also stop or restart the selected job from this view.

Tap the job you want to see detailed Agent Job information.


SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources Legal