Explore BrainMass

Explore BrainMass

    Maintenance Tools in MS SQL 2005

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    What are some of the maintenance tools available in MS SQL 2005, and how are they used?

    © BrainMass Inc. brainmass.com December 15, 2022, 6:12 pm ad1c9bdddf

    Solution Preview

    Manageability Features in SQL Server 2005

    SQL Server 2005 focuses on making it simpler and easier to deploy, manage and optimize enterprise data and analytical applications. As a trusted data management platform it provides a single management console that enables data administrators anywhere in the organization to monitor, manage and tune all of the databases and associated services across your enterprise.

    Management tools include:
    ? an integrated management tool suite with support for the automation of routine tasks
    ? proactive systems for monitoring system health and performance
    ? enhanced performance tuning tools
    ? greater programmability
    ? table and index partitioning to improve ...

    Solution Summary

    The maintenance tools available in MS SQL 2005, and their usage are explained.