ManageEngine® SQLDBManager Plus


Understanding SQL DB Manager

<< Prev

Home

Next >>

 

Understanding SQLDBManager Plus

 

SQLDBManager Plus is a web-based monitoring tool that the monitors the performance of SQL databases in a complex IT infrastructure. You can find six module tabs at the top which are explained as follows:

 

Dashboards

Dashboards feature enables you can create custom dashboards by adding multiple widgets of your choice - like Status View of all the Databases, Status view of all Servers CPU Utilization, SQL Buffer Hit Ratio and so on.

 

This is in addition to the already created three Dashboards - Default Dashboard, Availability and Performance Dashboard.

 

Default Dashboard: This is the default dashboard which has various widgets pre-configured. These are Availability & Health Status widget of all DB servers, SQL Server CPU and Memory Utilization widgets, SQL Server Buffer Cache Hit Ratio widget, Last N Alarms widget and Databases with high Datafile Space Utilization widget.

 

Availability Dashboard: Displays the availability of various DB servers configured for monitoring.

 

Performance Dashboard: Displays the performance of each DB server configured. You can click on particular time frame and view the alarms generated for that DB server during that particular time frame.

SQL Servers

Lists all the DB servers that are being monitored. You can also click on a particular DB server to view information of that particular DB server. You can view the IP Address, Availability, Today's Availability, CPU and Memory usage, etc in detail. Clicking on each attribute will result in a pop-up window where SQLDBManager Plus will display in-depth details such as History usage of CPU, Hour of Day report, Day of Week report ,Statistical report and Heat chart.

Alarms

Lists the alarms generated by the Monitor and their attributes, based on predefined thresholds. The view is customizable such that you can view the last 10/25/50/75/100/125 alarm entries in a single view.

Reports

Lists all the reports that are generated in SQLDBManager Plus. Reports can be exported to pdf format also

Support

Provides information on getting assistance from the SQLDBManager Plus Technical center.

Admin

Lists the admin operations such as adding new DB server, configuring Mail server, etc. to be performed for monitoring.

 

The top frame consists of links such as Feedback, Help, Licensing etc. common in all the screens.

 

Under SQL Server tab, you can see all the DB servers listed down. Each DB server is displayed along with its IP address, availability, CPU utilization, Memory utilization, Buffer Cache Hit Ratio and Plan Cache Hit Ratio. If you click on a particular DB server, the client will re-direct you to the performance metrics of that particular DB server. If you have configured more than 10 DB servers, the remaining DB servers will be displayed in the next page.

 

Under SQL Server tab, you can see the different set of views available for you to view, listed down. There are six different views:


SQL Server View

Lists those databases which are being monitored along with IP address, Current Availability, Last 24 Hours Availability, CPU usage, Memory usage, Buffer and Plan Cache Hit Ratio.

In addition, you can also view the list of Jobs running on the monitored SQL servers. You can also manage them quite easily by selecting the job(s) you wish to manage and applying the action from the pull-down menu.

You can also view the entire list of SQL server databases being monitored. SQLDBManager Plus displays the Name of each Database, the SQL server associated to the database, the Data File size (MB), Log File size (MB), Total Size (MB), its Status and Health.

Bulk Config View

Lists all the details of the monitors that are monitored. From this view you can carry out bulk admin operations like updating user name and passwords across monitors. Refer Bulk Configuration for further details.

Business View

In this view, the SQL databases will be arranged in an default order.You can re-arrange these SQL databases and click on the floppy disk icon to save the view. You can also zoom in and out of the view, and save the zoom level which is optimal for your viewing.

 

Business View has the following properties.You can edit the view by clicking on Settings icon and selecting the Edit View from the menu.

  1. Update Monitor - This setting allows you to refresh the status of the Monitors and SQL Groups automatically by fixing some limited time (in minutes).

  2. Reload Interval - This setting is similar to Update Monitor except that it will reload the entire view after the given time. The recommended interval would be 15 minutes.

  3. Associated Monitor Groups - This setting allows you to add various SQL Groups to your view. This is only available for the "Customizable Business View".

  4. Under View Properties, by selecting Show only SQL Groups and Sub Groups allows you to include the SQL Groups and Sub Groups in the selected view.

  5. By selecting Show only Critical Monitors you can show only critical Sub Groups and Monitors inside the selected view.

  6. By selecting Show only SQL Groups Status you can show the status of  top level SQL Groups (that are selected via Associated Monitor Groups) in the selected view.

You can create multiple views for a SQL Group. Click on the Settings icon in the business view and select Create New View. By providing various details like Update Monitor time interval, Reload interval, opting to select Monitor and SQL Groups and Sub Groups you can create a custom view.

 

In addition, you can also edit its apperance of the view . Go to the Display Properties tab and provide the following details:

  1. Background color
  2. Line Color
  3. Label Color
  4. Line Thickness
  5. Line Transperancy

Publishing the View: SQLDBManager Plus allows you to embed these Business View in intranet/internet portals by selecting the menu option 'Publish The View' from Settings and copy the iframe details and pasting it in the webpages.

World Map View

Maps all the monitor groups in a Google Map. Refer World Map Business view for further details.

Plasma View

The plasma view enables you to have a snapshot of what is happening with the monitors, at one glance. The view can be put up on a plasma screen, and you can have a look even when you are not in front of the monitor.

SQL Group View

Lists all SQL Groups and the Sub-Groups available. You can associate Monitors, Copy Paste Monitor, configure alarms through this SQL Group View itself. (as like Bulk Config view). In addition, you can enable or disable actions via this view itself, i.e, even if you have already configured actions like sending EMail, through 'disable action' you can prevent EMail action.

 


<< Prev

Home

Next >>

Getting Started

Prerequisites for SQL DB Manager