Maintain large SQL Server database and resolve website 'Timeout Error'
If you have exceptionally large SQL Server databases, refer to these best practices for proper database maintenance to steer clear of a website 'Timeout Error.'
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
By submitting your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
You can also look and see how much free space your database has and how often the database is extending the database. If the extend size is too large, this can cause database queries to timeout. With the database file being only 3.5 GB this probably isn't all that likely unless the disk drives are too overloaded. You can check to see if the disk drives are being overloaded by using performance monitor and checking the disk queue, reads per second and writes per second.
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
PRO+
Content
Find more PRO+ content and other member only offers, here.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our SQL Server experts
View all SQL Server questions and answers
0 comments
Oldest Newest