This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.
Today, I worked on a service request where our customer needs to execute multiple TSQL command in parallel and measure how much time took every operation, like connection and execution.
For this operation, we shared in this URL an example PowerShell script to perform this operation. Basically, you have two PowerShell script:
- DoneThreads.ps1 that will manage how many background jobs will be execute and how many in parallel.
- DoneThreadIndividual1.ps1 that will be the PowerShell script that will be executed and called by DoneThreads.ps1 in parallel. This file will save the information in a text file saving the information about connection time and execution time.
Please, all help is very welcome if you want to collaborate/improve in this small project.
Enjoy!