The Server Administrator utility can perform three maintenance operation on the SQL server.
Check Database - checks the logical and physical integrity of all the objects in the database and reports if any errors are found.
Rebuild Indexes - fixes any fragmentation of the database internal index
Update Statistics - updates the internal statistics of the database to help it build more efficient queries.
Whenever the overall performance of the server drops, it is recommended to perform all three operations in order.
See also: