Useage testing (each database %)

  •  

    I am looking at one large clustered production box, with a couple dozen databases on it - each with a hundred or so tables on it, and a few tables have at least 3 million rows.

    The boss says, "which one are we using the most, and can you give me a statistical breakdown of each?"

    I am not sure a script exists for such, and I may end up having to pull a very large profiler trace in to find this out.  Not really sure though.

    Nor can I abuse this box much, as it is THE production box so no locks/timeouts need to happen from me. 

    Where should I look for answers?  I have Googled, and BOL'd and read, but I am not seeing what I want.  What am I missing?

  • I'm not sure what your trying to find by saying "Which one are we using the most."

    Which application using which db is being used the most?

    You can, and probably should just set up a profiler trace that shows hits to the server, make sure to add the Database id to the columns returned. the db id is found in the master database in table sysdatabases

    Set results to a table, then you can query the table you want to show your statistics.

    Other than physical attributes obout hte database, I don't know how you can figure out which is used the most without recording the usage thru profiler.

  • Database id will do it.  I just checked, and thanks.

     

    Studdy

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply