Our database data file is currently enabling auto growth with 1 MB File Growth and Unlimited Maximum File Size. After reaching the initial size, repeated data file auto growth events are occurring. Can these repeated actions cause performance issues?
Answer by Kev Riley ·
Yes they can. Every time the file needs to grow, all activity on the database will stop and wait for the file growth to finish.
It is recommended that you pre-size the database files, and also set the auto-growth amount to be something more in line with the database size - for example if your database needed to be 100GB, you wouldn't then want it growing incrementally in 1MB chunks - maybe better to be 10 or 20GB.
Also ensure that you have instant file initialization enabled - then when the data file needs to grow, it's a faster operation.
i have a report in ssrs which shows top 30 claims and i want a graph for it.what i can do to autosize these claim nos on my graph and also when i export it to excel and pdf what i can do to fit the content in the proper shape.