• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1324
  • Last Modified:

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?

  • 2
2 Solutions
Aneesh RetnakaranDatabase AdministratorCommented:
> Of these hosts, 30 are local connections of the Windows, probably of
> the ASP. Its normal?
I think From IIS you can identify the no of connections to the website..
Aneesh RetnakaranDatabase AdministratorCommented:
regarding the processor status we have the statuses like running, sleeping, runnable, and background
sleeping :  Waiting on a disk I/O, or some other resource. Probably indicates a process that is running, but doing extensive disk I/O
runnable: In the queue of runnable processes
running : Actively running
background : A process, such as a system procedure, run by the Server rather than by a user process

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now