Solving SQL Connectivity issues: A new guided walk through just got published

We recently published a new document that provides a one stop shop for solving majority of connectivity issues that you may run into when working with SQL Server. This can be accessed here: Solving Connectivity errors to SQL Server In addition to providing a quick checklist of items that you can go through, the doc…

8

Pssdiag & Sqldiag Manager update

We are releasing a new version of Pssdiag & Sqldiag Manager which supports SQL Server 2016.   It was originally published on https://diagmanager.codeplex.com. But we just moved it to github under Microsoft organization repo. New location is at https://github.com/Microsoft/DiagManager.  In the “Releases” tab, you can download latest binaries.   Go to getting started wiki to learn how…

1

Why can’t I get a parallel plan when rebuilding my index?

In support, we frequently have customers who call us and want to find out why a particular query doesn’t use parallelism.  Recently, we had a user who wanted to know why his index rebuild didn’t use parallelism.  In some cases, NonParallelPlanReason in query plan tells you the reason.  But in this case, the query plan…

3