I have been so busy this week that I didn’t get a chance to blog about this yesterday when it happened, but I had a new article published on SQLPerformance.com that compares the performance impact or "observer overhead" of using SQL Trace and Extended Events. I had a lot of fun running different benchmarks for [...]
Jonathan Kehayias
The Rambling DBA
New Article on SQLPerformance.com comparing “Observer Overhead” of Trace vs Extended Events
Posted on: October 24, 2012 12:20 pm
Performing a Distributed Replay with Multiple Clients using SQL Server 2012 Distributed Replay
Posted on: November 19, 2011 1:52 am
In the first post in this blog series on using SQL Server 2012 Distributed Replay, Installing and Configuring SQL Server 2012 Distributed Replay, we looked at how to configure a Distributed Replay environment using multiple clients and a dedicated replay controller. In this post we’ll actually make use of the previously configured servers to perform [...]
The AdventureWorks2008R2 Books Online Random Workload Generator
Posted on: November 18, 2011 11:38 pm
Over time, I’ve had a number of reasons to need to run a random workload against SQL Server to be able to demonstrate troubleshooting, how SQLOS works, and most recently how to capture a Replay Trace for my series on the Distributed Replay Utility in SQL Server 2012. For a while I’ve maintained a large [...]
Installing and Configuring SQL Server 2012 Distributed Replay
Posted on: November 9, 2011 2:00 am
This blog post is the first in a series of posts that will cover how to install, configure, and use the new Distributed Replay Utility in SQL Server 2012. The distributed replay utility can be used to assess the impact of changes and upgrades by replaying workload activity against a test environment based on a [...]
