actually, I want built a Template to monitor the user connection count to the CUBE. so I can not use perfmon..

Thank you Jacob. I already followed your 1st step. But still I was searching here. Thank you everyone for a great discussion.

1) The client actually means "connections to...

Thank you All.

But the requirement is to get the active user connections to SQL tables in a Database, like we have active user connections to SQL DB, using...

Thank you Gail for your time. I know Users connects to database but this was a client requirement  so I am trying. 
Anyway Thank you so much.

I want to see how many user connected to a SQL server table at any point of time. I need only user count not the user list.

Thank you all, but is there any way to differentiate user connections to Table ?

Excellent scripts it helped me to fix the Memory Bottleneck.

Thanx..

this is production system.... I have to run the script on Sunday .... as scheduled .

Let me check...

Thank you,

The job is running since 3 years,,, last 2 weeks it got failed. Nothing has been changed compare to earlier.

some body suggested to delete and recreate the job.. actually,...

yes.

There is no limit for Max server Memory,. Lock page is not yet configured... If next time it happens , I will do it..

Thank you.

Thanks for the reply.

Yesterday it happened... SQL was not allowed any new connections..but it was showing 99 % CPU usage by SQL.

we restarted the server ... and server is back....

Thank you for the reply.

Yes I am trying to connect using SSMS and with the full server name. some times it won't allow us to connect.

But after the reboot...

Can somebody have any idea to resolve the above issue permanently. again I received the same alert as above today.

I have the same Issue. I did all the above steps,

but when I run the Job 'Agent history clean up : Distribution' .. the log file is growing rapidly.

What can...