Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.