Maintain large SQL Server database and resolve website 'Timeout Error'

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Microsoft SQL Server Performance Monitoring and Tuning Using traces in SQL Server Profiler SQL Server Mailbag: CALs, witnesses and unwanted changes SQL Server Mailbag: Data restoration and DB property management Working with IntelliSense in SQL Server 2008 Management Studio SQL Server Mailbag: Stored procedures, triggers and SSRS reports Troubleshooting Distributed Transaction Coordinator errors in SQL Server Clearing the Windows page file and its effect on server performance Optimizing SQL Server indexes –- even when they're not your indexes Performance implications of transaction log autogrowth in SQL Server The short course on how SQL Server really works Archive: Performance Tuning Upgrading to SQL Server 2008 advantages and hardware requirements Tool to synchronize two SQL Server databases Performance tuning for SQL Server 2005 and Exchange running on SBS SQL Server tools don't appear in menu after SQL Server 2005 install Troubleshoot SQL Server 2005 temporary table performance problems How to retrieve SQL Server database disk space in use Use SQL Profiler to find long running stored procedures and commands View query execution plan in SQL Server with this method Adding non-clustered indexes to SQL Server columns Change collation to SQL Server 2005 after upgrading databases

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary contiguity  (SearchSQLServer.com) contiguous  (SearchSQLServer.com) drilldown  (SearchSQLServer.com) hashing  (SearchSQLServer.com) hybrid online analytical processing  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

There are a few things you should consider. You'll want to look at the queries which are causing the blocking. Usually this will be a SELECT statement which doesn't have the WITH (NOLOCK) option on it, or an UPDATE statement which is running against the database.

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.