Maintenance is the preventative management portion of our Remote DBA service. It is the most cost-effective way to proactively manage and administer the health, storage, security and performance of your Microsoft SQL Server database systems.
We use many tools of trade for effectively managing SQL services.
SQL Management Objects (SMO): SQL Management Objects (SMO) is a new set of programming objects that expose the functionality of the SQL Server database. SMO is implemented as a Microsoft® .NET Framework assembly and can be used to automate repetitive or common SQL Server administrative tasks, such as programmatically retrieving configuration settings, creating new database, applying Transact-SQL scripts, creating SQL Server Agent jobs, and scheduling backups.
Dynamic Management Views (DMV): SQL Server 2005 exposes more than 70 new measures of internal database performance and resource usage from memory, locking, and scheduling to transactions and network and disk I/O.
Improved Manageability and Performance:
Table and Index Partitioning: Table and index partitioning eases the management of database by facilitating the management of the database in smaller, more manageable chunks. SQL Server 2005 provides a new capability for the partitioning of tables across file groups in a database. Horizontal partitioning allows for the division of a table into smaller groupings based on a partitioning scheme.