September 3, 2011 at 10:51 pm
I am using SQL Server 2008 standard. I am creating a trace on all of the databases. I want to log database users and instance logins. I am trying to figure out who uses what databases. I wish I had the enterprise edition.
When I log every single option (using a "blank" templated) the trace file becomes unusably large. All I want to do is learn what applications interface with SQL Server 2008 databases and what users (if any) log in directly to the database. Based on the activity of the databases in the environment I am trying to understand, I need the logging to tracing to last for two full weeks. I know many options wouldn't help me. What options should I choose?
September 4, 2011 at 1:15 am
I wouldn't use the default trace template then, as it gets much more information than it sounds you are looking for. I would start a new trace and deselect every object being traced except for security: login if you just want to know who is logging into your databases. Ensure that you have the domain/username, username, database name and probably dbid fields selected. Note that you will need a trace for every instance that you want information on.
Joie Andrew
"Since 1982"
September 4, 2011 at 6:07 am
And having Enterprise wouldn't change the fact that you need to adjust the trace events to collect only the information you need. Nothing magic there.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply