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
2 minute read
SQL Server requirements vary based on the version.
5 minute read
Git can be an interesting learning curve if you are coming from TFS (Team Foundation Server). However, there are some great things about using Git if you can...
3 minute read
I’ve been in the process of migrating my site to it’s final home (as far as my inner geek can be satisfied staying with one platform)… Jekyll.
less than 1 minute read
I’ve made it my personal quest as a creative who has a passion for videography to try and capture simple moments during my life with family. There are plenty...