Sysadmin fast , user logins slow

Question

Sysadmin fast , user logins slow

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

There's more options than that in the section in the book chapter, especially if you're on SQL 2008... Also, have you checked the cache size, confirmed the wait type, etc?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

SQLRNNR (1/9/2012)
Continue to monitor CMEMTHREAD over time and watch how fast it grows.

CMEMTHREAD is the name of the wait type, not the cache. The cache name is TokenAndPermUserStore.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

GilaMonster (1/9/2012)
SQLRNNR (1/9/2012)
Continue to monitor CMEMTHREAD over time and watch how fast it grows.
CMEMTHREAD is the name of the wait type, not the cache. The cache name is TokenAndPermUserStore.

Yeah - I realized that after I posted. Slap my hands for trying to multi-task

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events