PowerShell & SQL Server: Run In Parallel – Collect SQL Results With PRINT Output From Across Your SQL Farm – Fast!

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!

Advertisements

Oracle – Parallel To PGA (P2P) & Serial To SGA (S2S) – Caching Differences And When Parallelism Is Not The Panacea For Performance!

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!

Oracle – PL/SQL – Using ROW/TABLE Locks To Implement Application/Job Semaphore To Handle Race Conditions

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

Oracle – Is my APPEND Hint Being Ignored? How To Find Out?

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?

Invoke-Async – Asynchronous parallel processing for any workload in PowerShell

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