Tham khảo tài liệu 'pro sql server 2008 policy-based management- p6', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | APPENDIX MICROSOFT SQL SERVER BEST PRACTICE POLICIES Windows Event Log I O Delay Warning I O Delay Warning Check Server Windows Event Log I O Error During Hard Page Fault Error I O Error During Hard Page Fault Error Check Server Windows Event Log Read Retry Error Read Retry Error Check Server Windows Event Log Storage System I O Timeout Error Storage System I O Timeout Error Check Server Windows Event Log System Failure Error System Failure Error Check Server 233 Index Symbols SQLHelp how SQLHelp works 210 A accessing database see database access Active Directory s Group Policy 1 ActiveX script job steps CmdExec Rights Secured policy 216 Address field Description page Create New Policy dialog 20 administrative accounts Builtin Administrators login 197 disabling sa login 197 security access to 196-198 advanced conditions creating 40-44 Advanced Edit dialog creating advanced conditions 41 42 creating conditions 15 Data Purity Flag Check condition 163 Database Free Space policy 150 SQL Server Agent Is Running condition 158 159 Advisory Services Microsoft 213 affinity mask SQL Server policies 222 223 Against Targets field General page Create New Policy dialog 18 Alert System page SQL Server Agent Properties dialog 118 alerts 11 configuring SQL Server Agent alerts 120- 124 creating for all policy violations 125 ALTER DATABASE command enabling Service Broker 110 Analyzer rules best practice importing policies 24 27 architecture PBM 134-136 Asymmetric Key Encryption Algorithm policy 202 215 230 asynchronous processing On Change Log Only evaluation mode 135 auditing servers best practice audit policies 206 compliance 202-206 default trace 204-206 login auditing 203-204 SQL Server Audit 203 SQL Server Default Trace policy 206 autoclose Database Auto Close policy 167 217 autogrow Database Free Space policy 150 File Growth for SQL Server 2000 policy 220 autoshrink Database Auto Shrink policy 50 167 168 217 evaluating single policy on demand 50 B Backup and Data File Location
