How to Grow All Files in a File Group Equally? – TRACE FLAG 1117 – Interview Question of the Week #201

Question: How to Grow All Files in a File Group Equally?

Answer: If you are a regular reader of this blog, you would have read my earlier blog post writing about this subject over here: SQL Server 2016 – Introducing AutoGrow and Mixed_Page_Allocations Options – TraceFlags. However, let us try to get an answer to our question in this blog.

Read More

SQL SERVER- High CPU and Transaction Type WorkFileGroup_fake_worktable and Workfile

As a part of my  SQL Server Performance Tuning and Optimization consultancy, I face interesting situations and every time I am able to resolve them. This was one of the more interesting ones where I was not getting any hint from the internet. Since it was a new thing to me, I am sharing it via this blog. In this blog, we would learn about the cause of WorkFileGroup_fake_worktable and Workfile.

Read More