SQL Server 2000 logo

The curious case of RESOURCE_SEMAPHORE

A customer is running in a SQL Server 2000 environment, 32-bit AWE mode, on 64-bit Windows 2003 R2. The server has 16GB of RAM and 8 logical CPU cores. It’s running under VMWare. Storage is provided via a (slow) SAN. SQL Server has ~12GB of RAM assigned to it. During monitoring of long-running queries, we
-> Continue reading The curious case of RESOURCE_SEMAPHORE