Auto Growth Issue On SQL 2005.

Question

Post reply

Auto Growth Issue On SQL 2005.

adeel.imtiaz

SSCommitted

Points: 1805
More actions
April 26, 2012 at 5:13 am

#267977

Dear Sir,

I have facing problem in my SQL 2005 DB auto grow,

Following is the File Status

Initial Space : 6.00 MB

Used Space : 5.44 MB

Available Space : 0.56 MB

Auto Growth Parameter is configured as “By 1 MB, unrestricted growth.”

My DB is unable to auto grow.

Please help.

Thanks

Thanks

Adeel Imtiaz

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

adb2303 SSCertifiable Points: 7588 More actions · Answer 1

do you get any errors?

You're better off pre-allocating the space required for the data and log files. Growing data files/log files is a resource expensive operation, so you want to restrict how often it occurs. Also, look at instant file initialization - grant the service account running the SQL Server service account Perform Volume Maintenance 'via Local Policy manager

Suresh B. SSC-Insane Points: 22986 More actions · Answer 2

Suresh B.

SSC-Insane

Points: 22986

April 26, 2012 at 5:19 am

#1479588

adeel.imtiaz (4/26/2012)

My DB is unable to auto grow.

1) Are you able to enter data into this database?

2) Are you getting any error messages?

3) Is the drive full?

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 3

Usually that would be an indication of a full drive. There must be an error or a message or something.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

adeel.imtiaz SSCommitted Points: 1805 More actions · Answer 4

Please see that the drive is not full . there is lot of space available .

I have noticed that i do not have any Service pack installed on my SQL 2005 Database its version is

(Version 1399).

We actually also assumed that space will be automatically allocated, but for some reason this auto growth working is not performing at all. we were just updating a row in a table. Enable Auto grow option is also set to true. there is 20 GB free Space available in Hard Disk.