Not sure how I haven’t seen this before but I’m hopefully not the only one out there.
The PowerShell script will take a random query (from the Books Online example SELECT statements) and run them with a configurable delay inside an infinite loop.
You can run as many of these PowerShell scripts as you want concurrently and BOOM you have random workloads.
I became a Jonathan Kehayias ( twitter | blog ) fan originally for his awesome Extended Events posts (as you can tell by the photoshopped pic below) but over the years his blog posts and presentations have always impressed.
- Mladen Prajdic – (post link | blog | @MladenPrajdic ) – Immediate Deadlock Notifications Without Changing Existing Code
- Lara Rubbelke – (post link | blog | @SQLGal) – Enterprise Policy Management Framework
- Tim Ford – (post link | blog | @SQLAgentMan) – Determine Free Space, Consumed Space, and Total Space Allocated for SQL Server databases
Enjoy!! (Follow me on Twitter: @ColinStasiuk)