SQL agent scanning SQL DB'S in an instance

Last post 08-12-2020, 11:01 AM by Liam. 6 replies.
Sort Posts: Previous Next
  • SQL agent scanning SQL DB'S in an instance
    Posted: 08-10-2020, 7:07 AM

    Hi, our DBA noticed some special behavior of the commvault sql agent. They noticed that the agent is scanning for a SQL Stored Procedure & Assembly (CLR) at the time a backup is scheduled  :

    USE [DB] SELECT count(object_id) FROM [SYS].[objects] WHERE object_id = OBJECT_ID(N[DBO].[proc_CheckRbsInstalled]) and [type] in (N'P.N'PC')

     

    The behavior is the following : 

    connection to db#1 and executes query on db#2… connected to db#2 it executes on db#3 , ...

     

    Why is the sql agent acting like that ( our dba's don't like that process ) ? ( Why is it checking that store proc. ( proc_CheckRbsInstalled ) ?)

  • Re: SQL agent scanning SQL DB'S in an instance
    Posted: 08-10-2020, 8:14 PM

    Certainly looks unusual and any DBA with a keen eye would be suspicious. I suspect it is connected to a niche Commvault feature for SQL Server Table Archiving?

    Edit: See David's answer Cool

  • Re: SQL agent scanning SQL DB'S in an instance
    Posted: 08-11-2020, 6:07 AM

    Hi Lionel,

    CV runs many queries as part of its backup/discovery process.

    You will see that we perform certain checks against each DB as the job progresses as well as collecting backupset information as the jobs complete to allow CV to perform consistency checking against the log backups.

    The check you've highlighted here is to see whether the instance/databases are configured for RBS. We do this by checking if the stored procedure exists.

    https://docs.microsoft.com/en-us/openspecs/sharepoint_protocols/ms-wssfo3/6d9b5c75-b83d-472c-bb5d-fa7f75fd31d7

    I believe this is part of RBS-Aware backup for SharePoint Content Databases:

    https://documentation.commvault.com/commvault/v11/article?p=17813.htm

    In the SQLiDA.log you can see it performing the RBS status checks.

    Is there anything in particular about this behaviour that the DBA is having issues with?

    David

     

  • Re: SQL agent scanning SQL DB'S in an instance
    Posted: 08-11-2020, 6:09 AM

    Hi Anthony,

    It won't be for table level, it will be for RBS support. The Table Level stuff uses VSS and block-level technology.

    David

  • Re: SQL agent scanning SQL DB'S in an instance
    Posted: 08-11-2020, 6:13 AM

    Thanks David, I have ammended my response.

  • Re: SQL agent scanning SQL DB'S in an instance
    Posted: 08-12-2020, 4:48 AM

    Hi David,

    here's what the DBA respond to me then ( in short ) :

    So every MSSQL instance is a sharepoint for CV???

     

    It is always better to check system tables [master file type will not change over time] and not a name of a stored procedure…

     

     

    To check if RBS is active YOU DO NOT need this…

     

    Just do… on server level…

     

    strComputer = "."

     

    ‘ ComputerManagement12 = MSSQL2014… ComputerManagement11 = MSSQL2012… etc…

    Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\Microsoft\SqlServer\ComputerManagement12")

    Set colItems = objWMIService.ExecQuery("SELECT * FROM FilestreamSettings",,48)

    For Each objItem in colItems

        Wscript.Echo "-----------------------------------"

        Wscript.Echo "FilestreamSettings instance"

        Wscript.Echo "-----------------------------------"

        Wscript.Echo "AccessLevel: " & objItem.AccessLevel

        Wscript.Echo "IncompleteOperation: " & objItem.IncompleteOperation

        Wscript.Echo "InstanceName: " & objItem.InstanceName

        Wscript.Echo "IsClustered: " & objItem.IsClustered

        Wscript.Echo "RsFxVersion: " & objItem.RsFxVersion

        Wscript.Echo "ShareName: " & objItem.ShareName

    Next

     

     

    and If you don’t want to use WMI…

     

    You can just do…

    EXEC sp_configure filestream_access_level

  • Re: SQL agent scanning SQL DB'S in an instance
    Posted: 08-12-2020, 11:01 AM
    • Aplynx is not online. Last active: 09-11-2020, 4:24 PM Liam
    • Top 10 Contributor
    • Joined on 05-04-2010
    • New Jersey
    • Master
    • Points 1,881

    You might want to open a ticket with Support as the tech assigned can deal with Development directly for questions such as this. 

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2020 Commvault | All Rights Reserved. | Legal | Privacy Policy