Page History
If you configured policies to send alerts, SQL defrag manager SQL Defrag Manager displays a record of those alerts on the Alerts History tab.
What can I do with the alert data?
Click Export to export the data in html, xml, or txt format. Click Print to send all the data to a printer. Click Clear All to erase the existing alert history.
How can I filter the alert data?
The Filters box allows you to narrow the results based on specified criteria. Select Type to show only alerts of a single severity level. Select From to show only alerts generated by a specific policy. Select To to show only alerts sent to a specific address.
How are partitioned indexes addressed in the Alert History view?
SQL defrag manager SQL Defrag Manager supports partitioned indexes similarly to non-partitioned indexes. A row exists for each partition that triggers an alert. Each partition in an index is identified by a number, which SQL defrag manager SQL Defrag Manager displays in the Partition column.
TIP
Info |
---|
SQL |
...
Defrag Manager displays "1" in the Partition column for a non-partitioned index. |
How does grouping information help me?
You can group activities by the description that generated the alert, the identified problem or action, by the name of the policy, instance, database, table, or index, the partition number, or the date and time the alert occurred. To group the displayed activities by a column value, drag that column heading to the gray bar above the column headings.
Grouping alerts allows you to quickly scan and evaluate the health of your activities. For example, you can group and view alerts for a specific database, table, index, or partition, which lets you focus on the alerts for that database object to make sure they are the alerts you want to receive and what action may be necessary on that object.
TIP
Info |
---|
Grouping on a partitioned index column causes |
...
SQL Defrag Manager to display a single row for that index including totals of all partition statistics. |
Need more help? Search the Idera Customer Support Portal
...