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

indicating that...

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...