Dirk G. from MCS Belgium informed me about another hotfix for the TokenAndPermUserStore issue. Build 3179 contains another fix for this cache (the latest build is 3182 by the way). The official description is "The TokenAndPermUserStore cache store may continue to grow steadily and decrease performance...
Reading this and this post reminded me of our very bad experience with the USERSTORE_TOKENPERM cache. When we ran into our USERSTORE_TOKENPERM issue last year there was no real awareness of the problem yet (SQL Server 2005 x64 - Enterprise Edition Build 2153). It was so bad we had to revert to SQL Server...
I once posted some information about the 3GB, AWE and PAE settings. Here is some more detailed information about these settings. Definitely worth reading!
Lately we have been experimenting with the memory options in our tests of a new server. Sometimes it's not quite clear what all those options do, I'll try to give a short and clear description here. /3GB Windows normally allows user mode applications to use 2GB of memory. The switch moves the starting...