Professional Association for SQL Server SQL Server 2012
- Slides: 35
Professional Association for SQL Server Аудит в SQL Server 2012 Князев Алексей Екатеринбург East. Wind MVP, MCTS, MCITP
T-SQL Стек выполнения (дополнительная информация в аудите) Select Speaker, City from dbo. Speaker 24 PASS exec dbo. Get_Speaker Audit Log dbo. Speaker 24 PASS
Professional Association for SQL Server Демонстрация T-SQL Стек выполнения
Пользовательские события аудита exec sp_audit_write 1234, 1, N‘Hello World’ @user_defined_event_id @succeeded @user_defined_info Audit Log
Professional Association for SQL Server Демонстрация Аудит с фильтром
Производительность Аудита • Зависит от: – Рабочей нагрузки – Того, что отслеживаем • Сравнение аудита SQL Server с SQL Trace для 5 разных типичных рабочих нагрузок у клиентов. . . • • • Workload 1 Workload 2 Workload 3 11 dbs, ranging • from 1. 94 MB to 1812. 5 MB. 755 tables with • average of 2761 rows 1, 219, 234 stmts • executed. 2 dbs ranging • from 64 MB to 423. 88 MB 35 tables with • average of 49, 141 rows 1, 633, 557 stmts executed • 3 dbs ranging from 1. 94 MB to 1059. 63 MB 154 tables with average of 586 rows, Here is the activity 585, 400 stmts executed • • • Workload 4 Workload 5 1 db at 3235. 75 • MB 84 tables with • average of 144, 245 rows 3, 435, 303 stmts • executed. 1 db at 174. 94 MB 152 tables with average of 4, 108 rows 296, 642 stmts executed.
SQL Server Audit vs SQL Trace Customer Workload Performance Base Time (minutes) SQL Trace (minutes) 101. 9 SQL Server Audit (minutes) 76. 6 63. 4 55. 9 68. 1 41. 3 13. 3 15. 9 14. 1 Workload 1 5. 1 6. 3 5. 6 Workload 2 Workload 3 3. 6 4. 78 Workload 4 4 Workload 5
Professional Association for SQL Server Демонстрация Использование Аудита совместно с политиками (Policy-Based Management)
Ресурсы • www. t-sql. ru – мой блог • Books Online: – Security Enhancements (Database Engine), http: //msdn. microsoft. com/en-us/library/cc 645578(v=sql. 110). aspx – SQL Server Audit (Database Engine), http: //msdn. microsoft. com/en -us/library/cc 280386(v=SQL. 110). aspx • Whitepaper: – Auditing in SQL Server 2008, us/library/dd 392015(v=SQL. 100). aspx http: //msdn. microsoft. com/en- • SQL Server Security Forum: – http: //social. msdn. microsoft. com/forums/en-US/sqlsecurity/threads/ • SQL Security Blog: – http: //blogs. msdn. com/b/sqlsecurity/
Professional Association for SQL Server Аудит в SQL Server 2012 Князев Алексей Екатеринбург East. Wind MVP, MCTS, MCITP
- Professional association of sql server
- Sql server parallel data warehouse
- Sql server analysis services 2012
- Server management studio express
- Dts packages in sql server 2016
- Sql server 2012 express
- Mcitp sql 2012
- Remote desktop virtualization host role server 2012
- Windows multipoint server 2012
- Windows server 2012 r2 essentials
- Eol windows server 2012
- Ts easy print
- Windows server 2012 essentials launchpad download
- Professional association of georgia educators
- Julia creider
- Professional petroleum data management association
- New york state professional firefighters association
- Professional risk managers international association
- Massachusetts association for professional law enforcement
- Logical operators in pl sql
- Iso 22301 utbildning
- Novell typiska drag
- Nationell inriktning för artificiell intelligens
- Vad står k.r.å.k.a.n för
- Shingelfrisyren
- En lathund för arbete med kontinuitetshantering
- Särskild löneskatt för pensionskostnader
- Tidböcker
- Sura för anatom
- Vad är densitet
- Datorkunskap för nybörjare
- Stig kerman
- Hur skriver man en tes
- Delegerande ledarskap
- Nyckelkompetenser för livslångt lärande
- Påbyggnader för flakfordon