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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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.
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...
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.
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...
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.
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...
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.
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.
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...
