Calculate_nonunique_nonclustered_index_size.xlsx

	A	B	C	E
1	Step 1		http://msdn.microsoft.com/en-us/library/ms190620.aspx	Estimate the Size of a Nonclustered Index - SQL Server \| Microsoft Learn
2	1
3	num_rows	100
4	2
5	num_key_cols	0
6	fixed_key_size	0
7	num_variable_key_cols	0
8	max_var_key_size	0
9	3
10	num_key_cols	0
11	fixed_key_size	0
12	num_variable_key_cols	0
13	max_var_key_size	0
14	4
15	index_null_bitmap	0
16	5
17	variable_key_size	0
18	6
19	index_row_size	7
20	7
21	index_rows_per_page	899
22
23	Step 2
24	1
25	num_included_cols	0
26	num_leaf_cols	0
27	fixed_included_size	0
28	fixed_leaf_size	0
29	num_variable_leaf_cols	6
30	max_var_included_size	0
31	max_var_leaf_size	0
32	2
33	n/a - applies only if non clustered index is unique
34	3
35	leaf_null_bitmap	2
36	4
37	variable_leaf_size	14
38	5
39	leaf_row_size	23
40	6
41	leaf_rows_per_page	323
42	7
43	fill factor in %	100
44	free_rows_per_page	0
45	8
46	num_leaf_pages	0.3095975232
47	9
48	leaf_space_used	2536.22291
49
50	Step 3
51	non-leaf levels	0
52	2
53	num_index_pages	0.0003447633884	This formula may need editing: at the moment, it assumes 3 non-leaf levels. For two non leaf levels use =(B46/(B21^2))+(B46/(B21)), for four non-leaf levels use =(B46/B21^4)+(B46/B21^3)+(B46/(B21^2))+(B46/(B21))
54	3
55	index_space_used	2.824301678
56
57	Step 4
58	nonclustered index size(bytes)	2539.047212
59	nonclustered index size (MB)	0.002421424114
60	nonclustered index size (GB)	0.000002364671986
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