<img height="1" width="1" style="display:none;" alt="" src="https://dc.ads.linkedin.com/collect/?pid=204641&amp;fmt=gif">

Create a customized database performance view in dbWatch

Posted by Chad Pabalan on Mar 8, 2021 7:00:00 AM

About the Author:

Chad is a Pre-sales Engineer for dbWatch and a DBA who specializes in SQLServer high availability setups and disaster recovery planning and configurations. He is an AWS Certified Solutions Architect Associate, a cloud enthusiast who specializes in architecture and designing scalable, high available, and fault-tolerant systems on AWS.

----------------------------------------------------------------------------------------------------------

 


As a database administrator managing many different database instances on various platforms, it can be difficult for you to track various aspects of your performance within your database farm. You need help from specialized tools to monitor your database key performance metrics, a database monitoring solution that offers the functionality for customization and allows you to view the most important metrics you need in a single window.   

Creating a view is not that complicated, like creating and modifying views in SQL Server and Oracle databases. With dbWatch, you can easily create, customize, or modify existing views. You can also incorporate your existing performance scripts and display it on a single view in dbWatch.  

This section will show you how you can create a custom view using dbWatch properties and your existing monitoring script.   

In this example, we will be creating a dbWatch property and sub-properties (using dbWatch EM12), which will be used to create a custom view where we could monitor all sessions running in our SQLServer and Oracle instances.  

 

  1. 1. Download and update the XML Template you will use and modify depending on the performance counter you would like to create as a view and Monitor.   

           (Note: read the REPLACE comments on the XML file)   

  1. 2. After modifying the document, save it as an XML file   
  2.  
  3. 3. Go to your dbWatch Monitor. At the top3, choose Configure and click Upload Resource. 

 

  1. 4. A new window will appear; choose the xml file we have modified then click Upload. 

 

            5. After modifying the document, save it as an XML file 

 

             6. A new window will appear which helps you create a new tab and a view.   

Please specify the name of the view in this example: I will name it as Oslo-Cluster Session Info.  Click OK. 

 

  1. 7. A new window will appear, where you input the FDL(Farm Data Language) query to retrieve the columns from the XML file we've modified. (FDL is a powerful language dbWatch has developed to help you query and retrieve data across database platforms. Learn more about FDL by clicking here)  

Earlier, we have configured our select query for both Oracle and SQLServer within the XML file template. We will select all the columns and data from SQLServer and Oracle session tables in the question below.  

FDL Query:  

$instance->i/session_id{"Session ID" #hide}->sid  

/$I/name{“Instance”}  

/$sid/username{"username"}  

/$sid/logon_time{"logon time"}  

/$sid/db_name{"database"}  

/$sid/status{"status"}  

/$sid/host{"host"}  

/$sid/program{"program"} 

 

          8. At the top, choose File and click Save. 

The new view contains the different columns which we would like to display has been created.   

By following these steps, you can easily create dbWatch properties and customize your performance view based on your existing performance script.  

 

---------------------------------

 

If you have any questions or would like to know more on how dbWatch can assist you in your current enterprise database monitoring and management situation.  

Please contact us through the email: chadwick@dbwatch.com  

For more information, visit www.dbWatch.com or wiki.dbWatch.com  

 

Other Blogs:

Backing up your data with dbWatch Control Center: a practical guide on how you can monitor and manage your backups

Monitoring MyISAM Performance with dbWatch – a Guide

 

Topics: database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager