Skip to main content
commvault.com commvault.com
Solved

monitoring inner sql

  • December 29, 2024
  • 3 replies
  • 66 views
Explorer
Forum|alt.badge.img+8

Hello,

Can you monitor the inner sql server of the commserve via alerts or events? 

I couldnt find a way.

Best answer by ddwyer

Hi Arik,

 

Commvault has its own database maintenance utility you can look to leverage which includes running a CHECKDB and other operations.

 

You can find out more about it here:

 

https://documentation.commvault.com/2024e/expert/performing_commserve_database_maintenance_using_dbmaintenance_utility.html

 

I believe you could also look at using the custom reporting functionality to pull back this information from SQL Server: 

https://documentation.commvault.com/2024e/essential/build_your_own_reports_overview.html

 

Regards,

David Dwyer

 

3 replies

Vaulter
Forum|alt.badge.img+19

Hello ​@arik 

You can log into the SQL Server Management Studio (SSMS) and edit/create events and alerts but it is not recommended to do this without the direct advice from support or Dev. 

What are you trying to track specifically and i might be able to provide some advice on where to find it in the GUI? There are a number of Commserv health related alerts and events that are tracked by default. 

Kind regards
Albert Williams

The best way to learn anything, is to question everything
    Explorer
    Forum|alt.badge.img+8
    • arikExplorer
    • Author
    • Explorer
    • December 30, 2024

    Hello ​@arik 

    You can log into the SQL Server Management Studio (SSMS) and edit/create events and alerts but it is not recommended to do this without the direct advice from support or Dev. 

    What are you trying to track specifically and i might be able to provide some advice on where to find it in the GUI? There are a number of Commserv health related alerts and events that are tracked by default. 

    Kind regards
    Albert Williams

    Thank you for the answer.

    I did not think to create events from the ssms.

    I wanted to track % used by the transaction logs and some general db health checks

     

     

      Vaulter
      Forum|alt.badge.img+4
      • ddwyerVaulter
      • Vaulter
      • Answer
      • December 30, 2024

      Hi Arik,

       

      Commvault has its own database maintenance utility you can look to leverage which includes running a CHECKDB and other operations.

       

      You can find out more about it here:

       

      https://documentation.commvault.com/2024e/expert/performing_commserve_database_maintenance_using_dbmaintenance_utility.html

       

      I believe you could also look at using the custom reporting functionality to pull back this information from SQL Server: 

      https://documentation.commvault.com/2024e/essential/build_your_own_reports_overview.html

       

      Regards,

      David Dwyer

       

        Readiverse Academy Certifications

        description of image
        Terms & ConditionsAccessibility statement