Check out the second video on our series on Tuning SQL Server. After explaining the data model in the first video, where we cover the process by which we caused the performance issues.
In this second video of the series I show how we can call procedures using OStress.exe to simulate hundreds of users running the query concurrently and the impact of it on the CPU. We can also use Activity Monitor to get a quick idea on if there is an issues that we need to investigate further.
https://www.youtube.com/watch?v=0hF0T7SF3-Y
Please Consider Subscribing
