<p>I need to get a log of user access to our <code>SQL Server</code> so I can track <strong>average</strong> and <strong>peak concurrency usage</strong>. Is there a hidden table or something I'm missing that has this information for me? To my knowledge the application I'm looking at does not track this at the application level.</p>

<p>I'm currently working on <code>SQL Server 2000</code>, but will moving to <code>SQL Server 2005</code> shortly, so solutions for both are greatly appreciated.</p>

[{'answer_id': 5914, 'author': 'Bryan Roth', 'author_id': 299, 'author_profile': 'https://Stackoverflow.com/users/299', 'pm_score': 4, 'selected': True, 'text': '<p>In SQL Server 2005, go to tree view on the left and select Server (name of the actual server) > Management > Activity Monitor.  Hope this helps.</p>\n'}, {'answer_id': 5917, 'author': 'SQLMenace', 'author_id': 740, 'author_profile': 'https://Stackoverflow.com/users/740', 'pm_score': 3, 'selected': False, 'text': "<ul>\n<li>on <code>2000</code> you can use <code>sp_who2</code> or the <code>dbo.sysprocesses</code> system table</li>\n<li>on <code>2005</code> take a look at the <code>sys.dm_exec_sessions</code> DMV</li>\n</ul>\n\n<p>Below is an example</p>\n\n<pre><code>SELECT COUNT(*) AS StatusCount,CASE status \nWHEN 'Running' THEN 'Running - Currently running one or more requests' \nWHEN 'Sleeping ' THEN 'Sleeping - Currently running no requests' \nELSE 'Dormant – Session is in prelogin state' END status \nFROM sys.dm_exec_sessions \nGROUP BY status\n</code></pre>\n"}]
['https://Stackoverflow.com/questions/5908', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/71/']