$NumberOfJobs | Start-RSJob -Name "WorkLoad" -Throttle $Throttle -ScriptBlock. I created a Invoke-RandomWorkload function which you can get from my functions repository in Github. I downloaded AdventureWorksBOLWorkload zip from Pieters blog post and extracted to my C:\temp folder. To install PoshRSJob, like with any PowerShell module, you run Install-Module -Name PoshRSJob I found this excellent blog post by Pieter Vanhove t which references this 2011 post by Jonathan Kehayias tīoth of these run a random query in a single thread so I thought I would use PoshRSJob by Boe Prox b | t to run multiple queries at the same time ? The main theme of this is to help the beginners to enhance their T-SQL capabilities on a phase by phase manner. After selecting the database, click on 'OK' button. Click on Add button and select the backup file (Downloaded and extracted earlier in the above steps). Select the device and click on the ellipses icon to select the backup media. I am writing a series of posts on AdventureWorksLT database which can be downloaded from the link AdventureworksLT2012. Open SQL Server (I am using SQL Server 2014) and right click on 'Restore Database'. For a later blog post I have been trying to generate some workload against an AdventureWorks database. TSQL Exercise on Adventure Works Database part-1.
0 Comments
Leave a Reply. |