Hi,
I checked out the pinned tables in BOL. There was a warning saying large tables should not be pinned. I know 50,000 users table is not large, but it is the largest in our database. Do you advice pinning the user table?
You said data pages may be dropping out of cache? Can we increase the cache memory to be used by sql server?