What Is Optimizer Timeout? SQL Server uses a cost-based query optimizer. Therefore, it selects a...

https://docs.microsoft.com/archive/blogs/psssql/understanding-optimizer-timeout-and-how-complex-queries-can-be-affected-in-sql-server

What Is Optimizer Timeout? SQL Server uses a cost-based query optimizer. Therefore, it selects a query plan with the lowest cost after it has built and examined multiple query plans. One of the objectives of the SQL Server query optimizer (QO) is to spend a "reasonable time" in query optimization as compared to query execution....

https://blogs.msdn.microsoft.com/psssql/2018/10/19/understanding-optimizer-timeout-and-how-complex-queries-can-be-affected-in-sql-server/

I wrote an article to discuss about data movement latency between AG...

https://docs.microsoft.com/archive/blogs/psssql/aglatency-report-tool-introduction

I wrote an article to discuss about data movement latency between AG groups: Troubleshooting data movement latency between synchronous-commit AlwaysOn Availability Groups Now I develop a tool to analyze AG log block movement latency between replicas and create report accordingly. You can download it here: https://github.com/suyouquan/AGLatency/releases/download/V1.0/AGLatencyV1.01.zip Video: https://github.com/suyouquan/AGLatency/blob/master/AGLatency.mp4 You capture log block Xevent trace from both primary...

https://blogs.msdn.microsoft.com/psssql/2018/09/08/aglatency-report-tool-introduction/

We have recently become aware of a regression in one of the TCP/IP functions that manages the TCP...

https://docs.microsoft.com/archive/blogs/psssql/july-10-2018-windows-updates-cause-sql-startup-issues-due-to-tcp-port-is-already-in-use-errors

We have recently become aware of a regression in one of the TCP/IP functions that manages the TCP port pool which was introduced in the July 10, 2018 Windows updates for Windows 7/Server 2008 R2 and Windows 8.1/Server 2012 R2. This regression may cause the restart of the SQL Server service to fail with the...

https://blogs.msdn.microsoft.com/psssql/2018/07/26/july-10-2018-windows-updates-cause-sql-startup-issues-due-to-tcp-port-is-already-in-use-errors/

Writer: Simon Su Technical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah  Problem...

https://docs.microsoft.com/archive/blogs/psssql/lesson-learned-from-an-availability-group-performance-case

Writer: Simon Su Technical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah  Problem description  One of my customers implemented a very high workload synchronous AG (Availability Group) solution and he needs 10k transactions/sec in AG databases. With the in-memory technology, this 10K/sec goal was achieved but they found a very strange behavior in transaction processing of...

https://blogs.msdn.microsoft.com/psssql/2018/04/05/lesson-learned-from-an-availability-group-performance-case/

Writer: Simon Su Technical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah    Scheduling and...

https://docs.microsoft.com/archive/blogs/psssql/troubleshooting-sql-server-scheduling-and-yielding

Writer: Simon Su Technical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah Applies to: SQL...

https://docs.microsoft.com/archive/blogs/psssql/troubleshooting-data-movement-latency-between-synchronous-commit-always-on-availability-groups

Dear all, Depending on which products were installed on the server beforehand, a SQL Server 2017...

https://docs.microsoft.com/archive/blogs/psssql/installation-of-sql-server-2017-failing-with-vs-shell-installation-has-failed-with-exit-code-1638

This post is intended to shed some light around uniqueifiers and table design that rely on its...

https://docs.microsoft.com/archive/blogs/psssql/uniqueifier-considerations-and-error-666

You may want to know what registry keys will be added to system for a SQL server installation. If...

https://docs.microsoft.com/archive/blogs/psssql/sql-setup-toolsuite-introduction-3-sql-registry-viewer

Oftentimes when I worked on a setup case I hope I have a simple tool to tell me the detailed...

https://docs.microsoft.com/archive/blogs/psssql/sql-setup-toolsuite-introduction-2-product-browser