Skip to content

Instantly share code, notes, and snippets.

@alevyinroc

alevyinroc/gist:ec6619b186e1a80dba4b2df3cd57871c

Last active September 12, 2017 19:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alevyinroc/ec6619b186e1a80dba4b2df3cd57871c to your computer and use it in GitHub Desktop.
Save alevyinroc/ec6619b186e1a80dba4b2df3cd57871c to your computer and use it in GitHub Desktop.
Download ZIP
Running Compare-Object on Get-DbaSpConfigure output
Raw
gistfile1.ps1
$Prod = Get-DbaSpConfigure -ServerInstance PROD -SqlCredential (get-credential -Message "Prod" -UserName MySQLLogin);
$Test1 = Get-DbaSpConfigure -ServerInstance Test1;
Compare-Object -ReferenceObject $Test1 -DifferenceObject $Prod -property ConfigName,RunningValue|Sort-Object ConfigName;
ConfigName RunningValue SideIndicator
---------- ------------ -------------
MaxDegreeOfParallelism 6 =>
MaxDegreeOfParallelism 4 <=
MaxServerMemory 563200 =>
MaxServerMemory 25600 <=
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment