Generate heavy load over AdventureWorks database. Script from “AdventureWorks” sample database querying series. You can use this on for some testing purposes. It is pretty long running and heavy query so you can use it for showcase of instance performance monitoring.

TIP: If you want to generate even more load to server run this query from SqlQueryStress tool

SELECT
	p.[Name],
	p.ProductNumber,
	th.*,
	tha.*
FROM Production.TransactionHistory th
	INNER JOIN Production.Product p ON p.ProductID = th.ProductID
	INNER JOIN Production.TransactionHistoryArchive tha ON th.Quantity = tha.Quantity