Pankaj Mittal [MSFT]

SQL Server 2005 and 2008 versions may not detect all available processors on a machine with more than 64 logical processors

Scenario: I came across this scenario recently where a SQL Server 2005 instance installed on Windows...

Author: Pankaj Mittal Date: 11/02/2011

Considerations with using Mount Points in SQL Server 2008/R2 Failover Clusters

Recently I was testing with using Mount Point in SQL Server 2008 failover cluster installation and...

Author: Pankaj Mittal Date: 10/29/2011

How to use SQLDiag, SQLNexus and PAL tools to analyze performance issues in SQL Server

SQLDiag, SQLNexus and PAL (Performance Analysis of Logs) tools can collectively be used to analyze...

Author: Pankaj Mittal Date: 02/25/2011

Notes - SQL Server Index Fragmentation, Types and Solutions

This is the first in the series of blog posts that I plan on writing to summarize various topics of...

Author: Pankaj Mittal Date: 12/23/2010

Attention events can cause open transactions and blocking in SQL Server

Wondering what causes Attention events in a SQL server Profiler trace and how these events can...

Author: Pankaj Mittal Date: 11/07/2010

SQL Server 2008 and R2 Cluster Best Practices

I have been working with several of my customers recently helping them install and/or review a new...

Author: Pankaj Mittal Date: 11/06/2010

Queries with UPDLOCK hints on small tables causing blocking

While working with one our ISV customer’s in Microsoft performance testing labs recently, we...

Author: Pankaj Mittal Date: 11/06/2010