Viewing 15 posts - 1 through 15 (of 51 total)
actually, I want built a Template to monitor the user connection count to the CUBE. so I can not use perfmon..
June 22, 2017 at 9:51 am
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...
June 7, 2017 at 11:21 am
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...
June 6, 2017 at 12:16 pm
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.
June 6, 2017 at 9:38 am
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.
June 6, 2017 at 5:27 am
Thank you all, but is there any way to differentiate user connections to Table ?
June 6, 2017 at 1:54 am
Excellent scripts it helped me to fix the Memory Bottleneck.
Thanx..
October 18, 2013 at 4:03 am
this is production system.... I have to run the script on Sunday .... as scheduled .
Let me check...
September 13, 2013 at 4:38 am
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,...
September 13, 2013 at 12:27 am
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.
July 14, 2013 at 8:37 pm
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....
July 12, 2013 at 6:40 am
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...
July 9, 2013 at 10:12 pm
Can somebody have any idea to resolve the above issue permanently. again I received the same alert as above today.
June 3, 2013 at 7:15 am
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...
September 25, 2012 at 7:29 am
Viewing 15 posts - 1 through 15 (of 51 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy