forked from ktaranov/sqlserver-kit
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSQL_Server_Defaults.sql
More file actions
161 lines (161 loc) · 17.2 KB
/
Copy pathSQL_Server_Defaults.sql
File metadata and controls
161 lines (161 loc) · 17.2 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
WITH CTE_Defaults (ObjectName, AppliesToObjectType, SettingTypeName, SettingName, ConfiguredValue) AS (
SELECT 'Global', 'Analysis Services', 'Analysis Services', 'Collect Memory by Category Data', 'No' UNION
SELECT 'Global', 'Analysis Services', 'Analysis Services', 'Maintenance Window Enabled', 'No' UNION
SELECT 'Global', 'Analysis Services', 'Analysis Services', 'Maintenance Window Name', 'None' UNION
SELECT 'Global', 'Analysis Services', 'Analysis Services', 'Synchronization Threshold', '0.00:30:00' UNION
SELECT 'Global', 'Analysis Services', 'Analysis Services', 'Synchronization Type', 'Don''t synchronize automatically.' UNION
SELECT 'Global', 'Analysis Services', 'Top Commands Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'Analysis Services', 'Top Commands Source', 'Collect MDX/DMX/XMLA Events', 'Yes' UNION
SELECT 'Global', 'Analysis Services', 'Top Commands Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'Analysis Services', 'Top Commands Source', 'Minimum Duration', '0.00:00:01' UNION
SELECT 'Global', 'Analysis Services', 'Top Commands Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'Analytics Platform System', 'Analytics Platform System', 'Maintenance Window Enabled', 'No' UNION
SELECT 'Global', 'Analytics Platform System', 'Analytics Platform System', 'Maintenance Window Name', 'None' UNION
SELECT 'Global', 'APS', 'APS Distributed Queries Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'APS', 'APS Distributed Queries Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'APS', 'APS Distributed Queries Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'APS', 'APS Health Alerts Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'APS', 'APS Health Alerts Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'APS', 'APS Health Alerts Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'APS', 'APS Loader Backup Runs Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'APS', 'APS Loader Backup Runs Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'APS', 'APS Loader Backup Runs Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'APS Distributed Queries', 'APS Distributed Queries', 'Maximum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'APS Distributed Queries', 'APS Distributed Queries', 'Maximum Runtime Threshold Percent', '250%' UNION
SELECT 'Global', 'APS Distributed Queries', 'APS Distributed Queries', 'Minimum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'APS Distributed Queries', 'APS Distributed Queries', 'Minimum Runtime Threshold Percent', '10%' UNION
SELECT 'Global', 'APS Loader Backup Run', 'APS Loader Backup Run', 'Maximum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'APS Loader Backup Run', 'APS Loader Backup Run', 'Maximum Runtime Threshold Percent', '250%' UNION
SELECT 'Global', 'APS Loader Backup Run', 'APS Loader Backup Run', 'Minimum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'APS Loader Backup Run', 'APS Loader Backup Run', 'Minimum Runtime Threshold Percent', '10%' UNION
SELECT 'Global', 'Azure SQL Data Warehouse', 'Azure SQL Data Warehouse', 'Maintenance Window Enabled', 'No' UNION
SELECT 'Global', 'Azure SQL Data Warehouse', 'Azure SQL Data Warehouse', 'Maintenance Window Name', 'None' UNION
SELECT 'Global', 'Azure SQL Data Warehouse', 'Azure SQL Data Warehouse Distributed Queries Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'Azure SQL Data Warehouse', 'Azure SQL Data Warehouse Distributed Queries Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'Azure SQL Data Warehouse', 'Azure SQL Data Warehouse Distributed Queries Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'Azure SQL Data Warehouse', 'Azure SQL Data Warehouse Loader Backup Runs Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'Azure SQL Data Warehouse', 'Azure SQL Data Warehouse Loader Backup Runs Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'Azure SQL Data Warehouse', 'Azure SQL Data Warehouse Loader Backup Runs Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'Azure SQL Data Warehouse Distributed Queries', 'Azure SQL Data Warehouse Distributed Queries', 'Maximum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Azure SQL Data Warehouse Distributed Queries', 'Azure SQL Data Warehouse Distributed Queries', 'Maximum Runtime Threshold Percent', '250%' UNION
SELECT 'Global', 'Azure SQL Data Warehouse Distributed Queries', 'Azure SQL Data Warehouse Distributed Queries', 'Minimum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Azure SQL Data Warehouse Distributed Queries', 'Azure SQL Data Warehouse Distributed Queries', 'Minimum Runtime Threshold Percent', '10%' UNION
SELECT 'Global', 'Azure SQL Data Warehouse Loader Backup Run', 'Azure SQL Data Warehouse Loader Backup Run', 'Maximum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Azure SQL Data Warehouse Loader Backup Run', 'Azure SQL Data Warehouse Loader Backup Run', 'Maximum Runtime Threshold Percent', '250%' UNION
SELECT 'Global', 'Azure SQL Data Warehouse Loader Backup Run', 'Azure SQL Data Warehouse Loader Backup Run', 'Minimum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Azure SQL Data Warehouse Loader Backup Run', 'Azure SQL Data Warehouse Loader Backup Run', 'Minimum Runtime Threshold Percent', '10%' UNION
SELECT 'Global', 'Azure SQL Database', 'Azure SQL Database', 'Maintenance Window Enabled', 'No' UNION
SELECT 'Global', 'Azure SQL Database', 'Azure SQL Database', 'Maintenance Window Name', 'None' UNION
SELECT 'Global', 'Azure SQL Database', 'Top SQL Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'Azure SQL Database', 'Top SQL Source', 'Collect Batch and RPC Events', 'No' UNION
SELECT 'Global', 'Azure SQL Database', 'Top SQL Source', 'Collect Statement Events', 'No' UNION
SELECT 'Global', 'Azure SQL Database', 'Top SQL Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'Azure SQL Database', 'Top SQL Source', 'Minimum CPU', '0' UNION
SELECT 'Global', 'Azure SQL Database', 'Top SQL Source', 'Minimum Duration', '0.00:00:05' UNION
SELECT 'Global', 'Azure SQL Database', 'Top SQL Source', 'Minimum Reads', '0' UNION
SELECT 'Global', 'Azure SQL Database', 'Top SQL Source', 'Minimum Writes', '0' UNION
SELECT 'Global', 'Azure SQL Database', 'Top SQL Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'Blocking SQL', 'Blocking SQL', 'Maximum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Blocking SQL', 'Blocking SQL', 'Maximum Runtime Threshold Percent', '250%' UNION
SELECT 'Global', 'Blocking SQL', 'Blocking SQL', 'Minimum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Blocking SQL', 'Blocking SQL', 'Minimum Runtime Threshold Percent', '10%' UNION
SELECT 'Global', 'Database', 'Databases Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'Database', 'Databases Source', 'Collect Buffer Data when Buffer > 8GB', 'False' UNION
SELECT 'Global', 'Database', 'Databases Source', 'Max Index Size (MB) to Collect Fragmentation Data', '50000' UNION
SELECT 'Global', 'Database', 'Databases Source', 'Max Partitions to Collect per Database', '500' UNION
SELECT 'Global', 'Database', 'Databases Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'Database', 'Databases Source', 'Min Index Size (MB) to Collect Fragmentation Data', '10' UNION
SELECT 'Global', 'Database', 'Databases Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Enable Index Defragmentation', 'False' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Fragmentation Scan Mode', 'Limited' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'MAXDOP', '0' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Maximum Concurrent Defrag Operations', '1' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Maximum Duration', '0.02:00:00' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Maximum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Maximum Runtime Threshold Percent', '250%' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Minimum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Minimum Runtime Threshold Percent', '10%' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Partitions', 'All' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Rebuild Threshold %', '30' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Reorg Threshold %', '10' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Run Post-defrag Analysis', 'True' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Schedule', '<not specified>' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Sort in tempdb', 'False' UNION
SELECT 'Global', 'Index', 'Index Defragmentation', 'Use Online Rebuild', 'True' UNION
SELECT 'Global', 'Reporting Services Report', 'Reporting Services Report', 'Maximum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Reporting Services Report', 'Reporting Services Report', 'Maximum Runtime Threshold Percent', '250%' UNION
SELECT 'Global', 'Reporting Services Report', 'Reporting Services Report', 'Minimum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Reporting Services Report', 'Reporting Services Report', 'Minimum Runtime Threshold Percent', '10%' UNION
SELECT 'Global', 'SQL Server', 'Blocking SQL Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'SQL Server', 'Blocking SQL Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'SQL Server', 'Blocking SQL Source', 'Minimum Block Duration', '0.00:00:15' UNION
SELECT 'Global', 'SQL Server', 'Blocking SQL Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'SQL Server', 'Deadlocks Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'SQL Server', 'Deadlocks Source', 'Collect Deadlock Events', 'Yes' UNION
SELECT 'Global', 'SQL Server', 'Deadlocks Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'SQL Server', 'Deadlocks Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'SQL Server', 'Maintenance Plans Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'SQL Server', 'Maintenance Plans Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'SQL Server', 'Maintenance Plans Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'SQL Server', 'Reporting Services Reports Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'SQL Server', 'Reporting Services Reports Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'SQL Server', 'Reporting Services Reports Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'SQL Server', 'SQL Server', 'Auto-enable SQL Server Agent Tokens', 'Yes' UNION
SELECT 'Global', 'SQL Server', 'SQL Server', 'Auto-recycle Large SQL Server Agent Logs', 'No' UNION
SELECT 'Global', 'SQL Server', 'SQL Server', 'Maintenance Window Enabled', 'No' UNION
SELECT 'Global', 'SQL Server', 'SQL Server', 'Maintenance Window Name', 'None' UNION
SELECT 'Global', 'SQL Server', 'SQL Server', 'Max Databases to Synchronize (largest first)', '100' UNION
SELECT 'Global', 'SQL Server', 'SQL Server', 'Maximum Queue Length', '5' UNION
SELECT 'Global', 'SQL Server', 'SQL Server', 'Synchronization Threshold', '0.00:30:00' UNION
SELECT 'Global', 'SQL Server', 'SQL Server', 'Synchronization Type', 'Don''t synchronize automatically.' UNION
SELECT 'Global', 'SQL Server', 'SQL Server Agent Alerts Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'SQL Server', 'SQL Server Agent Alerts Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'SQL Server', 'SQL Server Agent Alerts Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'SQL Server', 'SQL Server Agent Jobs Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'SQL Server', 'SQL Server Agent Jobs Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'SQL Server', 'SQL Server Agent Jobs Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'SQL Server', 'SQL Server Agent Log Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'SQL Server', 'SQL Server Agent Log Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'SQL Server', 'SQL Server Agent Log Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'SQL Server', 'Top SQL Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'SQL Server', 'Top SQL Source', 'Collect Batch and RPC Events', 'Yes' UNION
SELECT 'Global', 'SQL Server', 'Top SQL Source', 'Collect Statement Events', 'Yes' UNION
SELECT 'Global', 'SQL Server', 'Top SQL Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'SQL Server', 'Top SQL Source', 'Minimum CPU', '0' UNION
SELECT 'Global', 'SQL Server', 'Top SQL Source', 'Minimum Duration', '0.00:00:05' UNION
SELECT 'Global', 'SQL Server', 'Top SQL Source', 'Minimum Reads', '0' UNION
SELECT 'Global', 'SQL Server', 'Top SQL Source', 'Minimum Writes', '0' UNION
SELECT 'Global', 'SQL Server', 'Top SQL Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'SQL Server Agent Job', 'SQL Server Agent Job', 'Auto-start Threshold', '0.04:00:00' UNION
SELECT 'Global', 'SQL Server Agent Job', 'SQL Server Agent Job', 'Auto-start Threshold Enabled', 'No' UNION
SELECT 'Global', 'SQL Server Agent Job', 'SQL Server Agent Job', 'Auto-start Type', 'Use default setting.' UNION
SELECT 'Global', 'SQL Server Agent Job', 'SQL Server Agent Job', 'Behavior When Queued', 'Never Queue.' UNION
SELECT 'Global', 'SQL Server Agent Job', 'SQL Server Agent Job', 'Behavior When Queuing', 'Never Queue.' UNION
SELECT 'Global', 'SQL Server Agent Job', 'SQL Server Agent Job', 'Maximum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'SQL Server Agent Job', 'SQL Server Agent Job', 'Maximum Runtime Threshold Percent', '250%' UNION
SELECT 'Global', 'SQL Server Agent Job', 'SQL Server Agent Job', 'Minimum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'SQL Server Agent Job', 'SQL Server Agent Job', 'Minimum Runtime Threshold Percent', '10%' UNION
SELECT 'Global', 'SQL Server Agent Job', 'SQL Server Agent Job', 'Queue For', '0.00:30:00' UNION
SELECT 'Global', 'SQL Server Agent Job', 'SQL Server Agent Job', 'Queue Others For', '0.00:30:00' UNION
SELECT 'Global', 'Top Commands', 'Top Commands', 'Maximum Runtime Threshold', '0.01:00:00' UNION
SELECT 'Global', 'Top Commands', 'Top Commands', 'Maximum Runtime Threshold Percent', '250%' UNION
SELECT 'Global', 'Top Commands', 'Top Commands', 'Minimum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Top Commands', 'Top Commands', 'Minimum Runtime Threshold Percent', '10%' UNION
SELECT 'Global', 'Top SQL', 'Top SQL', 'Maximum Runtime Threshold', '0.01:00:00' UNION
SELECT 'Global', 'Top SQL', 'Top SQL', 'Maximum Runtime Threshold Percent', '250%' UNION
SELECT 'Global', 'Top SQL', 'Top SQL', 'Minimum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Top SQL', 'Top SQL', 'Minimum Runtime Threshold Percent', '10%' UNION
SELECT 'Global', 'Windows', 'Windows Event Logs Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'Windows', 'Windows Event Logs Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'Windows', 'Windows Event Logs Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'Windows', 'Windows Tasks Source', 'Auto-Watch New Objects', 'Yes' UNION
SELECT 'Global', 'Windows', 'Windows Tasks Source', 'Maximum Rows To Synchronize', '5000' UNION
SELECT 'Global', 'Windows', 'Windows Tasks Source', 'Missed Run Wait Time', '0.00:05:00' UNION
SELECT 'Global', 'Windows Computer', 'Windows Computer', 'Maintenance Window Enabled', 'No' UNION
SELECT 'Global', 'Windows Computer', 'Windows Computer', 'Maintenance Window Name', 'None' UNION
SELECT 'Global', 'Windows Task', 'Windows Task', 'Maximum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Windows Task', 'Windows Task', 'Maximum Runtime Threshold Percent', '250%' UNION
SELECT 'Global', 'Windows Task', 'Windows Task', 'Minimum Runtime Threshold', '0.00:00:00' UNION
SELECT 'Global', 'Windows Task', 'Windows Task', 'Minimum Runtime Threshold Percent', '10%'
)
SELECT * FROM CTE_Defaults;