Recently, one of my client who works for the large bank accidentally set incorrect max worker count, which lead to big performance problem.
Question received via email: The question was about is there any way to know how many rows each thread execute in parallel operations.
Recently, while working with the customer who had a Memory issue, we ended up talking about Clean Pages and Dirty Pages Count.
Question: How Much Memory is in Locked Pages? Answer: Before we see the answer to this question, I suggest you read the blog post here first.
Question: How to List All Memory Optimized Tables in SQL Server? We will see two different scripts here: One for Database and Second for Tables.
Question: When was Table Accessed Last By User?