SQL Server indexing basics are critical to query and server performance. Resources, like CPU and disk, are affected by the indexes that you have, or the ones you’re missing. In the StackOverflow2013 database we’re going to look at Badges and users. Specifically, I want to start by seeing what badges a user has and … Continue reading SQL Server Indexing Basics – 7 Lessons Learned
Query Store came out in SQL Server 2016. It was the next evolution of Microsoft’s attempts to provide valuable performance data. In this post you’re going to learn a bit about the history of native monitoring in SQL Server, why you should be using the Query Store, as well as how to view the information … Continue reading SQL Server Query Store Overview
What process can you use to find SQL Server training resources that will be valuable? After all, not everything on the internet can or should be trusted. If you want training on something in this constantly changing world of technology, how do you locate that training? How do you find information that is … Continue reading How Do You Find Good SQL Server Training Resources?
Have you ever looked at sys.dm_os_virtual_file_stats and saw horrible latency for your database files? Generally speaking, you want to see latency below 20 ms on your database files. much above that and there are some problems somewhere that need some tuning. But, how do you know what queries are causing your issue? What’s causing those … Continue reading Correlating IO Wait with Queries