SQL SERVER Resources
|1||Free Tool – DAX Parameter Replacer and Beautifier|
Free online utility to write code
|1||Free online utility to write code|
SQL Server Interview questions and Answers – Free Download
|1||SQL Performance Tuning Articles|
|2||Excellent Collection of T- SQL Puzzles with Multiple Solutions|
|3||SQL Server Interview Questions and Answers|
|4||SSRS Interview Questions and Answers|
Free Microsoft E-Books
|#||Microsoft URL to download Free/Paid E-Books|
|1||Books Set – 1|
|2||Books Set – 2|
|3||Books Set – 3|
Free Videos from Microsoft
|#||Microsoft URL for free videos|
Blogs I follow-
|0||SQLSkills||Kimberley & Paul|
|2||SQL CAT Team||Microsoft|
|3||SQL Query Processing Team||Microsoft|
|4||Solid Q||Itzik Ben-Gan|
|5||Craig Freedman’s SQL Server Blog||Craig F|
|6||Benjamin Nevarez||Benjamin N|
|7||Paul White – SQL Server Performance||Paul W|
|8||Paul White – SQL Blog||Paul W|
|9||MSDN – SQL Server Forum||SQL Server|
|10||MSDN – T-SQL Forum||MSDN – TSQL|
|11||SQLBI||Marco R & Alberto F|
|12||Microsoft Customer Service and Support (CSS) SQL Support Blog||Microsoft|
|13||SQL Server Premier Field Engineer Blog||Microsoft|
|14||Microsoft SQL Server Tips & Tricks blog||Microsoft|
|15||Microsoft SQL Server Blog||Microsoft|
Morgan lee said:
Great info! I recently came across your blog and have been reading along.
I thought I would leave my first comment. I don’t know what to say except that I have
We are running SQL Server 2014 Enterprise Edition hosting Dynamics AX 2012 R3 databases.
We have some overnight batch processes that are running batch updates but we’re often getting blocking with these queries. The batch processes themselves are blocking a system process with a program name of “TASK MANAGER” with 2 open transactions.
This seems to be causing the transaction log to fill up because the transaction log backup is unable to clear down the log.
Having trawled the internet I cannot find a definitive answer as to what the TASK MANAGER process is doing. Some say it’s Change Tracking Cleanup others point to auto stats updates.
Could someone please advise as to what this system process actually does?
Anyways, your efforts are much appreciated.
Thanks a heaps,