• Script for purging or clearing alarms prior to last SQL restart date

    Does anyone have a script that either clears or purges alarms prior to the SQL instance's last restart (or up since) date?  It would have to be on a per-instance basis.  For example, let's say SQL1 was restarted 20191127 at 15:00 and SQL2 was restarted…

  • Discrepancy on the hardware requirements for Foglight Management Server

    Maybe I'm missing something, but I'm trying to calculate our hardware requirements for the FMS.

    I've got to think the second example in the walk-through may not be for the Foglight Management Server alone.

    From https://support.quest.com/technical…

  • FMS Installation issue on external MYSQL

    Hi, I have installed FMS with HA on 2 server. But found lot of cartridges are not being installed during the installation. Showing below type of dependecies error and unable to install any type of cartriges on FMS. Found lot cartridges are in disable…

  • Dashboard Chart sizing

    Hello

    does anyone has experience with changing size of custom dashboard charts. I don't think about page layout but horizontal and vertical size of chart..Grid Workload Container.

    here is the picture of one of mine dashboard chart and I need it to…

  • Error with cartridge 5.9.3.20 and MySQL 8.0.14 enterprise

    Hi guys,

    Has anybody tried to monitor a MySQL 8.0.14 enterprise database with MySQL Agent cartridge version 5.9.3.20?

    I'm not having any luck, trying multiple permutations of configuration, including skipping start test.

    Generally logs show:

    2019…

  • SQL PI -> Databases tab slow or non-existent information

    I'm trying to use the "Databases" function within the "SQL PI" section.

    Once I get into this, the grid view loads but in most cases, the data columns are either extremely slow to load, or in some cases, never load at all.  I've…

  • Startup Error

    Dear All,

    Could you please check below error on startup and suggest solution .

    2018-10-17 13:15:40.044 FATAL [forge-startup] com.quest.nitro.startup.ForgeServer - Unexpected error during server startup, exiting with error code 1133.
    org.springframework…

  • How do I change the DBO-EmailNotification_Message_CC

    I need to change the CC mail list to send out an email to a third party managed service provider, but only need to send them information about certain Oracle instances and need to send the email only during certain hours. How do I use the registry editor…

  • TEMP tablespace ran out of space, can SQL PI help?

    Last night the TEMP tablespace maxed out on one of your databases:

    ORA-1652: unable to extend temp segment by 64 in tablespace TEMP

    It almost doubled in size to 8GB in a matter of minutes. I was trying to use SQL PI to find out what happened and if there…

  • How to Exclude alarms for specific text from the Agent Error log?

    Hi Guys,

    ​ENV:

    FMS: 5.7.5.6
    Sybase: 5.5.8.47
    ​Sybase ASE: 15.0.3

    PROBLEM DESCRIPTION:

    Note: This is about customizing the Agent_Error_Messages rule.

    Customer is receiving an alarm for the below error found in the Agent Error logs

    Collection [TopSQL_callback…

  • DB2 instance configuration in foglight

    Team,

    We are trying to monitor DB2 databases which are running on Windows server 2012 R2. After successful installation, when we try to configure DB2 instance in foglight, we are getting the following error. Someone please help me to resolve this issue…

  • Number of sessions displayd

    Hello. I just installed Foglight for SQL Version 5.7.5.7 and under sessions it shows only first 500 sessions. How can I increase that number to display all  sessions in my sql server?

  • SQL server memory settings for new Foglight monitoring server

     Hi Experts,

     

    I'm keep on getting thePopup message while adding servers into the foglight monitoring tool.

    Can you please suggest me whether i have to configure the SQL memory settings or Foglight any config files need to change the memory settings…

  • Foglight for SQL Server PI on Linux startup/shutdown config?

    We have a RH Linux box set up as our Foglight PI Repository database server. The software was installed (by Quest) and verified as working, and the ticket closed. Now, months later, we restart the box, but no service! Apparently we skipped the step where…

  • Daily Blocking History Report

    Has anyone created any blocking history reports?  I am looking to create daily blocking reports that are emailed every morning about what was blocking what and for how long.... host, app, sql, resource, lock type, start time, block duration, block chain…

  • Unable to verify user defined collection

    I am trying to create a UDC for the following sql:

    select a.tablespace_name,
           round(a.bytes_alloc/(1024*1024*1024),0) "TOTAL ALLOC (GB)",
           round(a.bytes_alloc-b.tot_used/(1024*1024*1024),0) "FREE (GB)",
           round((nvl(b.tot_used,0)/a.bytes_alloc…

  • Get value of an Oracle initialization parameter

    I would like to create a rule to check the current PGA memory allocation against the PGA_AGGREGATE_LIMIT initialization parameter. I can't work out where the initialization parameters are stored to retrieve its value in the condition of the rule I am…