In our shop we have a SQL Agent job running hourly that performs a count of how many distinct users are connected (sysprocesses) to each database on each server of interest and writes the date, hour of day, and user count to a table. We analyze that data periodically to ensure licensing compliance, but we also look to see how many users are connected to each db at different times of the day to help ensure that we have sufficient hardware resources employed.