共用方式為


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.

SQL Nexus 4.0 Released to codeplex

We have just released SQL Nexus 4.0 (https://sqlnexus.codeplex.com/) which supports latest SQL...

Author: JackLi Date: 03/11/2014

sp_reset_connection – Rate Usage (Don’t fight over the grapes)

Discussions surrounding sp_reset_connection behavior and usage come up all the time and over the...

Author: psssql Date: 03/03/2014

Can’t Connect to SQL when provisioning a Project App in SharePoint

The customers issue was that they were trying to provision a Project site within the Project...

Author: Adam W. Saxton Date: 02/07/2014

As The World Turns: SQL Server NUMA Memory Node and the Operating System Proximity

It felt a bit like ‘As The World Turns’ as I unraveled how the following worked so the title is a...

Author: psssql Date: 02/04/2014

Spatial Index is NOT used when SUBQUERY used

I have found the following link to be invaluable when working with and tuning SQL Server Spatial...

Author: psssql Date: 12/09/2013

How Simple Parameterization works

Recently we got a customer who upgraded from SQL Server 2005 to 2008. But their performance degraded...

Author: JackLi Date: 12/04/2013

Kerberos Configuration Manager updated for Reporting Services

Back in may, we released the Kerberos Configuration Manager tool to help with diagnosing and...

Author: Adam W. Saxton Date: 11/22/2013

Spatial Indexing: From 4 Days to 4 Hours

Over the past month I have been involved in the optimization of a Spatial Index...

Author: psssql Date: 11/19/2013

All about RollbackSnapshotTempDB...

I’ve been recently involved in several cases where Databases named RollbackSnapshotTempDB...

Author: psssql Date: 11/07/2013

Cumulative Update 2 to the RML Utilities for Microsoft SQL Server Released

  Version 9.04.004 of the RML Utilities for Microsoft SQL Server has been released.  This...

Author: psssql Date: 10/29/2013

SQL Connection Pool Timeout Debugging

This is a follow up to two blog posts from back in 2009 which talked about leaked connections. In...

Author: Adam W. Saxton Date: 10/22/2013

Every time I ‘ATTACH DATABASE’ SQL logs error 1314 for SetFileIoOverlappedRange

Turns out this is an issue in the SQL Server code and the error is a bit noisy during attach...

Author: psssql Date: 10/16/2013

Microsoft CSS @ PASS Summit 2013

During October 15th-18th, the US PASS Summit 2013 will be held in Charlotte, NC at the Charlotte...

Author: Adam W. Saxton Date: 10/10/2013

Invalid or loopback address when configuring SharePoint against a SQL Server

I was presented with a connectivity issue when trying to configure SharePoint 2013 using a CTP build...

Author: Adam W. Saxton Date: 10/04/2013

Error during installation of an SQL server Failover Cluster Instance

A common issue I've run into while helping with SQL Server Failover Cluster (FCI) installations is...

Author: psssql Date: 09/30/2013

How It Works: Maximizing Max Degree Of Parallelism (MAXDOP)

I was working on an index build issue for an 80 CPU system and kept seeing that only 64 CPUs were...

Author: psssql Date: 09/27/2013

Interpreting the counter values from sys.dm_os_performance_counters

The performance counters exposed by SQL Server are invaluable tools for monitoring various aspects...

Author: psssql Date: 09/23/2013

[SQL 2012 query plan enhancement] I want to know why my query is not parallelized

In the past, we have got repeated questions from customers on why a particular query is not...

Author: JackLi Date: 08/28/2013

When is throttling in Windows Azure SQL Database really throttling….

During the course of this year I have spoken at several customer and internal events on...

Author: psssql Date: 08/27/2013

Service status watcher in SQL Server Management Studio – How it works

Have you ever wondered about the mechanism using which SQL Server Management Studio(SSMS) - Object...

Author: psssql Date: 08/21/2013

Power View display issues with Page Viewer Web Part

I ran into two separate issues this week that both dealt with displaying a Power View report through...

Author: psssql Date: 08/16/2013

Optimizing partition split when the partition is not empty

Some of our Field Engineers, Kal Yella and Denzil Ribeiro (@DenzilRibeiro) have posted a blog that...

Author: psssql Date: 08/13/2013

How It Works: SQL Server 2012 Database Engine Task Scheduling

Over the years the SQL Server scheduling algorithms have been documented in various...

Author: psssql Date: 08/13/2013

Error trying to access SharePoint List from Power Query

When trying to pull data from a SharePoint List Data Source, using the Microsoft Online Services ID,...

Author: Adam W. Saxton Date: 08/08/2013

After applying Service Pack 1 for SQL Server 2012 you may encounter a known issue! Details inside…..

I’d like to make you aware of an issue that may occur after installing Service Pack 1 for SQL...

Author: psssql Date: 07/31/2013

Tracking down Power View Performance Problems

The scenario was that we saw sluggishness on the initial load of a Power View Report and also when...

Author: Adam W. Saxton Date: 07/29/2013

When Does sp_prepare Return Metadata

I was running an RML Utilities Suite test pass and encountered varying behavior from our sp_prepare...

Author: psssql Date: 07/23/2013

DReplay Message: “Active connections exceed 8192, connection 8409 is waiting.”

This message was an interesting dive into the DReplay, session boundary logic that I thought I would...

Author: psssql Date: 07/23/2013

High CPU Troubleshooting with DMV Queries

High CPU Troubleshooting with DMV Queries [View:https://www.youtube.com/watch?v=eDOTzeut4lw]...

Author: psssql Date: 06/17/2013

A performance issue involving CLR garbage collection and SQL CPU affinity setting

We have been troubleshooting a customer’s case and uncovered a GC behavior with SQL Server CPU...

Author: JackLi Date: 06/11/2013

Getting a SharePoint List Data Source to work with Reporting Services Native Mode

A case came up where the user was trying to use Report Builder in a Reporting Services instance that...

Author: Adam W. Saxton Date: 06/11/2013

How It Works: The I/O Path: SQL Server Running in Windows Azure Virtual Machine (IaaS)

Note: This blog is based on behavior as of June 2013.  At Microsoft we continue to evolve and...

Author: psssql Date: 06/03/2013

Why won't my PowerPivot for Excel 2010 workbook upgrade to Excel 2013?

Recently we've seen an issue where some Excel 2010 workbooks containing PowerPivot models encounter...

Author: psssql Date: 05/23/2013

SharePoint Adventures : Claims, Named Pipes and Kerberos

I ran into a new Kerberos Scenario that I hadn’t hit before when I was working on the cases related...

Author: Adam W. Saxton Date: 05/17/2013

SharePoint Adventures : When connectivity is not connectivity

I’m always amazed that issues usually come in batches.  I was looped into a few cases that had...

Author: Adam W. Saxton Date: 05/17/2013

SQL Server–Storage Spaces/VHDx and 4K Sector Size

This blog outlines a new twist to my previous blog outlining issues with 4K sector sizes. SQL Server...

Author: psssql Date: 05/15/2013

Using PowerShell to discover Reporting Services 2012 in SharePoint

I was recently going through an exercise of documenting how to discover certain aspects of Reporting...

Author: Adam W. Saxton Date: 04/30/2013

AlwaysON - HADRON Learning Series: lock_redo_blocked/redo worker Blocked on Secondary Replica

The topic I received most in my inbox this week was redo blocked on a secondary while attempting to...

Author: psssql Date: 04/26/2013

AlwaysON - HADRON Learning Series: HADR_SYNC_COMMIT vs WRITELOG wait

The distinction between these two wait types is subtle but very helpful in tuning your Always On...

Author: psssql Date: 04/26/2013

How It Works: Always On–When Is My Secondary Failover Ready?

I keep running into the question: “When will my secondary allow automatic failover?”  ...

Author: psssql Date: 04/22/2013

SQLIOSim Checksum Validations

I had a very specific question asked of me related to the SQLIOSIM.exe, checksum validation...

Author: psssql Date: 04/05/2013

The Case of Anti-Virus filter drive interference with File Stream Restore

"Denzil and I were working on this issue for a customer and Denzil has been gracious enough to...

Author: psssql Date: 03/29/2013

PowerPivot Table Import Wizard cannot find provider

The data source provider list in PowerPivot can often be a source of confusion for users since they...

Author: psssql Date: 03/25/2013

System Center Advisor is now free

It has been well over a year when I wrote a series of blog posts about a product called System...

Author: psssql Date: 03/20/2013

SQL Server 2012 partitioned table statistics update behavior change when rebuilding index

In this blog, I will talk about a couple of things related to statistics update when rebuilding...

Author: JackLi Date: 03/19/2013

switchoffset built-in function can cause incorrect cardinality estimate

Recently, we received a call from a customer reported that a query was slow.  Upon further...

Author: JackLi Date: 03/02/2013

Temp table caching improvement for table valued parameters in SQL Server 2012

I wanted to point out a nice performance improvement related to table valued parameters (TVP) in SQL...

Author: JackLi Date: 02/26/2013

Unable to register .NET framework assembly not in the supported list

SQL Server has supported CLR usage since version 2005. But support of .NET framework assemblies...

Author: JackLi Date: 02/23/2013

RS: Database Engine does not meet edition requirements

I've ran across the following error a few times and thought I would post this out there for people...

Author: Adam W. Saxton Date: 02/20/2013

Breaking Down 18056

We have had two blog posts on this blog regarding the 18056 error. Two from Bob Dorr (and part 2)...

Author: Adam W. Saxton Date: 02/13/2013

<Previous Next>