SQL Sentry's Aaron Bertrand (@AaronBertrand) shows how you can use Extended Events to track temp table creation and identify which session created which #temp table.
Continue Reading »May 212014
Jul 112013
Joe Sack (@josephsack) of SQLskills.com shows us that we might not always be able to make an accurate correlation between wait statistics and observer overhead, depending on the method being used to observe a system.
Continue Reading »Oct 302012
My co-worker Steve Wright (blog | @SQL_Steve) prodded me with a question recently on a strange result he was seeing. In order to test some functionality in our latest tool, SQL Sentry Plan Explorer PRO, he had manufactured a wide and large table, and was running a variety of queries against it. In one case he was returning a lot of data, but STATISTICS IO was showing that very few reads were taking place.
Oct 232012
SQL Server offers two methods of collecting diagnostic and troubleshooting data about the workload executed against the server: SQL Trace and Extended Events. Starting in SQL Server 2012, the Extended Events implementation provides comparable data collection capabilities to SQL Trace and can be used for comparisons of the overhead incurred by these two features. In this article we'll take a look at comparing the "observer overhead" that occurs when using SQL Trace and Extended Events in various configurations in order to determine the performance impact that data collection may have on our workload through the use of a replay workload capture and Distributed Replay.
Continue Reading »Oct 152012
SQL Sentry's @AaronBertrand shows several reasons why you shouldn't use the sp_ prefix on stored procedures in SQL Server, including a performance hit.
Continue Reading »