felipesch
asked on
SP_WHO2 & Performance
I have a small database, and when I execute a procedure SP_WHO2, I receive some results:
Average of conections on the database: 200
Hosts conected: 50
Of these hosts, 30 are local connections of the Windows, probably of the ASP. Its normal?
Other thing its the most conecctions are STATUS=SLEEPING. Its normal?
Thanks,
Average of conections on the database: 200
Hosts conected: 50
Of these hosts, 30 are local connections of the Windows, probably of the ASP. Its normal?
Other thing its the most conecctions are STATUS=SLEEPING. Its normal?
Thanks,
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.