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

Get database usage report

I am looking for information on database usage.

1) Number of requests made to database in past two months (on date basis)
for example, 1/1/2014 - 100 requests made, 2/1/2014 - 94 and so on

2) also I am looking for info on number of unique usernames this from request was made from

Any script I can use to query this information?

database is hosted on SQL server 2008
2 Solutions
Anthony PerkinsCommented:
If you are not logging these requests in some form or fashion, you are to put it bluntly SOL.
Scott PletcherSenior DBACommented:
SQL Server does not by default keep a file or table of database connections.  It would be huge overhead that most people would never use.

Therefore, if you need that type of info, you must put something into place to capture that info into a file or table.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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