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!
Updated Mar 01, 2022
Version 3.0Jose_Manuel_Jurado
Microsoft
Joined November 29, 2018
Azure Database Support Blog
Follow this blog board to get notified when there's new activity