Post reply

Automated Index Maintenance

  • March 4, 2013 at 2:37 pm

    #271097

    I'm looking for a product to Automate our Index Maintenance. Currently we have a product that allows scheduling but uses its own proprietary scheduler. I'm looking for something that would allow for either a CLI or SQL Server Job to execute the analysis and maintenance.

  • March 4, 2013 at 2:44 pm

    #1593178

    probably one of the best maintenance solutions out there is this free, peer reviewed, used in major production facilities and major companies solution offer by the world renowned SQL DBA Ola Hallengren:

    http://ola.hallengren.com/

    it has the option of building your suggested SQL Server jobs for you, and you can tweak it from there.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply