Problem (Issue) Statement: | How to Rebuild and Reorganize SQL Server Index for xPortalNet Database | ||||||||||
Description: | This article will guide users to rebuild and reorganize SQL Server Index for xPortalNet Database. Indexes are a key element to improve xPortalNet database performance. Users are recommended to maintain indexes to make sure best performance from the SQL database. There are two maintenance routines that can be performed, either an index rebuilding or index reorganizing in order to maintain index and improve database performance. An index rebuild simply drops and recreates the index which means that index rebuild will solve both the internal and external fragmentation. An index reorganize only solves external fragmentation by moving pages around. | ||||||||||
Related Software: |
| ||||||||||
Related Hardware: |
| ||||||||||
System Application: | NIL | ||||||||||
Symptom and Finding: | NIL | ||||||||||
Cause: | For first time guide to rebuild and reorganize SQL Server Index for xPortalNet Database. Index fragmentation is usually caused by xPortalNet database being frequently updated via INSERT, UPDATE, or DELETE statements. Over time, these modifications can cause the information in the index to become scattered in the database (fragmented). | ||||||||||
Solution: | Summary:
.
. Step-by-step Guide:
Step 1: Launch the SQL Server Management Studio. . Step 2: The Microsoft SQL Server Management Studio window will be shown. In the Object Explorer panel, expand the Databases folder. . Step 3: Select XPNDB to expand the Table folder. . Step 4: Expand the specific table requiring rebuild operation. .
. . Step 5: Right click the Index folder and select Rebuilt All. . Step 6: The Rebuild Index window will be shown. User can analyse specific table information for the indexes to be rebuilt and total fragmentation, click OK and wait for the process to complete. . .
Step 1: In the Object Explorer panel, expand the Databases folder. . Step 2: Select XPNDB to expand the Table folder. . Step 3: Expand the specific table requiring reorganize operation. . Step 4: Right-click the Index folder and select Reorganize All. . Step 5: The Reorganize Indexes window will be shown. User can analyse specific table information for the indexes to be reorganize and total fragmentation, click OK and wait for the process to complete. | ||||||||||
Common Issue | NIL | ||||||||||
Date Documentation: | 22/5/2020 (Rev 1.0) |
...
Section | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||
|
.
...
.
Choices for confluence | ||
---|---|---|
|