Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Statistics based on SP_Who results

Author  Topic  CanadaDBA 583 Posts Posted - 2005-02-23 : 09:08:42 If a scheduled job saves the result of sp_who into a table, then what is the best query criteria to find out how many user connection were to a specific database during a specific time? What are the meaning of "running", "sleeping", and "background"? Is it good idea to go based on hostname? Totally, is this a good approach? Canada DBA