Microsoft® SQL Server® 2012 Bible

967 CHAPTER 42 SQL Audit IN THIS CHAPTER Confi guring SQL Audit Tracking Server Events S QL Audit was fi rst introduced with SQL ...

968 Part VII: Monitoring and Auditing ■ (^) Both Server Audit Specifi cations and Database Audit Specifi cations can defi ne set ...

969 Chapter 42: SQL Audit 42 FIGURE 42-1 Use the Create Audit dialog to defi ne SLQ Server Audit objects, which collect events d ...

970 Part VII: Monitoring and Auditing is reached and an action causes a new audit event to be recorded, the action that caused t ...

971 Chapter 42: SQL Audit 42 Enabling/Disabling the Audit Object Explorer’s SQL Server Audit node visually indicates whether the ...

972 Part VII: Monitoring and Auditing FIGURE 42-2 Creating a new Server Audit Specifi cation using Management Studio. Creating w ...

973 Chapter 42: SQL Audit 42 Modifying Server Audit Specifi cations You can add New Action Audit Types to the Server Audit Speci ...

974 Part VII: Monitoring and Auditing Viewing the Audit Trail The easiest way to view the audit trail is to select the SQL Serve ...

975 Chapter 42: SQL Audit 42 to continue with other auditing technologies such as tracing or triggers for compliance and monitor ...

c42.indd 976c42.indd 976 7/31/2012 10:17:50 AM7/31/2012 10:17:50 AM http://www.it-ebooks.info ...

977 CHAPTER 43 Management Data Warehouse IN THIS CHAPTER Using the MDW Confi guring MDW Viewing MDW Reports Creating Custom Data ...

978 Part VII: Monitoring and Auditing In the past, it required a large effort to gather the necessary metrics and necessary sta- ...

979 Chapter 43: Management Data Warehouse 43 FIGURE 43-1 Confi gure Management Data Warehouse context menu. FIGURE 43-2 Confi gu ...

980 Part VII: Monitoring and Auditing FIGURE 43-3 Select Confi guration Task screen. FIGURE 43-4 Confi gure Management Data Ware ...

981 Chapter 43: Management Data Warehouse 43 FIGURE 43-5 Map Logins and Users screen. Select one or more logins, and assign the ...

982 Part VII: Monitoring and Auditing FIGURE 43-6 Complete the Wizard screen. FIGURE 43-7 Confi guration success. c43.indd 982c4 ...

983 Chapter 43: Management Data Warehouse 43 Setting Up Data Collection After you confi gure the Management Data Warehouse colle ...

984 Part VII: Monitoring and Auditing FIGURE 43-9 Storage confi guration screen. FIGURE 43-10 Confi guration summary. c43.indd 9 ...

985 Chapter 43: Management Data Warehouse 43 You have successfully completed confi guring MDW and a Data Collection component. V ...

986 Part VII: Monitoring and Auditing Disk Usage Summary The Disk Usage Summary report shows the starting size, current size, av ...