Did you ever find a reason for this?

I'm seeing it on my 2008 server, 2008 R2 SQL.

That server has frequent mysterious failovers - I'm wondering if this is a symptom...

Here is my script - it isn't perfect, i wrote it when i was frustrated and wanted to get it out right away, you'll probably want to change it depending...

Oh - thought i included this : sql 2008 r2 sp1 enterprise.

It wasn't so much the connections, as the number of logins happening in such a short amount of time..it seems like a lot for only 427 users, over half an...

What are your wait stats? Are users complaining?

Really, those are the big "it depends" questions.

Are you trying to tune something, or just curious?

i'm seeing this, too - the problem is, we are having i/o issues and this is one of the highest i/o operations going.

One thing to note is that "Auto Update...