Everest CRM Rebuild Indexes

Posted on 2009-12-26
Last Modified: 2012-05-08

I have Everest CRM software tied to a SQL 2005 Database.  I want to rebuild the indexes from the application but it tells me i do not have exclusive access to the database and that SERVER-SERVER is logged in (that being the actual server name of course).  I do not know alot about SQL or if there is a command i can run in SQL to do the same thing.  Any ideas?

Question by:codyvance1
    LVL 4

    Accepted Solution

    If you need to rebuild the indexes on SQL 2005 I would suggest that you do it via SQL Server Managament Studio rather than through your application. I don't know much about th CRM software so I'mnot sure what it would be trying to run in the background. If you are the DBA or in charge of the database server I would suggest having a look at the article below about setting up a regular index rebuilding maintenance job. This can then run independently in the background.

    This shows breifly how to setup a job for specific indexes but the maintenance plan wizard in SSMS is quite straight forward.


    Author Comment

    The DBA was worried that the Rebuild Indexes function in the application is different the the rebuild indexes in SQL.  I told them it would do the same thing would you agree?
    LVL 15

    Assisted Solution

    Rebuilding indexes on SQL 2000 does not have the online option. Plan on doing this during off peak hours.

    In addition to James' suggestion, here is a sample of command (SQL 2000 vs SQL 2005):

    And some tips when you rebuilt indexes:

    Read before you do the actual rebuilding of your indexes.
    LVL 15

    Expert Comment

    As long as it executes the command DBCC DBREINDEX -- then it is the same. Though since it is inside the application, you do not have the control of what's being reindex. It might be reindex of all the your tables -- who knows.

    Author Closing Comment

    Thanks for your help.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now