Announcement

Collapse
No announcement yet.

General maintenance of the SellerDeck Enterprise SQL database to improve performance:

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    General maintenance of the SellerDeck Enterprise SQL database to improve performance:

    You can improve the quality of SellerDeck Enterprise SQL’s general performance by performing the following maintenance:

    Rebuilding an index drops and re-creates the index. This removes fragmentation, reclaims disk space by compacting the pages based on the existing fill factor setting, and reorders the index rows in contiguous pages:

    Please see steps below, and perform with care:

    1. Open 'Microsoft SQL server management studio'
    2. First, ensure you make a backup of your SQL database.
    3. Then go to 'View | Object Explorer'
    4. Connect to your SQL Server Database Engine and then click + to expand the properties of the SQL server.
    5. Expand 'Databases', then expand the database for the site you are using
    6. Expand 'Tables'. You will now see a long list of tables. Expand the first table in the list which has a prefix 'dbo.', for example 'dbo.Additional Files'
    7. Right-click 'Indexes' and then click 'Rebuild All'.
    8. To start the rebuild operation, click 'OK'
    9. Repeat this process for all tables which contain an 'Indexes' folder.

    Source:
    http://technet.microsoft.com/en-us/l.../ms187874.aspx
Working...
X