by bobtaylor29708 | Aug 20, 2018 | Azure SQL Database, boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Tools, SQL Snacks™, Tools
Based on a request by Microsoft Test Consultant Robert George, this SQL Snacks™ along with a tool I am releasing to the community will allow you to run a Transact-SQL workload on Azure SQL Database, capture the xel files to Azure Blob Storage, and then process them to...
by bobtaylor29708 | Aug 13, 2018 | boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Management Studio, SQL Server Tools, SQL Snacks™
In this short SQL Snacks™ we will look at a question that arose while I was at a customer site. While running load tests we were seeing abnormally high numbers of recompiles vs. compiles. Knowing that this could lead to higher CPU consumption we investigated. Thanks...
by bobtaylor29708 | Jul 30, 2018 | boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Management Studio, SQL Server Tools, SQL Snacks™, XE Profiler
In this SQL Snack™ I will examine the three remaining targets (I don’t plan on covering the ETW sync target as it is out of scope for this series). The counter, histogram and pair matching targets are very simple and straight forward to use and consume. In the...
by bobtaylor29708 | Jul 2, 2018 | Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Tools, SQL Snacks™
This week’s SQL Snacks™ we will examine the available target types. As we have discussed in previous SQL Snacks™ targets are how the Extended Event system provides us output to examine. In the next series of SQL Snacks™ we will look at each individual target and...
by bobtaylor29708 | Jun 25, 2018 | boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Tools, SQL Snacks™
This week’s SQL Snacks™ is so nutritionally dense, I had to split it into two parts. (Actually MSDN limits size of media to 40MB). Next week’s SQL Snacks™ will focus on all of the various target types – and will point out the major differences...
by bobtaylor29708 | Jun 18, 2018 | boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Tools, SQL Snacks™, Uncategorized
In this SQL Snacks™ we will examine the architecture of the Extended Events system in SQL Server. In subsequent SQL Snacks™ we will examine the UI in SSMS as well as Transact-SQL scripts to analyze XEvents....
Recent Comments