The orion database is running on SQL2008 Standard 64bit. The volume containing the database files is the source to the high disk queue. The other 8 volumes rarely have more than 3.00 disk queue within an hour
.
245 rows in the Orion database are 50% frag pecentage but majority are in mid 70 to mid 90%. The Orion maintenance plan kicks off at night and I reviewed the swmainteancedebug log file to ensure of that. 'dbm-defragmentation-enabled%' has the value 1.
Just an example output:
Orion 2125505 UDT_IPAddressCurrent 1 PK_UDT_IPAddressCurrent 74.3589743589744 CLUSTERED INDEX
Orion 2125505 UDT_IPAddressCurrent 2 IX_UDT_IPAddressCurrent_ID 44.4444444444444 NONCLUSTERED INDEX
Orion 2125505 UDT_IPAddressCurrent 3 IX_UDT_IPAddressCurrent_IPAddress 81.0126582278481 NONCLUSTERED INDEX
Orion 2125505 UDT_IPAddressCurrent 4 IX_UDT_IPAddressCurrent_RouterPortID 81.4285714285714 NONCLUSTERED INDEX
Orion 50125676 UDT_IPAddressHistory 3 IX_UDT_IPAddressHistory_FirstSeen 61.4628820960699 NONCLUSTERED INDEX
Orion 50125676 UDT_IPAddressHistory 4 IX_UDT_IPAddressHistory_EndpointID 69.2210259658011 NONCLUSTERED INDEX
Orion 50125676 UDT_IPAddressHistory 5 IX_UDT_IPAddressHistory_IPAddress 55.5468135326514 NONCLUSTERED INDEX
Orion 66211848 NodeIPAddresses 1 IX_NodeIPAddresses_NodeID 90 CLUSTERED INDEX
Orion 82211905 NodeL2Connections 1 IX_NodeL2Connections_NodeID 93.1034482758621 CLUSTERED INDEX
Orion 98211962 NodeL3Entries 1 IX_NodeL3Entries_NodeID 78.7878787878788 CLUSTERED INDEX
Orion 112545082 NetFlowDetail_404_1516159 1 IX_NetFlowDetail_StartTime 66.6666666666667 CLUSTERED INDEX
Orion 114125904 UDT_PortToEndpointCounts 1 PK_UDT_PortToEndpointCounts 66.6666666666667 CLUSTERED INDEX
Orion 114212019 NodePortInterfaceMap 1 IX_NodePortInterfaceMap_NodeID 90.4761904761905 CLUSTERED INDEX
Orion 130212076 NodeSettings 1 IX_NodeSettings_NodeID 85.7142857142857 CLUSTERED INDEX
Orion 144545196 NetFlowDetail_323_1516159 1 IX_NetFlowDetail_StartTime 66.6666666666667 CLUSTERED INDEX
Orion 146126018 UDT_PortToEndpointCurrent 1 PK_UDT_PortToEndpointCurrent 91.304347826087 CLUSTERED INDEX
Orion 146126018 UDT_PortToEndpointCurrent 2 IX_UDT_PortToEndpointCurrent_EndpointID 93.3333333333333 NONCLUSTERED INDEX
Orion 146212133 NodeVlans 1 IX_NodeVlans_NodeID 91.6666666666667 CLUSTERED INDEX
Orion 160545253 NetFlowDetail_333_1516159 1 IX_NetFlowDetail_StartTime 75 CLUSTERED INDEX
Orion 160545253 NetFlowDetail_333_1516159 2 IX_NetFlowDetail_SourceIPSort 50 NONCLUSTERED INDEX
Orion 160545253 NetFlowDetail_333_1516159 3 IX_NetFlowDetail_DestIPSort 50 NONCLUSTERED INDEX
Orion 176545310 NetFlowDetail_334_1516159 1 IX_NetFlowDetail_StartTime 66.6666666666667 CLUSTERED INDEX
Orion 176545310 NetFlowDetail_334_1516159 2 IX_NetFlowDetail_SourceIPSort 50 NONCLUSTERED INDEX
Orion 176545310 NetFlowDetail_334_1516159 3 IX_NetFlowDetail_DestIPSort 50 NONCLUSTERED INDEX
Orion 210126246 UDT_PortToPortCurrent 1 PK_UDT_PortToPortCurrent 96.875 CLUSTERED INDEX
Orion 240545538 NetFlowDetail_329_1516159 1 IX_NetFlowDetail_StartTime 50 CLUSTERED INDEX
Orion 248344255 UDT_Job 1 PK_UDT_Job 75 CLUSTERED INDEX
Orion 248344255 UDT_Job 2 IX_UDT_Job_JobID 66.6666666666667 NONCLUSTERED INDEX
Orion 256545595 NetFlowDetail_330_1516159 1 IX_NetFlowDetail_StartTime 50 CLUSTERED INDEX
Orion 272545652 NetFlowDetail_340_1516159 1 IX_NetFlowDetail_StartTime 50 CLUSTERED INDEX
Orion 274126474 UDT_UserToIPAddressCurrent 1 PK_UDT_UserToIPAddressCurrent 87.5 CLUSTERED INDEX
Orion 274126474 UDT_UserToIPAddressCurrent 2 IX_UDT_UserToIPAddressCurrent_IPAddress 83.3333333333333 NONCLUSTERED INDEX
Orion 288368442 APM_ApplicationStatus_Daily 1 PK_APM_ApplicationStatus_Daily 73.3333333333333 CLUSTERED INDEX
Orion 306126588 UDT_UserToIPAddressHistory 2 IX_UDT_UserToIPAddressHistory_UserID 71.4285714285714 NONCLUSTERED INDEX
Orion 306126588 UDT_UserToIPAddressHistory 3 IX_UDT_UserToIPAddressHistory_IPAddress 65.3658536585366 NONCLUSTERED INDEX
Orion 306126588 UDT_UserToIPAddressHistory 4 IX_UDT_UserToIPAddressHistory_LogonDateTime 65.5172413793103 NONCLUSTERED INDEX
Orion 318624178 ContainerMemberDefinitions 1 PK_ContainerMemberDefinitions 75 CLUSTERED INDEX
Orion 336368613 APM_ApplicationStatus_Detail 2 IX_APM_ApplicationStatus_Detail_TimeStamp 39.0804597701149 NONCLUSTERED INDEX
Orion 336545880 NetFlowDetail_332_1516159 1 IX_NetFlowDetail_StartTime 75 CLUSTERED INDEX
Orion 350624292 ContainerMemberSnapshots 2 IX_ContainerMemberSnapshots 50 NONCLUSTERED INDEX
Orion 384368784 APM_ApplicationStatus_Hourly 1 PK_APM_ApplicationStatus_Hourly 58.8652482269503 CLUSTERED INDEX
Orion 387844794 UDT_Endpoint 1 PK_UDT_Endpoint 70.5882352941177 CLUSTERED INDEX
Orion 387844794 UDT_Endpoint 2 IX_UDT_Endpoint_MACAddress 91.6666666666667 NONCLUSTERED INDEX
Orion 393493191 AuditingEvents 2 PK_AuditingEvents 77.7777777777778 NONCLUSTERED INDEX
Orion 395148453 NodeChildStatus 1 PK_NodeChildStatus 85.7142857142857 CLUSTERED INDEX
Orion 402311800 NodeCiscoCdpEntries 1 IX_NodeCiscoCdpEntries_NodeID 66.6666666666667 CLUSTERED INDEX
Orion 404022118 NetFlowDetail_297_1516157 1 IX_NetFlowDetail_StartTime 66.6666666666667 CLUSTERED INDEX
Orion 404022118 NetFlowDetail_297_1516157 2 IX_NetFlowDetail_SourceIPSort 50 NONCLUSTERED INDEX
Orion 404022118 NetFlowDetail_297_1516157 3 IX_NetFlowDetail_DestIPSort 50 NONCLUSTERED INDEX
Orion 414624520 ContainerStatus_Daily 1 PK_ContainerStatus_Daily 77.7777777777778 CLUSTERED INDEX
Orion 414624520 ContainerStatus_Daily 2 IX_ContainerStatus_Daily 75 NONCLUSTERED INDEX
Orion 420022175 NetFlowDetail_318_1516157 1 IX_NetFlowDetail_StartTime 50 CLUSTERED INDEX
Orion 421576540 Events 4 IX_NetObjectID 47.0430107526882 NONCLUSTERED INDEX
Orion 428831251 IPAM_DnsRecord 2 NI_IPAM_DnsRecord_IPAddressN 44.4444444444444 NONCLUSTERED INDEX
Orion 436022232 NetFlowDetail_392_1516157 1 IX_NetFlowDetail_StartTime 66.6666666666667 CLUSTERED INDEX
Orion 446624634 ContainerStatus_DailyData 1 PK_ContainerStatus_DailyData 77.7777777777778 CLUSTERED INDEX
Orion 448369012 APM_ApplicationTemplate 1 PK_APM_ApplicationTemplate 80 CLUSTERED INDEX
Orion 453576654 EventTypes 1 PK_EventTypes 66.6666666666667 CLUSTERED INDEX
Orion 459148681 NodeMACAddresses 1 PK_NodeMACAddresses 60 CLUSTERED INDEX
Orion 464546336 NetFlowDetail_297_1516160 1 IX_NetFlowDetail_StartTime 50 CLUSTERED INDEX
Orion 468022346 NetFlowDetail_298_1516157 1 IX_NetFlowDetail_StartTime 66.6666666666667 CLUSTERED INDEX
Orion 468022346 NetFlowDetail_298_1516157 2 IX_NetFlowDetail_SourceIPSort 50 NONCLUSTERED INDEX
Orion 468022346 NetFlowDetail_298_1516157 3 IX_NetFlowDetail_DestIPSort 50 NONCLUSTERED INDEX
Orion 510624862 ContainerStatus_Hourly 2 IX_ContainerStatus_Hourly 63.8888888888889 NONCLUSTERED INDEX
Orion 516022517 NetFlowDetail_341_1516157 1 IX_NetFlowDetail_StartTime 66.6666666666667 CLUSTERED INDEX
Orion 517576882 LimitationTypes 1 PK_Limitations 50 CLUSTERED INDEX
Orion 528546564 NetFlowDetail_298_1516160 1 IX_NetFlowDetail_StartTime 50 CLUSTERED INDEX
Orion 532022574 NetFlowDetail_296_1516157 1 IX_NetFlowDetail_StartTime 80 CLUSTERED INDEX
Orion 532022574 NetFlowDetail_296_1516157 2 IX_NetFlowDetail_SourceIPSort 75 NONCLUSTERED INDEX
Orion 532022574 NetFlowDetail_296_1516157 3 IX_NetFlowDetail_DestIPSort 75 NONCLUSTERED INDEX
Orion 553493761 DiscoveredMACAddresses 1 IX_DiscoveredMACAddresses 66.6666666666667 CLUSTERED INDEX
Orion 560369411 APM_Component 1 PK_APM_Component 80 CLUSTERED INDEX
Orion 571149080 NotificationItems 1 PK_NotificationItems 83.3333333333333 CLUSTERED INDEX
Orion 574625090 CPULoad_Daily 1 PK_CPULoad_Daily 76.4525993883792 CLUSTERED INDEX
Orion 596022802 NetFlowDetail_335_1516157 1 IX_NetFlowDetail_StartTime 66.6666666666667 CLUSTERED INDEX
Orion 596022802 NetFlowDetail_335_1516157 2 IX_NetFlowDetail_SourceIPSort 50 NONCLUSTERED INDEX
Orion 596022802 NetFlowDetail_335_1516157 3 IX_NetFlowDetail_DestIPSort 50 NONCLUSTERED INDEX
Orion 604831878 IPAM_GroupAncestors 1 PK_IPAM_GroupAncestors 75 CLUSTERED INDEX
Orion 607341228 NetFlowApps 2 IX_NetFlowApps 54.5454545454545 NONCLUSTERED INDEX
Orion 608369582 APM_ComponentDefinition 1 PK_APM_ComponentDefinition 50 CLUSTERED INDEX
Orion 611845592 UDT_PortUsage_Daily 1 PK_UDT_PortUsage_Daily 89.8218829516539 CLUSTERED INDEX
Orion 613577224 MenuItems 1 PK_MenuItems 50 CLUSTERED INDEX
Orion 628022916 NetFlowDetail_351_1516157 1 IX_NetFlowDetail_StartTime 66.6666666666667 CLUSTERED INDEX
Orion 628022916 NetFlowDetail_351_1516157 2 IX_NetFlowDetail_SourceIPSort 50 NONCLUSTERED INDEX
Orion 628022916 NetFlowDetail_351_1516157 3 IX_NetFlowDetail_DestIPSort 50 NONCLUSTERED INDEX
Orion 640546963 NetFlowDetail_296_1516160 1 IX_NetFlowDetail_StartTime 66.6666666666667 CLUSTERED INDEX
Orion 645577338 Nodes 1 PK_Nodes 33.3333333333333 CLUSTERED INDEX
Orion 645577338 Nodes 2 IX_Nodes_IPAddress 66.6666666666667 NONCLUSTERED INDEX
Orion 645577338 Nodes 3 IX_Nodes_MachineType 75 NONCLUSTERED INDEX
Orion 645577338 Nodes 4 IX_Nodes_Vendor 75 NONCLUSTERED INDEX
Orion 659845763 UDT_PortUsage_Detail 1 PK_UDT_PortUsage_Detail 90 CLUSTERED INDEX
Orion 660023030 NetFlowDetail_299_1516157 1 IX_NetFlowDetail_StartTime 66.6666666666667 CLUSTERED INDEX
Orion 684555929 NetFlowResolvedAddress 1 IX_NetFlowResolvedAddress 94.1896024464832 CLUSTERED INDEX
Orion 684555929 NetFlowResolvedAddress 2 IX_NetFlowResolvedAddress_CacheExpiration 69.2307692307692 NONCLUSTERED INDEX
Orion 684555929 NetFlowResolvedAddress 3 IX_NetFlowResolvedAddress_Domain 96.6292134831461 NONCLUSTERED INDEX
Orion 688547134 NetFlowDetail_335_1516160 1 IX_NetFlowDetail_StartTime 50 CLUSTERED INDEX
Orion 704547191 NetFlowDetail_351_1516160 1 IX_NetFlowDetail_StartTime 66.6666666666667 CLUSTERED INDEX
The orion database is running on SQL2008 Standard 64bit. The volume containing the data files is the source to the high disk queue. The other 8 volumes rarely have more than 3 disk queue.
The Orion database is 80GIG--contains six filegroups. Orion-Primary, Four separate databases in each in different file groups, and the orion log.
| Total Count | 4145 |
| Nodes | 564 |
| Interfaces | 3417 |
| Volumes | 164 |
What is the proper way to reindex / rebuild on a regular basis when one or more tables exceed recommended frag percentage?
