Sql server 2005 database filesize auto grow

50 pts.
Tags:
SQL Server 2005
SQL Server performance
Hi i'm running sql server 2005 sp2 on a w2k cluster; i'm expericing this issue whereby the file size of a particular database will auto increase even though no one is even accessing it. Is there anyway to findout the cause of this issue or how can i stop the database from auto increasing the file size

Answer Wiki

Thanks. We'll let you know when a new response is added.

There is probably a job scheduled to run which is causing the auto grow. Check the SQL Agent and see what jobs are scheduled. You can also fire up SQL Profiler and see what’s running on the SQL Server and when the autogrow event occurs.

If the autogrow is happening at night it’s probable that the maintenance plan is causing the autogrow. Normal database maintenance requires that the database have enough free space to contain the largest index being worked on twice, so if there is not enough free space the server will grow the database to make enough room.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • alessandro.panzetta
    Hello, I suggest you checking if perhaps the backup is causing the issue; I has the same problem with a wrongly setup of backups that brought the db at 800mb while it was simply 140Mb. Bye
    9,725 pointsBadges:
    report
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,195 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following