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 Server 2008 R2, wasn’t detecting all available logical processors after Hyperthreading was enabled on the server. The machine in question had 4 sockets with each socket representing a NUMA node and each socket had 10 cores on it -…


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 came across some interesting issues, which I wanted to share for the benefits of my customers. Installation Failure: Scenario: The first time I tried the installation with mount points, the installation failed with the following error – “Wait on…

4

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 performance problems in SQL Server. SQLDiag is a data collection utility, while SQLNexus and PAL tools can be used to analyze data collected by the SQLDiag utility. Ever used the PSSDiag utility that was (and is still) used by Microsoft…

8