数据库增加了三倍!! [英] Database Tripled In Size!!
问题描述
糟糕！我的数据库长期以来一直是1 gig，从一场演出到3演出过夜了！看一下夜间备份，
数据库平均每天增加大约5-15 MB，而
星期四晚上备份增加了1.06 GB。然后，在星期五晚上的备份中，它是2.95 GB，
并且一直保持这种状态！
我对数据库进行了收缩，但是没有帮助的情况。
我能想到的唯一可能与之相关的是以下内容。我之前（约一周前）
从smalldatetime更改了几个表''DateModified字段
到datetime。 （我在这里发布了一个单独的帖子
。）由于某些原因，我偶尔会遇到错误，我认为这可能与新数据类型有关。所以我决定将数据
类型更改回smalldatetime。
我在周四晚上做了表格更改，就在备份之前，但是在
数据库优化。星期四晚上的备份仍然显示小的数据库大小。但星期五晚上的备份有很大的尺寸。
所以这可能与表格的变化无关。但我知道一个
的事实，数据库中的数据不是3倍。不知怎的，数据库是b / b $ b膨胀到它的大小的3倍，它不是来自实际数据。
关于我能做什么的任何想法？ />
谢谢！
Neil
Yikes! My database, which had been consistently 1 gig for a long time, went
from being 1 gig to 3 gigs overnight! Looking at the nightly backups, the
database increased on average about 5-15 MB per day, and was 1.06 GB on the
Thursday night backup. Then, with the Friday night backup, it was 2.95 GB,
and has stayed that way since!
I did a Shrink on the database, but that didn''t help the situation.
The only thing I could think it might relate to is the following. I
previously (about a week ago) changed a couple of tables'' DateModified field
from smalldatetime to datetime. (I posted about this under a separate thread
here.) For some reason I was getting occasional errors which I believe might
have been related to the new data type. So I decided to change the data
types back to smalldatetime.
I made the table changes Thursday night, right before the backup, but after
the database optimizations. The backup Thursday night still shows the small
database size. But the backup Friday night has the large size.
So this might not be related to the table changes at all. But I know for a
fact that there isn''t 3x the data in the database. Somehow the database is
bloated to 3x its size, and it''s not from actual data.
Any ideas about what I can do?
Thanks!
Neil
推荐答案
周一，24日2007年12月01:37:57 GMT，Neil < no **** @ nospam.netwrote：
检查数据库属性文件页面。它会告诉你，一旦它填满，它将会增加多少b $ b db。默认情况下是1MB，但你可能已经改变了它的价值。
3GB仍然非常小，硬盘空间便宜。
-Tom。
On Mon, 24 Dec 2007 01:37:57 GMT, "Neil" <no****@nospam.netwrote:
Check Database Properties Files Page. It will show you how much the
db should grow once it fills up. 1MB by default, but you might have
changed it..
3GB is still very small, and hard disk space is cheap.
-Tom.
> Yikes！我的数据库长期以来一直是1 gig，从1 gig到3 gigs过夜！查看夜间备份，
数据库平均每天增加大约5-15 MB，并且在星期四晚上备份时增加了1.06 GB。然后，随着周五晚上的备份，它是2.95 GB，
并且一直保持这种状态！
我对数据库进行了收缩，但这对情况没有帮助。
我能想到的唯一一件事就是以下内容。我之前（约一周前）将一些表''DateModified字段
从smalldatetime更改为datetime。 （我在这里发布了一个单独的帖子。）由于某些原因，我偶尔会遇到错误，我认为这些错误可能与新数据类型有关。所以我决定将数据类型更改回smalldatetime。
我在周四晚上做了表更改，就在备份之前，但是在数据库优化之后。星期四晚上的备份仍显示小的数据库大小。但星期五晚上的备份规模很大。
所以这可能与表格的变化无关。但我知道，数据库中的数据不是3倍。不知何故，数据库膨胀到其大小的3倍，并且它不是来自实际数据。
关于我能做什么的任何想法？
谢谢！
Neil
>Yikes! My database, which had been consistently 1 gig for a long time, went
from being 1 gig to 3 gigs overnight! Looking at the nightly backups, the
database increased on average about 5-15 MB per day, and was 1.06 GB on the
Thursday night backup. Then, with the Friday night backup, it was 2.95 GB,
and has stayed that way since!
I did a Shrink on the database, but that didn''t help the situation.
The only thing I could think it might relate to is the following. I
previously (about a week ago) changed a couple of tables'' DateModified field
from smalldatetime to datetime. (I posted about this under a separate thread
here.) For some reason I was getting occasional errors which I believe might
have been related to the new data type. So I decided to change the data
types back to smalldatetime.
I made the table changes Thursday night, right before the backup, but after
the database optimizations. The backup Thursday night still shows the small
database size. But the backup Friday night has the large size.
So this might not be related to the table changes at all. But I know for a
fact that there isn''t 3x the data in the database. Somehow the database is
bloated to 3x its size, and it''s not from actual data.
Any ideas about what I can do?
Thanks!
Neil
> >哎呀！我的数据库，长期以来一直是1 gig，
从1演出到3演出过夜！查看夜间备份，
数据库平均每天增加大约5-15 MB，并且在星期四晚上备份时增加了1.06 GB。然后，随着周五晚上的备份，它是2.95 GB，
并且一直保持这种状态！
我对数据库进行了收缩，但这对情况没有帮助。
我能想到的唯一一件事就是以下内容。我之前（约一周前）将一些表''DateModified
字段从smalldatetime更改为datetime。 （我在这里发布了一个单独的
线程。）由于某些原因，我偶尔会遇到错误，我相信它可能与新数据类型有关。所以我决定将数据类型更改回smalldatetime。
我在周四晚上，在备份之前更改了表格，但是在数据库优化之后
。星期四晚上的备份仍显示
小的数据库大小。但星期五晚上的备份规模很大。
所以这可能与表格的变化无关。但我知道，数据库中的数据不是3倍。不知何故，数据库膨胀到其大小的3倍，并且它不是来自实际数据。
关于我能做什么的任何想法？
谢谢！
Neil
>>Yikes! My database, which had been consistently 1 gig for a long time,
went
from being 1 gig to 3 gigs overnight! Looking at the nightly backups, the
database increased on average about 5-15 MB per day, and was 1.06 GB on
the
Thursday night backup. Then, with the Friday night backup, it was 2.95 GB,
and has stayed that way since!
I did a Shrink on the database, but that didn''t help the situation.
The only thing I could think it might relate to is the following. I
previously (about a week ago) changed a couple of tables'' DateModified
field
from smalldatetime to datetime. (I posted about this under a separate
thread
here.) For some reason I was getting occasional errors which I believe
might
have been related to the new data type. So I decided to change the data
types back to smalldatetime.
I made the table changes Thursday night, right before the backup, but
after
the database optimizations. The backup Thursday night still shows the
small
database size. But the backup Friday night has the large size.
So this might not be related to the table changes at all. But I know for a
fact that there isn''t 3x the data in the database. Somehow the database is
bloated to 3x its size, and it''s not from actual data.
Any ideas about what I can do?
Thanks!
Neil
" Tom van Stiphout" < no ************* @ cox.netwrote in message
news：su ***************** *************** @ 4ax.com ...
"Tom van Stiphout" <no*************@cox.netwrote in message
news:su********************************@4ax.com...
周一，2007年12月24日01:37:57 GMT ，尼尔 < no **** @ nospam.netwrote：
检查数据库属性文件页面。它会告诉你，一旦它填满，它将会增加多少b $ b db。默认情况下是1MB，但你可能已经改变了它的价值。
3GB仍然非常小，硬盘空间便宜。
-Tom。
On Mon, 24 Dec 2007 01:37:57 GMT, "Neil" <no****@nospam.netwrote:
Check Database Properties Files Page. It will show you how much the
db should grow once it fills up. 1MB by default, but you might have
changed it..
3GB is still very small, and hard disk space is cheap.
-Tom.
在文件属性中（我从未接触过），它被设置为自动
将文件增长10％，文件增长不受限制。
我意识到3 GB并不是那么大。尽管如此，事实仍然是，尽管数据输入，但是b / b
在一夜之间不会增加三倍。因此，必须在那里进行其他事情。如果有膨胀，那么摆脱它会很好
。但是，如上所述，收缩数据库并没有让它失效。
所以我不知道发生了什么。
In File Properties (which I''ve never touched), it''s set to Automatically
grow file by 10%, with unrestricted filegrowth.
And I realized that 3 GB isn''t that large. Still, the fact remains that it
couldn''t have tripled in size overnight though data entry. So there has to
be something else going on there. If there''s bloating, then it would be good
to get rid of it. But, as noted, Shrink Database doesn''t bring it back down.
So I don''t know what''s going on.
" Neil" < no **** @ nospam.netwrote in message
news：V3 ************* @newssvr11.news.prodigy.net ...
"Neil" <no****@nospam.netwrote in message
news:V3*************@newssvr11.news.prodigy.net...
呀！我的数据库，长期以来一直是1 gig，
一夜之间从1演出到3演出！看一下夜间备份，
数据库平均每天增加大约5-15 MB，并且在周四晚上备份时增加了1.06 GB
。然后，在星期五晚上的备份中，它是2.95 GB，并且一直保持这种状态！
我对数据库进行了收缩，但是没有帮助的情况。
我能想到的唯一可能与之相关的是以下内容。我之前（约一周前）
从smalldatetime更改了几个表''DateModified
字段到datetime。 （我在这里单独发布了一个
单独的帖子。）由于某种原因，我偶尔会遇到错误
，我认为这可能与新数据类型有关。所以我决定
将数据类型更改回smalldatetime。
我在周四晚上做了更改表，就在备份之前，但
数据库优化后
。星期四晚上的备份仍显示小数据库大小
。但星期五晚上的备份有很大的尺寸。
所以这可能与表格的变化无关。但我知道一个
的事实，数据库中的数据不是3倍。不知怎的，数据库是b / b $ b膨胀到它的大小的3倍，它不是来自实际数据。
关于我能做什么的任何想法？ />
谢谢！
Neil
Yikes! My database, which had been consistently 1 gig for a long time,
went from being 1 gig to 3 gigs overnight! Looking at the nightly backups,
the database increased on average about 5-15 MB per day, and was 1.06 GB
on the Thursday night backup. Then, with the Friday night backup, it was
2.95 GB, and has stayed that way since!
I did a Shrink on the database, but that didn''t help the situation.
The only thing I could think it might relate to is the following. I
previously (about a week ago) changed a couple of tables'' DateModified
field from smalldatetime to datetime. (I posted about this under a
separate thread here.) For some reason I was getting occasional errors
which I believe might have been related to the new data type. So I decided
to change the data types back to smalldatetime.
I made the table changes Thursday night, right before the backup, but
after the database optimizations. The backup Thursday night still shows
the small database size. But the backup Friday night has the large size.
So this might not be related to the table changes at all. But I know for a
fact that there isn''t 3x the data in the database. Somehow the database is
bloated to 3x its size, and it''s not from actual data.
Any ideas about what I can do?
Thanks!
Neil
这里有一个想法：是否可以查看数据库中
对象的细分，以及每个对象占用多少空间？也许
有助于确定这里发生了什么。
Here''s one thought I had: is it possible to look at a breakdown of the
objects in the database, and how much space each one is taking up? Perhaps
that would help to determine what''s going on here.
这篇关于数据库增加了三倍!!的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
