Create a SQL Server Database Alert - Intergraph Smart 3D - Installation

Intergraph Smart 3D Installation

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Installation
SPFVersion_custom
2019 (10.0)
Version_S3D
12.1(2019)

When the Smart 3D database server is running low on disk space, the software begins to display error messages because data can no longer be persisted or logged. Microsoft SQL Server, however, does not issue any particular alerts for the workstation computers when the disk is full or becoming limited.

Using the Performance Monitor, the Smart 3D administrator can create a Data Collector Set that contains an alert to be issued when a threshold value for a System Monitor has been reached. In response to the alert, System Monitor can launch an application to handle the alert condition.

You must perform the following procedure on the database server computer:

  1. Open Server Manager.

  2. Click Tools > Performance Monitor.

  3. Expand Monitoring Tools in the Performance tree view, and start the Performance Monitor.

  4. Expand Data Collector Sets in the tree view, and right-click on User Defined.

  5. Select New > Data Collector Set from the shortcut menu.

  6. Type the name for the data collector set, click Create manually (Advanced), and then click Next.

  7. Select Performance Counter Alert, and click Next.

  8. Click Add to open the Add Counter dialog box.

  9. Set the database server name in the Select counters from computer field.

  10. Select the Microsoft SQL Server object in the Available counters section.

  11. Select a counter in the Select counters from list list, select a counter, and the click Add.

    The new counter displays in the Added counters list.

    Use CTRL+ or SHIFT+ to select multiple objects.

  12. After all counters have been added, click OK to close the Add Counters dialog box.

    To add local counters from a remote computer, you must have one of the following permissions on the computer:

    • Local administrator privilege

    • Be a member of the Performance Monitor Users local group.

  13. Under the Performance counters list, select either Above or Below for the Alert when value.

  14. In the Limit box, enter a threshold value. Depending on the object you selected, the software generates the alert when the value for the counter is more than or less than the threshold value. Click Next to continue.

  15. Click Finish.

    Your new data collector set displays in the User Defined page.

  16. To configure the alerts, double-click on your data collector set name and then right-click the data collector. Select Properties from the shortcut menu.

  17. On the Alerts tab, you can set additional alerts and define the unit of time for the duration of the sample interval.

  18. Set options in the Alert Action and Alert Task tabs to specify the actions to occur each time the alert is triggered.

  19. Click OK to close the Properties dialog box and activate the alert settings.

    For more information about using System Monitor and setting up SQL Server alerts, see the documentation delivered with Microsoft SQL Server and Windows Server.