April 11, 2009 at 5:59 am
Right click master DB of any server and this shows that the Number of Users = 6 in General tab. Is the correct value of no of users? I am sure that this value is not correct because I can get the correc value from perfmon --> sql server: General Statistics ---> No of users. Then why what this value represents? Is this bug? Not sure...
Regards,
MJ
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
April 13, 2009 at 6:45 am
When you look at the properties of any database by right-clicking and selecting properties, the # of users shown is the number of users created in the database (have access to the database), NOT the number of users connected to the database. The Performance counter is the number of users actually connected to the server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply