DX Infrastructure Manager

Expand all | Collapse all

QOS not publishing for custom query sqlserver probe

  • 1.  QOS not publishing for custom query sqlserver probe

    Posted 21 days ago
      |   view attached
    I cant get QOS for custom checkpoint in sqlserver probe


    ------------------------------
    HCL Technologies
    ------------------------------

    Attachment(s)

    xlsx
    db29_S_QOS_data.xlsx   25.87MB 1 version


  • 2.  RE: QOS not publishing for custom query sqlserver probe

    Posted 21 days ago
    PRD also doent have those custom checkpoint parameters

    queries being used are
    1-
    SELECT name, state from
    sys.databases
    where sys.databases.state<>6


    2-
    SELECT database_name as db_name,
    ISNULL(ABS(DATEDIFF(MINUTE, GetDate(), MAX(backup_finish_date))), -1) as minutes ,
    ISNULL(ABS(DATEDIFF(day, GetDate(),
    MAX(backup_finish_date))), -1) as days_sincebackup ,sys.databases.state
    from msdb..backupset
    inner join sys.databases on sys.databases.name=msdb..backupset.database_name
    where sys.databases.state<>6
    group by database_name ,sys.databases.state


    ------------------------------
    HCL Technologies
    ------------------------------



  • 3.  RE: QOS not publishing for custom query sqlserver probe

    Posted 21 days ago
    only checkdb_alive is being published


    ------------------------------
    HCL Technologies
    ------------------------------



  • 4.  RE: QOS not publishing for custom query sqlserver probe

    Broadcom Employee
    Posted 18 days ago
    It looks like the query is selecting the database name, and qos metrics have to be a number.

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 5.  RE: QOS not publishing for custom query sqlserver probe

    Posted 16 days ago
    Hi David,
    I am using below query- 
    SELECT database_name as db_name,
    ISNULL(ABS(DATEDIFF(MINUTE, GetDate(), MAX(backup_finish_date))), -1) as minutes ,
    ISNULL(ABS(DATEDIFF(day, GetDate(),
    MAX(backup_finish_date))), -1) as days_sincebackup ,sys.databases.state
    from msdb..backupset
    inner join sys.databases on sys.databases.name=msdb..backupset.database_name
    where sys.databases.state<>6
    group by database_name ,sys.databases.state

    would it work if i change it to
    SELECT sys.databases.state, database_name as db_name,
    ISNULL(ABS(DATEDIFF(MINUTE, GetDate(), MAX(backup_finish_date))), -1) as minutes ,
    ISNULL(ABS(DATEDIFF(day, GetDate(),
    MAX(backup_finish_date))), -1) as days_sincebackup
    from msdb..backupset
    inner join sys.databases on sys.databases.name=msdb..backupset.database_name
    where sys.databases.state<>6
    group by database_name ,sys.databases.state


    ------------------------------
    HCL Technologies
    ------------------------------



  • 6.  RE: QOS not publishing for custom query sqlserver probe

    Posted 16 days ago
    while i am selecting state and name both in 1st query

    SELECT name, state from

    sys.databases
    where sys.databases.state<>6 and the state is numeric ,


    ------------------------------
    HCL Technologies
    ------------------------------