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,34 +25,3 @@
25	25	@Execute = 'Y',
26	26	@LogToTable = 'Y'
27	27	{{/code}}
28		-
29		-== Unused indexes ==
30		-
31		-{{code language="sql"}}
32		-
33		-SELECT
34		- objects.name AS Table_name,
35		- indexes.name AS Index_name,
36		- dm_db_index_usage_stats.user_seeks,
37		- dm_db_index_usage_stats.user_scans,
38		- dm_db_index_usage_stats.user_updates
39		-FROM
40		- sys.dm_db_index_usage_stats
41		- INNER JOIN sys.objects ON dm_db_index_usage_stats.OBJECT_ID = objects.OBJECT_ID
42		- 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
43		-WHERE
44		- indexes.is_primary_key = 0 --This line excludes primary key constarint
45		- AND
46		- indexes. is_unique = 0 --This line excludes unique key constarint
47		- AND
48		- dm_db_index_usage_stats.user_updates <> 0 -- This line excludes indexes SQL Server hasn’t done any work with
49		- AND
50		- dm_db_index_usage_stats.user_lookups = 0
51		- AND
52		- dm_db_index_usage_stats.user_seeks = 0
53		- AND
54		- dm_db_index_usage_stats.user_scans = 0
55		-ORDER BY
56		- dm_db_index_usage_stats.user_updates DESC
57		-
58		-{{/code}}