Shared Files for Database Performance Analyzer
  • SQL Server Database Corruption

    Description Database corruption occurs when data is not stored correctly on disk or I/O subsystem. The cause of the corruption is often a hardware issue on the I/O systems or a bug in the operating system, but corruption can be caused by a wide array of issues. The problem you will notice are errors when SQL Server tries to read the corrupted information. Within SQL Server the suspect_pages table in the msdb database records the corrupted pages whenever the page is read and an error occurs, CHECKDB...
    • 23 Mar 2023
  • SQL Server Table Growth

    DESCRIPTION This alert works in conjunction with the SQL Server Table Size Collector alert in this same section. Please install that alert as a requirement for this alert. This alert will review the last 2 days of data from the collector alert (runs once a day) and calculate the growth of each table based on number of rows. You can use the thresholds in the alert to get warned when the number of rows in a table grows by more than 10% is a given day as an example. ALERT DEFINITION To create...
    • 25 Jan 2023
  • SQL Server Table Size Collector

    DESCRIPTION This alert will collect the number of rows of the top 500 tables (based on number of rows) in all databases in a SQL instance. This example alert is used only for collecting data and would never alert anyone. This data is provided as input for another custom alert named "SQL Server Table Percent Growth". Also shown below is a query that will allow you to report on this data as collected in the DPA alert tables. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts...
    • 25 Jan 2023
  • DB2 Error Log

    Monitoring the db2diag.log file is key to understanding when problems are occuring. Both warning and error message are written to this file, and a DPA custom alert can watch this file by using the SYSPROC.PD_GET_LOG_MSGS system function. The 2 main columns used in this alert are the MSG (the error message) and MSGSEVERITY (W for Warning or E for Error) columns. This custom alert turns any Warning messages into an alert value of 1 and Error message use a value of 2. This allows us to setup alert...
    • 4 Jan 2023
  • DB2 Database Growth

    This alert is based off data collected as part of the Database Size custom metric: https://thwack.solarwinds.com/content-exchange/database-performance-analyzer/m/custom-metrics/3452 It checks the max collected value from today, compared to yesterday and returns a percent of growth. The threshold are based on the percent growth, so it you want to be notified when a database grows more than 10 or 20%, use these thresholds: Note: after pasting in this SQL script, modify the value for the variable...
    • 4 Jan 2023
  • Sybase Disk Space Monitoring

    Later versions of Sybase include a monitoring view named monDeviceSpaceUsage that can help us monitor disk space within DPA. This monitoring view shows data for each file for all databases, but we can use some MIN and MAX logic to break that down to the drive level. The query will return multiple rows of free space percentages at the drive level. To create the alert within DPA, create an alert of type Custom - Custom SQL Alert - Multiple Numeric Alert and configure thresholds accordingly. Note...
    • 19 Dec 2022
  • Average SQL Execution Time Anomaly

    Many customers have asked if DPA can alert them when a SQL statement starts executing longer than it has historically. This custom alert will help do that and as written will calculate the following: Historical Average - how long has the query historically averaged - uses CON_STATS_SUM_XX DPA table Recent Average - how long as the query executed on average recently - uses a combination of CONSW_XX and CONSS tables Percent Higher - how much higher is the current average compare to history...
    • 9 Dec 2022
  • Disk Free Space Monitor for SQL Server

    DPA does not include disk space monitoring out of the box, but there are DMVs that can help us create a custom alert. The DMV is named dm_os_volume_stats and when it's joined to the sys.master_files table, we can see available bytes and total bytes for each database file. Aggregating that at the drive/mount point will allow a free space percent to be calculated for each drive. To add this alert into DPA, create a custom alert of type Custom SQL Alert - Multiple Numeric Return and paste in the...
    • 9 Dec 2022
  • SQL Server Database Size Collector

    DESCRIPTION This alert will collect the size each database in a SQL instance. This example alert is used only for collecting data and would never alert anyone. This data is provided as input for another custom alert named "SQL Server Database Percent Growth". Also shown below is a query that will allow you to report on this data as collected in the Ignite alert tables. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL...
    • 7 Nov 2022
  • SQL Server Database Growth

    DESCRIPTION This alert works in conjunction with the SQL Server Database Size Collector alert in this same section. Please install that alert as a requirement for this alert. This alert will review the last 2 days of data from the collector alert and calculate the growth. You can use the thresholds in the alert to get warned when a database grows by more than 10% is a given day as an example. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert...
    • 7 Nov 2022
  • SQL Server Agent Not Running

    DESCRIPTION When the status of a SQL Server agent goes into a state other than "Running", this alert will return a value of 1 (true), otherwise it will return 0 (false). When configuring thresholds for this alert, use the value of 1 as the Critical level and DPA will let you know when the SQL Server agent is not currenty running. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return and configure...
    • 28 Oct 2022
  • SQL Server Database Offline

    DESCRIPTION When the status of a SQL Server database goes into a state other than ONLINE, this alert will return a value of 1 (true), otherwise it will return 0 (false). When configuring thresholds for this alert, use the value of 1 as the Critical level and DPA will let you know when a database is not ONLINE. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return and configure as needed.
    • 28 Oct 2022
  • Custom Alert - AG Data Loss Alert

    This alert will query data already collected by DPA to be used in a custom alert. It will trigger based on thresholds you establish for estimated data loss due to latent AG replication. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return making it look similar to this example. Alert Name: AG Data Loss Alert Execution Interval: 4 Minutes Notification Text: Potential data loss if forced...
    • 4 Oct 2022
  • Oracle Tablespace Growth Percent

    Description This alert uses the data collected by the Collect Oracle Tablespace Sizes alert job and calculates the growth from one collection to the next. It can then alert when any tablespace grows by more than X% as defined in the thresholds. Alert Definition To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert as needed and paste in the attached query.
    • 30 Sep 2022
  • Oracle - Collect Tablespace Sizes

    Description This alert is used for collection of data only and does not alert or send emails. The data for tablespace sizes is collected and then stored into the DPA alert tables within the repository. At the bottom of this page is a script that can be used to report on this data for charting. Alert Definition To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert as needed and paste in the...
    • 30 Sep 2022
  • Execution Plan Change

    Description This alert provides a list of SQL statements that have experienced an execution plan change within the last hour or whatever the execution interval is defined as. Alert Definition To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert as needed and paste in the attached query.
    • 30 Sep 2022
  • Oracle - Collect Bind Value Samples

    Description Sometimes a SQL statement will execute differently based on the bind value that gets pass in. To collect a sampling of those bind values, this alert can be used to retrieve the values and store them in the DPA alert tables. This alert will never send an email, but is used to collect the data only. At the bottom of this page is a query that can be used to report on this information from the DPA alert tables. Alert Definition To create the alert, click on Alerts > Manage Alerts...
    • 30 Sep 2022
  • Oracle Max Sessions

    DESCRIPTION This alert calculates the percent of sessions used, i.e. the number of current sessions divided by the maximum allowed sessions (SESSIONS parameter). ALERT DEFINITION To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return. Configure the alert as needed and paste in the attached query.
    • 23 Sep 2022
  • Sybase Max Locks

    DESCRIPTION This alert will calculate the ratio of current number of locks (counts rows in syslocks) against the max locks available (number of locks from sp_configure / sysconfigures). ALERT DEFINITION To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return. Configure the alert as needed and paste in the attached query.
    • 23 Sep 2022
  • Oracle Scheduler Job Failures

    Description Some customers execute database jobs using DBMS_SCHEDULER and this alert will notify you of failures in those jobs. Because DPA custom alerts work with numeric returns, this SQL statement changes the status value to one of 0 (normal), 10 (stopped) or 20 (failed) in increasing severity. The thresholds in the alert should be defined accordingly. Alert Definition To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple...
    • 23 Sep 2022