Capacity Planning on windows Servers using Power BI 2

Capacity Planning on windows Servers using Power BI 2

Once our db is set and properly running, next step is to deploy the agent on intended servers.

Our goal is to schedule ps script and get it running daily on different time windows, by default: 2am, 10am, 4pm; and thus measuring from high business loads to lower, so we can compare how our servers are working.

After launched and reached one server, script will ask for computer information (processors, license, OS version, etc) and will push all of this in different tables (DiskPeaksCAP, ServerCAP, ServerNICsCAP, ServerPeaksCAP):

  • Set-ServerCapRep.ps1

Then, it will copy following agent script, and finally schedule to run 3 times on a daily basis.

  • Add-DataServerPeakAgent.ps1

You only need an input text file, containing list of servers you want to deploy agents. It should go with the rest of scripts and be named as Servers.txt

This is an example of what you can expect after running:

.\Set-ServerCapRep.ps1 -file .\Servers.txt -verbose

Running script

You can also check for data with SQL Operations Studio, just to make sure you’ve got all sorted.

SQL Operations Studio

Eloy Salamanca