Downtime in a SQL Server

Hi folks I am trying to find planned and unplanned downtime in some of our key servers.

This is what I have so far: 

$IDS=(3449, 7034)
foreach($ID in $IDS)
{
$UnPlannedShutDown=get-winevent -FilterHashtable @{Logname='Application';ID=$ID} -MaxEvents 1
}
foreach ($item in $UnPlannedShutDown){Write-Host $item.timecreated, $item.message}

 

IDs 3449 and 7034 in the event logs. 3449 is in Application Log and 7034 is in System log. Not sure how I would loop through this without getting errors.

P.S. I am fairly new to all this.

Regards

Paresh Motiwala

Parents
No Data
Reply
  • There is indeed a period of downtime whenever the SQL Server moves from one physical server to another in a traditional Microsoft clustering solution.there will always be some amount of downtime as the SQL Server moves from one physical node to another,the amount of time its unavailable is relatively small. anti snore mouthpiece

Children
No Data