up vote 0 down vote favorite
share [g+] share [fb]

I'm trying to run a profiler trace on a server to track any unused databases. I'm seeing connections through 'Audit Login', however for certain active databases there's nothing showing up on the trace.

I've also tried running a trace and making simple queries to each database in attempt to see if the trace captured the connections.

Is there a specific reason as to why this trace isn't picking up the connections?

NOTE: I do not have any filters on 'Audit Login' at all. This is a SQL 2000 server.

Thank you.

link|improve this question
So you have the Security Audit event class selected. I presume you have Sessions ExistingConnection. So even your Query Analyzer sessions to the "unused" databases are not captured? Assume you are not filter yourself out. Another way that I have used is a SQL Agent job with a recurring schedule (5 minutes/15 minutes/ whatever) that executes sp_who2 and captures (appends) the output to a txt file. – jl. Oct 4 '11 at 16:24
Thank you, I enabled Existing Connections and it worked. – Michael Capobianco Oct 4 '11 at 17:06
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.