Jan 022018

Every now and again as a Microsoft PFE, you get a chance to make a big difference for a customer. One such occasion happened just recently when I was asked to help find a way to automate the daily checks the DBA had to perform every morning. The result was a PowerShell script that reduced that manual task down from an hour to less than a minute.

You can read the full article here on MSDN.

The PowerShell script can be downloaded from here.

  2 Responses to “SQL Server Morning Health Checks”

  1. Hi Patrick,
    i’m having issue running create function script downloaded from github,
    kindly can you advice how to resolve it,

    C:\temp\Invoke-MorningHealthChecks.ps1 : Parameter set cannot be resolved using the specified named parameters.
    + CategoryInfo : InvalidArgument: (:) [Invoke-MorningHealthChecks.ps1], ParentContainsErrorRecordException
    + FullyQualifiedErrorId : AmbiguousParameterSet,Invoke-MorningHealthChecks.ps1

Leave a Reply to khaled Cancel reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



This site uses Akismet to reduce spam. Learn how your comment data is processed.