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 |
|
Jaybee from his castle
Yak Posting Veteran
64 Posts |
 Posted - 2006-05-14 : 07:54:47
|
| What info should a SQL Server Audit contain? --------------------------------------------------------------------------------That is to say, from a management perspective? I've been asked to provide one, as I'm the first DBA there ever, but I'm not sure what depth of info they want. And, does anyoe have scripts that can perform the audit, or an actual example audit?I'd imagine an audit should encompass the following:Database names;Database sizes;Location and size of data/temp/log etc. files;Hardware specs (cpu/memory/disk sizes);Number of logins;User applications.I'm sure that's only the tip of the iceberg, I'd be grateful for your input!Thanks in advance,Jaybee. |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2006-05-14 : 11:45:54
|
| 2 things we pay attention to here which you can get through Profiler are number of concurrent users and average exec time for our stored procedures. I think a lot of it depends on who is asking for the audit and what they want to do with the info. That might be more info than they care about.Mike"oh, that monkey is going to pay" |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-05-14 : 14:27:52
|
| http://www.sql-server-performance.com/articles_audit.asphttp://www.sqlsecurity.com/FAQs/SQLSecurityChecklist/tabid/57/Default.aspxAlso, use the Best Practices Analyzer from Microsoft, which is a free download. This will give you a great start. Create an "Executive Summary" that summarizes the analysis into an English paragraph format with a recommended actions and needed actions section following each grouping. They'll love you for it.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
What info should a SQL Server Audit contain?