SQL Server – Missing Performance Counters: A consolidated list of known issues

Technorati Tags: Performance Counter Missing SQL Server performance counters missing!! Past few hours been crazy one, breaking my head on a ‘Missing Performance Counters’ and now since this is resolved, I want to now off-load every bit of this issue from my brain so thought blogging it 🙂 Issue: A customer is having 24×7 PERFMON…

1

Index usage by %Like% operator – Query Tuning

Ok, so this one is interesting. I was reading an Internal DL (Distribution Group) post on tuning %Like% operator performance. I find some confusion in various places about index selectivity of ‘%Like%’ operator, and I decided to do few test myself. Hopefully test details below can help a bit: Problem Statement: – While optimizing high…

2

How To: Improve SQL Server Management Studio Start-up Time

Hi Friends, Here’s something interesting about Management Studio 2005 (SSMS) When you launch SQL Server Management Studio 2005 on the server, it takes a couple of minutes (more than 5 mins in some case) before it  starts up and another few minutes to connect. And, you observe from Task Manager that, there are sufficient (Memory…

1

Lock Pages in Memory in SQL Server 64-Bit

Hello All, Well after a long time of no writing, I finally found an interesting topic and also some time to write.   Lately, I’ve encountered couple of instances of Troubleshooting Memory Pressure on SQL Server 2005 64-Bit version. Doing some basic configuration check, one realizes that ‘Lock Pages in Memory’ Operating System Privilege is…

6