Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server 2008 R2 login auditing

Status
Not open for further replies.
RRinTetons

RRinTetons

IS-IT--Management
Jul 4, 2001
333
0
0
US
I have a client running a database on SQL Server 2008 R2 Standard. They are very concerned about processing power on the server box, and want to set up long-term auditing of logins. What is the lightest impact method to do that? Can a trace or Profiler session be set up from another server? Does that do anything to reduce the load on the primary server? How would log files be viewed? It doesn't seem that xEvents are fully implemented on 2008, is that true? Any suggestions for free or very inexpensive tools would help with this?

-
Richard Ray
Developer, Data Analyst
Jackson Hole, WY
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SQL Server in Windows
Replies
1
Views
115
pjw001
pjw001
CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
93
CodeWell
CodeWell
Ikatiemarie
  • Locked
  • Question
SQL Server 2008 SP_Send_dbmail
Replies
0
Views
168
Ikatiemarie
Ikatiemarie
bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
88
dhookom
dhookom
JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
61
JScannell
JScannell

Part and Inventory Search

Sponsor

Back
Top