This is just a quick look. I plan on diving into this in the future more, as I’m still working through some of the changes being made in the main parallel modules I utilize for SQL server. In the meantime, if you are looking for a quick way to leverage some parallel query running, take a look at PSParallel. I’ve avoided Powershell Jobs/Workflow due to limitations they have and the performance penalty I’ve seen is associated with them.For my choice, I’ve explored PSParallel & PoshRSJob. I’ve found them helpful for running some longer running queries, as I can have multiple threads running across server/database of my choice, with no query windows open in SSMS. Another great option that is under more active development is PoshRsJob. Be clear that this will have a higher learning curve to deal with as it doesn’t handle some of the implicit import of external variables that PSParallel does. You’ll have to work through more issues initially to understand correctly passing parameters and how the differents scope of runspaces impact updating shared variables (ie, things get deeper with synchronized hashtables and more :-) ) Hope this helps get you started if you want to give parallel query execution a shot. Here’s a function using PSParallel to get you started. Let me know if it helps
You may also enjoy
3 minute read
What is the best way to debug more complicated parameter binding and type casting scenarios in PowerShell.
1 minute read
Just a quick look at the very beginning of setting up SQL Server Database Experimentation Assistant
5 minute read
Migrating from hipchat to slack can be a little painful if you have some issues similar to mine to cleanup. Maybe this will help save you some time.
2 minute read
Trouble with duplicate files in Google Drive? Want to fix a mess? Found the tool to do it!