sql server maintenance cleanup task

Start a server, is exactly the cloud host, the environment inside is pre-configured, but in the configuration planning tasks, but found that mssql2005 plan backup can not do, will error: Copy Code code as follows: SQL Server Create Maintenance plan failed (SQL

netcom, in the management-Database Mail set its good, want to have SMS prompt, need 136 mobile mailbox, in the settings can be opened. To send messages automatically, you need to have the alert system-mail profile enabled in the Mail agent properties.30. The Messenger service enables the database to be automatically net send to another computer. Then in cmd you can net send 192.168.1.5 Fdfas. The operator automatically sends information to the operator when the job is completed when it is autom

options Minimum--Minimum value for configuration options Maximum--Maximum value of configuration options Value_in_use--The running value currently used by the configuration option Description--Description of configuration options Is_dynamic--equals 1 indicates a variable that needs to execute the reconfiguration statement to take effect Is_anvanced--equals 1 indicates a variable that requires the show advanced statement to take effect --You can also use sp_configure to

Scheduled maintenance plans: Use the New fill (empty) factor to rebuild the index to restructure the data and the data on the index page. This ensures that the database page contains equally distributed data and available space, which allows for faster growth in the future. Remove an empty data page from the database page to compress the data file. Update index statistics to ensure that the query is optimized and the table distribution data is worth t

ObjectiveAn earlier article introduced indexes to improve query performance in a database, which is just the beginning. Perhaps assuming a lack of proper maintenance, index the performance of your previously established and even become a drag-and-drop database of accomplices.Looking for fragmentsThe elimination of fragmentation index maintenance is probably the most common

This article belongs to the managing SQL Server AlwaysOn series articleObjective:The previous series has covered SQL Server AlwaysOn knowledge points, installation demos, and considerations. But this is not the end, but more is the starting point. It's like you can't give birth to a child, you have to keep it (manageme

SQL Server Performance Tuning 3 Index MaintenancePreface The previous article introduced how to improve database query performance by creating indexes, which is just the beginning. If you do not need proper maintenance in the future, the indexes you have previously created may even become a drag-and-drop attack and a helper for database performance degradation.Se