Ms sql who2 biography

This article shows the usage of sp_who2.

Ms sql who2 biography template

To diagnose system slowdowns, see (Troubleshooting SQL Slowness).

One of the first lines of defense in determining the causes of database slowdowns is to use sp_who2. sp_who2 shows all the sessions that are currently established in the database.

These are denoted as SPID‘s, or Server process Id’s. Running sp_who2 is easy, all that is required is to type sp_who2 and execute it, however it’s a good idea to call it with EXEC.

[cc lang=”sql”]
EXEC sp_who2
[/cc]

The first 50 results are system SPIDs.

Generally these do not effect slowdowns of the system.

Ms sql who2 biography

These system events include the Checkpoint writer, Log writers and task schedulers. User processes are SPID numbers 50 and over. In diagnosing slowdowns it is these SPIDs that are the potential resource hogs.

sp_who2 also takes a optional parameter of a SPID.

If a spid is passed, then the results of sp_who2 only show the row