Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_server_dba
Posting Yak Master
167 Posts |
 Posted - 2011-05-14 : 11:42:39
|
| WE have 10 SQL Server 2005 servers and currently we have a database in each and every server and audit all the server activity(user logins, ddl's, dml's and everything.) but in future we will be upgrading to 2008 r2 and can any one suggest me the best way to audit the server activities? Is there a way that we can have a centralized server which can store the activities for all the servers? |
|
|
yuval14
Starting Member
3 Posts |
Posted - 2011-05-16 : 15:39:49
|
Hi,The only realistic solution that I found until now is to use external SIEM system to gather the required audit.You can use C2 audit or SQL 2008 Enterprise/Developer advanced logging, but this allow you to save the gathered Data into: Application Event Log, Security Event Log, File. So, if you don’t plan to add external SIEM system (e.g. SQL compliance manager - Idera etc.) ,you may need to use the same solution (with optional advanced logging).Yuval Sinayquote:
Originally posted by sql_server_dba
WE have 10 SQL Server 2005 servers and currently we have a database in each and every server and audit all the server activity(user logins, ddl's, dml's and everything.) but in future we will be upgrading to 2008 r2 and can any one suggest me the best way to audit the server activities? Is there a way that we can have a centralized server which can store the activities for all the servers?
|
 |
|
|
stipen4
Starting Member
3 Posts |
Posted - 2011-05-17 : 08:22:34
|
| Hi friendServers are often dedicated, meaning that they perform no other tasks besides their server tasks. On multiprocessing operating systems, however, a single computer can execute several programs at once. A server in this case could refer to the program that is managing resources rather than the entire computer.http://www.servercircle.comstipen4 |
|
|
|
|
|
|
|
|
SQL Server Auditing