If you have been working with PowerShell and SQL Server for a while now, you know that it is not difficult to capture the PRINT statement output as VERBOSE output (which can then be redirected to a variable or file). You also know that it is not too difficult to run SQL in parallel against … Continue reading PowerShell & SQL Server: Run In Parallel – Collect SQL Results With PRINT Output From Across Your SQL Farm – Fast!
If you are running into memory issues such as below, there could be several causes but one of the causes is excessive parallelism and exhaustion of PGA memory. “ORA-01034: ORACLE not available / ORA-27102: out of memory / Linux-x86_64 Error: 12: Cannot allocate” Please read on to find out how to resolve this. There are … Continue reading Oracle – Parallel To PGA (P2P) & Serial To SGA (S2S) – Caching Differences And When Parallelism Is Not The Panacea For Performance!
What is a Semaphore? Instead of a clinical illustration of exclusive row lock and exclusive table lock usage in Oracle, here we will try to use them to highlight a higher level concept – Implement a semaphore mechanism. Wikipedia defines semaphore as below: In computer science, a semaphore is a variable or abstract data type … Continue reading Oracle – PL/SQL – Using ROW/TABLE Locks To Implement Application/Job Semaphore To Handle Race Conditions
Why is the APPEND hint so great? In a prior post, we extolled the virtues of the APPEND hint (AKA Direct Path Insert). It is a great option to use • UNDO usage is negligible. It is only generated for index maintenance and meta data changes. The keyword is index maintenance – indexes generate UNDO. … Continue reading Oracle – Is my APPEND Hint Being Ignored? How To Find Out?
Update (Mar 16, 2018): Please check-out my most recent blog post related to this on how to use this to invoke your own PowerShell function in parallel: https://sqljana.wordpress.com/2018/03/16/powershell-sql-server-run-in-parallel-collect-sql-results-with-print-output-from-across-your-sql-farm-fast/ Why asynchronous processing? If it takes a man 10 hours to do something, technically, it would take just one hour if 10 men did it. Right? Not … Continue reading Invoke-Async – Asynchronous parallel processing for any workload in PowerShell