The Curious Engineer

All blogs / Databases

Pankaj Mittal [MSFT]

learn.microsoft.com/en-us/archive/blogs/pamitt

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’10’15’20’25
Posts
7 from 6 Nov 2010 to 2 Nov 2011
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/pamitt/feed.xml

2011 3

  1. SQL Server 2005 and 2008 versions may not detect all available processors on a machine with more than 64 logical processors
  2. Considerations with using Mount Points in SQL Server 2008/R2 Failover Clusters
  3. How to use SQLDiag, SQLNexus and PAL tools to analyze performance issues in SQL Server

2010 4

  1. Notes - SQL Server Index Fragmentation, Types and Solutions
  2. Attention events can cause open transactions and blocking in SQL Server
  3. SQL Server 2008 and R2 Cluster Best Practices
  4. Queries with UPDLOCK hints on small tables causing blocking