locked
CheckDatabaseRedundancy runs forever ...? RRS feed

  • Question

  • Hello,

    we run the standard job "Database one copy alert" once a hour, since 20 days the job is running without finishing.

    We have no logs in the eventlog 

    if i run the Skript with the -v option, i can see no errors at all.

    .\CheckDatabaseRedundancy.ps1 -MonitoringContext -ShowDetailedErrors -ErrorAction:Continue -v

    it stops at "sleeping for 60 seconds..."

    ErrorMessage: ,
    SuspendComment:
    VERBOSE: [11:24:41.404 UTC] Is-DagServerOnline: Entering: `$serverName=XXXXXXXXXX
    VERBOSE: [11:24:41.404 UTC] Is-DagServerOnline: Leaving (returning 'True')
    VERBOSE: [11:24:41.451 UTC] Check-DatabaseRedundancy: 'DB005': CurrentRedundancyCount=3, LastRedundancyCount=3
    VERBOSE: [11:24:41.451 UTC] PossiblyReport-RedGreenStatus: 'DB005': time in green = 1341 secs.
    VERBOSE: [11:24:41.451 UTC] Report-GreenStatus: Reporting a Green event for database copy 'DB005'
    VERBOSE: [11:24:41.451 UTC] Iteration 2 of the monitoring check completed in 1281231.6567 ms
    VERBOSE: [11:24:41.466 UTC] Iteration 2 of the monitoring check completed successfully.
    VERBOSE: [11:24:41.466 UTC] Sleeping for 60 seconds...

    running only .\CheckDatabaseRedundancy.ps1 works without problems and all databases are in green state.

    Can anybody help?


    Tuesday, November 20, 2012 12:42 PM

All replies

  • It looks like this script is designed to run forever.

    Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."

    Tuesday, November 20, 2012 11:09 PM