In our spare time, between ogling tasting menus, we build more stuff to help: = 1 – explains the rest of sp_BlitzCache’s parameters, plus the output columns as well.Good for sharing the plan cache metrics with other folks on your team. = 1 – excludes result set columns that would make Excel blow chunks when you copy/paste the results into Excel, like the execution plans.(Some of this information is only available in current SP/CUs of SQL Server 2012/2014, and all 2016.) = 1 – turns on the more-detailed analysis of things like memory grants.Just know that the more queries you analyze, the slower it goes. – by default, we only look at the top 10 queries, but you can use a larger number here like = 50.Just use sp_BlitzCache = ‘reads’ for example. – find the worst queries sorted by reads, CPU, duration, executions, memory grant, or recent compilations. ![]() Download it in our free First Responder Kit.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |