Check memory. This should be maximum 80% of the server memory. The memory settings are in the SQL server, by right clicking in the database and selecting Properties.
Check the database settings, specifically the default locations. The default locations should be in a different disk than the operation system is installed. These settings are in the SQL server, by right clicking in the database and selecting Properties.
Shrink the data and log files. These files are in the SQL server, by right clicking in the database and selecting Task > Shrink > Files.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article