Troubleshooting database issues

Use the following topics to resolve common issues with the database.

Ensure you have performed the following database best practices:

Make sure that the server has the appropriate capacity to handle the load and is not shared with other systems.
Check and make sure that the DB statistics are up to date.
Check memory allocation to make sure that there are no unnecessary disk reads.
Check to see if the database needs to be de-fragmented.