4/15/2023 0 Comments Turn off spell check sql sever![]() Here’s some common wait types and how to get more information about ’em: Start with your top wait type, and work your way down. Step 2: Review what your top wait type means. ![]() There’s more info on how to do that on the documentation page, but for a quick performance check, we’re just going to start here. This is a prioritized list of what your SQL Server queries have been waiting on – but it is indeed all queries since startup, which includes jobs like backups, index rebuilds, CHECKDB, etc. In a perfect world, you’d want to log it to a table, and trend it over time. It returns a lot of other stuff – for info on that, hit the documentation page. We’re going to focus only on this first result set. Here’s the first set of results: sp_BlitzFirst = 1
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |