My Sellerdeck Account | Free Trial

Sellerdeck Community & Knowledge Base

Go Back   Sellerdeck Community > Knowledge Base > Tips and Tricks for Performance

Search powered by Google
Register FAQ Members List Search Today's Posts Mark Forums Read

Thread Tools Search this Thread Rating: Thread Rating: 1 votes, 5.00 average. Display Modes
Old 22-Nov-2009, 02:35 PM
KB KB is offline
Join Date: Nov 2009
Posts: 1,012
Thanks: 0
Thanked 34 Times in 29 Posts
General maintenance of the SellerDeck Enterprise SQL database to improve performance:

You can improve the quality of SellerDeck Enterprise SQLs 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.

Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

All times are GMT. The time now is 03:10 AM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.