CSS SQL Server Engineers
This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services team.
What Is Optimizer Timeout? SQL Server uses a cost-based query optimizer. Therefore, it selects a...
Date: 10/19/2018
I wrote an article to discuss about data movement latency between AG groups:...
Date: 09/08/2018
We have recently become aware of a regression in one of the TCP/IP functions that manages the TCP...
Date: 07/26/2018
Writer: Simon Su Technical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah Problem description...
Date: 04/05/2018
Writer: Simon Su Technical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah Applies to: SQL Server...
Date: 04/05/2018
Dear all, Depending on which products were installed on the server beforehand, a SQL Server 2017...
Date: 03/26/2018
This post is intended to shed some light around uniqueifiers and table design that rely on its...
Date: 02/16/2018
You may want to know what registry keys will be added to system for a SQL server installation. If...
Date: 01/24/2018
Oftentimes when I worked on a setup case I hope I have a simple tool to tell me the detailed...
Date: 01/24/2018
If you have encountered missing cached MSI/MSP issues during SQL server setup, you may have knew...
Date: 01/24/2018
Starting with SQL Server 2005, a self-signed certificate is created automatically during the startup...
Date: 11/08/2017
On a Windows based server, when all the available memory including the page file is consumed, the...
Date: 10/17/2017
Greetings. It feels like a lot of change is in the air! Last Friday marked the Autumnal equinox....
Date: 09/29/2017
With codeplex shutting down, we have moved SQL Nexus to github with a new release (6.0). Now both...
Date: 07/26/2017
SQL Server : large RAM and DB Checkpointing Hi everyone, This post’s purpose is to establish a...
Date: 06/29/2017
Recently we got an inquiry from a customer who received the following message in errorlog and wanted...
Date: 06/07/2017
Recently I assisted on a customer issue where customer wasn’t able to alter a memory optimized table...
Date: 05/10/2017
In a previous blog, I talked about memory optimized table consumes memory until end of the batch. In...
Date: 05/10/2017
I worked on an interesting issue today where a user couldn’t restore a backup. Here is what this...
Date: 04/12/2017
Recently, I looked an In-Memory OLTP issue with Principal Software Engineer Bob Dorr who is still my...
Date: 03/06/2017
In this blog Added per-operator level performance stats for Query Processing, Senior PM in QP talks...
Date: 02/28/2017
In blog “Importance of choosing correct bucket count of hash indexes on a memory optimized table”, I...
Date: 02/22/2017
I was working with a customer to troubleshoot memory optimized table issues. In this scenario, our...
Date: 02/18/2017
We recently published a new document that provides a one stop shop for solving majority of...
Date: 01/29/2017
We are releasing a new version of Pssdiag & Sqldiag Manager which supports SQL Server 2016. It...
Date: 01/12/2017
In support, we frequently have customers who call us and want to find out why a particular query...
Date: 01/09/2017
When it comes to troubleshooting, the more you know the better troubleshooter you are (in my...
Date: 12/04/2016
We just released SQL Nexus 5.5.0.1 on codeplex. In addition to numerous ‘rules’ that catch issues...
Date: 11/20/2016
A user called in for help because he wasn’t able to drop a user from a database. The error message...
Date: 11/15/2016
There are multiple levels of throttling with Azure. You can get throttled at disk level, storage...
Date: 10/25/2016
Recently we got a call from customer who was trying to enable stretch database but repeatedly got...
Date: 10/18/2016
Lately, we had a customer who contacted us for a performance issue where their server performed much...
Date: 10/04/2016
With so many users new to Azure, Sometimes an issue appears more complex than it really is. If you...
Date: 09/29/2016
If you created an SQL Server VM via azure portal, there will be a section called “SQL Server...
Date: 09/28/2016
If you need to open up your SQL Server on an Azure VM to public internet access, you need to look no...
Date: 09/18/2016
Recently we got a customer who called in and wanted to know why he received NULL for query_plan when...
Date: 07/13/2016
In the past few weeks, I saw this error come across quite a bit and thought I will provide an...
Date: 07/09/2016
While we have documentation on how to create a VM from captured image under “How to capture a...
Date: 07/06/2016
In SQL Server 2012 SP3, we made supportability improvements in the memory grant space. One of the...
Date: 06/09/2016
Bob Ward and Bob Dorr are among the founding members of PSSSQL as long standing SQL Server support...
Date: 06/07/2016
SQL Server 2016 improves the XEvent Linq reader scalability and performance. The XEvent UI in SQL...
Date: 05/18/2016
SQL Server leverages MSDTC for distributed transactions (begin distributed transaction, remote proc...
Date: 05/12/2016
SQL Server leverages a worker pool for the In-Memory Optimized Database capabilities. Prior to SQL...
Date: 05/10/2016
The SQL Server 2016, AlwaysOn, log transport takes advantage of hardware based encryption to...
Date: 05/05/2016
SQL Server 2016 introduces two distinct changes in the AlwaysOn transport, compression design....
Date: 05/03/2016
The AlwaysOn log transport uses a SQL Broker-like based design to send and receive messages between...
Date: 04/28/2016
SQL Server 2016 enhanced the bulk insert activities (BULK INSERT), leveraging the CPUs vector...
Date: 04/27/2016
SQL Server's Column Store feature is designed to accommodate large amounts of data and associated...
Date: 04/22/2016
Recently I worked with a customer who noticed that several sessions[spid’s] in their SQL Server was...
Date: 04/19/2016