July 22, 2015 at 5:14 am
We have a series of databases created for our reporting team, restored from production versions of our OLTP databases and meant to be read-only (though the files have not specifically been set to read-only). Recovery mode is SIMPLE. The past few weeks (as the reporting team works on some new projects) I've noticed an unprecedented amount of growth on these databases. It's not just the log files that are growing. The data files are growing also. The weird thing is, this happens late in the evening / middle of the night even though there are no reindex / update statistics jobs running.
When I check the file sizes in the morning, all the "growth" is free space. It doesn't actually seem to be used by the data. The data size seems to be the same from day to day. Which is how it should be, since the reporting team isn't supposed to be adding data to these dbs. Instead, they read from these dbs to insert the data into a common data store db. So I'm a little confused as to why these databases would be growing.
Google keeps pointing me to threads on log file growth. I get the log file growth issue. It's the data file growth that is confusing me. Any thoughts?
July 22, 2015 at 5:37 am
Are you sure nothing's running index rebuilds on them? Have you tried running an XE session overnight to confirm?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2015 at 5:52 am
GilaMonster (7/22/2015)
Are you sure nothing's running index rebuilds on them?
The job we have runs once a week on Sundays, not during the week. So I know that is not running.
Have you tried running an XE session overnight to confirm?
I have not. And until you suggested it, it never crossed my mind. Thank you for this. I will look into setting one up.
July 22, 2015 at 6:03 am
Brandie Tarvin (7/22/2015)
GilaMonster (7/22/2015)
Are you sure nothing's running index rebuilds on them?The job we have runs once a week on Sundays, not during the week. So I know that is not running.
Could something else be running rebuilds?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2015 at 6:20 am
GilaMonster (7/22/2015)
Brandie Tarvin (7/22/2015)
GilaMonster (7/22/2015)
Are you sure nothing's running index rebuilds on them?The job we have runs once a week on Sundays, not during the week. So I know that is not running.
Could something else be running rebuilds?
If there is, then it's very well hidden. I can't seem to find anything else. But I will ask around.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply