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...
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...
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...
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...
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...
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...
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...
Date: 11/06/2010