Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -1,4 +1,4 @@
1		-{{toc/}}
	1	+
2	2
3	3
4	4	Install these scripts from the maintenance package at [[https:~~/~~/ola.hallengren.com/>>https://ola.hallengren.com/]]
...	...	@@ -7,11 +7,10 @@
7	7	1. [[CommandLog.sql>>https://github.com/olahallengren/sql-server-maintenance-solution/blob/master/CommandLog.sql]]
8	8	1. [[IndexOptimize.sql>>https://github.com/olahallengren/sql-server-maintenance-solution/blob/master/IndexOptimize.sql]]
9	9
	10	+
10	10	Documentation for the index maintenance methods can be found here: [[SQL Server Index and Statistics Maintenance (hallengren.com)>>url:https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html]]
11	11
12	12
13		-== Fragmented Index & Statistics ==
14		-
15	15	{{code language="sql"}}
16	16	EXECUTE dbo.IndexOptimize
17	17	@Databases = 'Everest_PreProd',
...	...	@@ -25,36 +25,3 @@
25	25	@Execute = 'Y',
26	26	@LogToTable = 'Y'
27	27	{{/code}}
28		-
29		-== Unused indexes ==
30		-
31		-{{code language="sql"}}
32		-
33		---// https://wiki.ebsphere.africa/xwiki/bin/view/Technical%20Documentation/analysis/sql-performance/index-maintenance/#
34		-SELECT
35		- schema_name(objects.schema_id) schema_name,
36		- objects.name AS Table_name,
37		- indexes.name AS Index_name,
38		- dm_db_index_usage_stats.user_seeks,
39		- dm_db_index_usage_stats.user_scans,
40		- dm_db_index_usage_stats.user_updates
41		-FROM
42		- sys.dm_db_index_usage_stats
43		- INNER JOIN sys.objects ON dm_db_index_usage_stats.OBJECT_ID = objects.OBJECT_ID
44		- INNER JOIN sys.indexes ON indexes.index_id = dm_db_index_usage_stats.index_id AND dm_db_index_usage_stats.OBJECT_ID = indexes.OBJECT_ID
45		-WHERE
46		- indexes.is_primary_key = 0 --This line excludes primary key constarint
47		- AND
48		- indexes.is_unique = 0 --This line excludes unique key constarint
49		- AND
50		- dm_db_index_usage_stats.user_updates <> 0 -- This line excludes indexes SQL Server hasn’t done any work with
51		- AND
52		- dm_db_index_usage_stats.user_lookups = 0
53		- AND
54		- dm_db_index_usage_stats.user_seeks = 0
55		- AND
56		- dm_db_index_usage_stats.user_scans = 0
57		-ORDER BY
58		- dm_db_index_usage_stats.user_updates DESC
59		-
60		-{{/code}}