Optimizing a database (Model Explorer)
To optimize a database:
1. Start Model Explorer.
2. Locate the Database that you want to optimize:
a. Expand the SQL icon.
b. Expand the Server that owns the database you want to optimize.
If the Server that owns the Database is not shown, add the Server to Model Explorer.
c. If the Database you want to optimize is not shown, show the server's databases, and optionally bookmark the database.
3. Right-click the database you want to optimize, and then click Optimize.
4. Confirm that the Database optimized successfully message appears.