Database Size Bloating after SP4.

Has anyone had any issues with a database doubling or tripling in size after
SP4 is installed? We have several databases that are structurely the same
however certain DB's have grown enormously in size without a large increase
in data. Whenever we try to shrink the Database it won't shrink to the
approximate size we are expecting. For example...
We have a DB that is 12.3GB with 3GB in data, 1 GB in indexes.
We have a DB that is 17.1GB with 3GB in data, 740MB in indexes.
We have a DB that is 7.8 GB with 4.6GB in data, 2.4GB in indexes.
The last one I understand.. it is where it should be.. However the first two
don't make any sense..
Can someone give me an idea.. I have tried defragging, shrinking.. etc.. Any
known problems that would cause this? Thanks for your help in advance!
You didn't say what sizes you log files are.
Have you looked at the DB Option 'trunc. log on chkpt.'? Is it on or off? If
it's off, then you log files could be growning and be the cause of your
large database sizes.
It's just a thought.
"Sam Davis" <SamDavis@.discussions.microsoft.com> wrote in message
news:CB4F5891-67A2-4535-BE1A-DAA3C0FE4FB1@.microsoft.com...
> Has anyone had any issues with a database doubling or tripling in size
> after
> SP4 is installed? We have several databases that are structurely the same
> however certain DB's have grown enormously in size without a large
> increase
> in data. Whenever we try to shrink the Database it won't shrink to the
> approximate size we are expecting. For example...
> We have a DB that is 12.3GB with 3GB in data, 1 GB in indexes.
> We have a DB that is 17.1GB with 3GB in data, 740MB in indexes.
> We have a DB that is 7.8 GB with 4.6GB in data, 2.4GB in indexes.
> The last one I understand.. it is where it should be.. However the first
> two
> don't make any sense..
> Can someone give me an idea.. I have tried defragging, shrinking.. etc..
> Any
> known problems that would cause this? Thanks for your help in advance!
|||Francis,
I have ran the shrinkfile however it returns a limited result. Such that I
can get the file down from 12GB to 10GB however it still seems like the
unused space that is reported isn't ever freed up..
"Francis" wrote:
[vbcol=seagreen]
> I have had SP4 running on 4 production servers and a couple of test servers
> for several months now without any of the issues that you mention. If you
> need to shrink your database and EM or the DBCC SHRINKDATABASE of DBCC
> SHRINKFILE isn't working then try this script:
> http://www.sqlservercentral.com/scri...p?scriptid=666
> I usuall find the DBCC SHRINKFILE works better than SHRINKDATABASE since I
> can control which file I want to schrink.
> Have you noticed that the database grows after doing a DBCC REINDEX? If so
> you may need extra free space, although 8-14 G seems excessive.
> "Sam Davis" wrote:
|||The log files are small 100-200 MB...
"Joe D" wrote:

> You didn't say what sizes you log files are.
> Have you looked at the DB Option 'trunc. log on chkpt.'? Is it on or off? If
> it's off, then you log files could be growning and be the cause of your
> large database sizes.
> It's just a thought.
>
> "Sam Davis" <SamDavis@.discussions.microsoft.com> wrote in message
> news:CB4F5891-67A2-4535-BE1A-DAA3C0FE4FB1@.microsoft.com...
>
>