Search


	Podcast:		voiceofthedba's podcast
	Episode:		Moving to Query Store
	Category:		Technology
	Duration:		00:03:25
	Publish Date:		2018-11-25 20:00:00
	Description:		In SQL Server 2016, Microsoft introduced the Query Data Store (QDS) as a tool that would capture data about the execution of queries inside of your database. This was a project that had been in the works for a number of years, and one that many of us that were bound by NDA agreements had been following. We were excited by the chance to actually gather some information on the. Are you using Query Store? You should be, as this tool will become more valuable over time. I know that there are potential overhead issues (3-5% for most people, but possibly larger). I would argue that the potential for better performance and understanding of our systems outweighs the overhead. After all, if we're unwilling to devote some resources to measuring our systems, how do we really know what to improve? Read the rest of Moving to Query Store
	Total Play:		0