I checked out the MSDN article on that setting; it certainly looks promising for our current environment.

Checking on raw numbers from our plan cache, grouping by distinct usecounts:

Total plans: 28,376

usecount = 1: 21,682 (76%)

I think this makes a strong case for using the "optimize for ad hoc workloads" setting as you suggest.

Thanks for your help.

~ Jeff