In general, keeping auto update statistics is a good idea. There is a good article that you should read. The article discusses how autostats work and also discusses...

Shawn, where did you find the information regarding SQL Server 2000 on Windows Server 2003 ? I believe you still have to turn on AWE in SQL Server to...

Hi All,

Thanks for the advice. I guess there is really no shortcut :), practice , practice and practice.

Aemon

Yih-Yoon Lee

lee@yihyoon.com

Waittype of resource_semaphore indicates a wait on memory grant. Here is an article that may be related.

http://support.microsoft.com/?id=309256

If there were SPIDs waiting on Resource_Semaphore, this is a symptom...

Hi Steven,

What kind of information are you looking for? As the article explains, the message is new to service pack 3a for SQL Server 2000 to help troubleshoot issues...