0

I want to set up some auditing and monitoring jobs on my production servers, but my knowledge of SQL Server is limited, so I wanted to reach out and ask you what are the things that you audit and things that you monitor at your own job. Thanks.

A SQL DBA
  • 1
  • 1
  • It is a big topic for discussion. Start by researching this topic first and then ask targeted questions. – Alex Jul 13 '17 at 02:07
  • With all due respect I disagree. I asked people to list what they are auditing/monitoring. I didn't ask them what is auditing/monitoring, why do it, how to do it, etc. – A SQL DBA Jul 14 '17 at 18:41
  • This site is not a discussion forum (see: https://stackoverflow.com/help/dont-ask) but a Q&A. I was suggesting that you ask a targeted question along the lines of: "My circumstance is Y. I will audit Z. Not sure about X? Anything else you would recommend?" – Alex Jul 14 '17 at 23:06
  • Alex, here's the question: Q: What auditing jobs do you have at work? I would like to set up the same. How is this a discussion, am I missing something? – A SQL DBA Jul 17 '17 at 17:31

2 Answers2

0

You can check out the Recommended Reports and Alerts Designs for LOGbinder for SQL Server from Randy Smith. Although it is product specific to LOGbinder, you can easily translate it using the SQL Audit Events List.

Tom
  • 105
  • 8
-1

For sql server auditing, you can checkout the following article to set up and use the feature

SQL Server Audit How-to Topics

technet.microsoft.com/en-us/library/cc280505(v=sql.105).aspx

SQL Server Audit

technet.microsoft.com/en-us/library/cc280386(v=sql.110).aspx

Additionally, you can also try this automated solution which easily accomplish this task

Joel barlow
  • 101
  • 1
  • Welcome to Stack Overflow! Whilst this may theoretically answer the question, [it would be preferable](//meta.stackoverflow.com/q/8259) to include the essential parts of the answer here, and provide the link for reference. – Takarii Jul 13 '17 at 10:39
  • Hi Joel, thanks, but I didn't ask what is auditing. I just wanted to find out what are the other companies auditing/monitoring, that's all. – A SQL DBA Jul 14 '17 at 18:42