Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

what does this means and possible solution for it 1

Status
Not open for further replies.

parsql

MIS
Nov 10, 2005
106
US
Autogrow of file 'test_Data' in database 'test' cancelled or timed out after 29641 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size.
 
Either your database is very large and is trying to autogrow a very large amount, or your disk is very slow, or a combinantion there of.

How large is the database, and what's the growth rate set to?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
DB is around 37 G and is set to 10% to autogrow!!
 
It's trying to grow by 3.7 Gigs in one chunk. If the drives are busy this will take longer than SQL will allow for. Change the growth setting to 500 Megs and you shouldn't have any problems. This will give you a good size growth, that SQL won't have to wait very long to grow so the growth time shouldn't effect performance.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
mrdenny,

You certainly know more about this stuff than I do. I was wondering if a fragmented drive would take longer to grow a database than a defragmented drive. Any thoughts?

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Probably a little bit, but only by seconds. When the drive is fragmented it will write some of the file, then SQL has to wait for the drive head to get to the next free spot on the drive.

The reason it takes so long for SQL to extend the file is that after it extends the file, it writes zeros to the new part of the file. That's the part that takes the time.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
mrdenny,

That makes sense. Thanks for taking the time to indulge my curiosity. For that, a purple star.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top