- A database does not expand automatically although you have the autogrow option on.
- The Errorlog file does not contain any messages that indicate that the database is full.
- Client computers that try to modify data in this database receive a "Timeout Expired" message on their user transaction.
- SQL Profiler displays an "Attention" event on a connection, and, if the computer is running SQL Server 7.0, SQL Profiler also displays an "Exception 822" error.
You may notice these symptoms when:
- You run SQL Profiler for a long time, you capture the Exception event and the IntegerData column, and then you look for an occurrence of the "Exception 822" error.
- You use the -y822 parameter to start SQL Server. After the database does not automatically expand, you check the Errorlog file for a stack dump because of the "Exception 822" error.
- Expand the database manually. To expand the database manually, use either the ALTER DATABASE statement or SQL Server Enterprise Manager.
- Increase the client query timeout value of the application that requests the DML so that the server has time to expand the database. The DML prompts the database to expand.
For example, if you are using SQL Query Analyzer, the default query timeout value is 0 (infinite). If you are using the default value, you do not experience this behavior. If you are not using the default value, increase the query timeout value.
For other applications (whether they are Web-based or not), you can make the change in the application. For example, if you are using ADO, you can change the CommandTimeout property for the Connection or Command object.
- Determine how long the database expansion takes on your server. To determine this, run the ALTER DATABASE statement in SQL Query Analyzer, and then view the status bar. After you determine this, set the client timeout value to something greater than this value.
- Do not change the client timeout value. Continue to test the automatic expansion and see how much expansion completes in less than the client timeout value. Set the autogrow option to this new (smaller) value.
ID articol: 305635 - Ultima examinare: 10 iul. 2008 - Revizie: 1