Post reply

Updating Statistics as a 3rd Party Vendor.

  • June 15, 2015 at 2:49 pm

    #318956

    I am a relatively new DBA working for a small 3rd Party Software Vendor. How can we make sure that things like index fragmentation and outdated statistics don't become a problem for our customers.

    Some of our clients are big enough to have their own IT staff with DBA's, but many of them are not. As we are currently moving toward rewriting our software and redesigning the database structure from the ground up, I was hoping for some guidance in keeping our clients' database querying running smoothly as possible.

    Thanks in advance!

    Chris

  • June 15, 2015 at 10:53 pm

    #1805633

    Recommend Olla Hallengren scripts, and modify his MaintenanceSolution to create the standard job and steps you require. To clarify, we modified it to have everything in one job and multiple job steps (plus something at the end to report an error if any job step fails). In the default configuration you also need a standard place to store the output text files (though you can forego this step if you have to), which also means granting SQL access to write to that folder. We have a standard folder on C:\ for it as they don't take much space.

    It's not necessarily a matter of deploy-and-forget though.

    - You probably want to set everything to REORGANIZE only (and then update statistics).

    - If you use REBUILD then you probably want to make sure they have an approved outage window, w/ or w/o ONLINE=ON for Enterprise, and that a REBUILD could complete in that time (you'd have to run one to know, on a server with similar size and performance).

    - If they're in FULL mode you probably want to make sure that they are going to have adequate space on the folder that holds their logs, and also their log backups folder, for the additional work.

  • June 16, 2015 at 12:39 am

    #1805641

    ola's scripts are the perfect . but u can use sql server maintenance plan and few job also to this task. also configure some mannual alerts if the something goes wrong . they are easy to create and pretty helpful

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

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