Sql Auto grow: configured

Showing posts with label configured. Show all posts

Thursday, March 22, 2012

automatical grow does not work

Hi all,
we encountered problem on testing environment that database does not grow
even though it is configured to grow automatically. There is SQL Server 2000
installed on two Windows Server 2003 in cluster. Application runs on its
dedicated WinServer using ADO.NET for data manipulation. When data file is
full (or it remains only small free space ~2MB), all application's db
requests fail with timeout. When I manually enlarge data file, application
starts to work again.
Is there any known issue regarding to automatical grow of database. Does
anyone face this problem ?
eXavierHi
How big is your database?
It might take time .For example if the database is 20GB and you set a 20%
growth rate that means if the database grows it will increase by 2GB. This
may or may not be what you want.
"eXavier" <fhns@.centrum.cz> wrote in message
news:ekIyJogWFHA.2740@.TK2MSFTNGP14.phx.gbl...
> Hi all,
> we encountered problem on testing environment that database does not grow
> even though it is configured to grow automatically. There is SQL Server
2000
> installed on two Windows Server 2003 in cluster. Application runs on its
> dedicated WinServer using ADO.NET for data manipulation. When data file is
> full (or it remains only small free space ~2MB), all application's db
> requests fail with timeout. When I manually enlarge data file, application
> starts to work again.
> Is there any known issue regarding to automatical grow of database. Does
> anyone face this problem ?
> eXavier
>|||After restore, the database is about 1.7 GB, I tried to set growing to
both - fixed amount and percentage factor with no success. When I did SQL
insert from QA - it took about 3 minutes but the file increased. I have only
60 seconds timeout on ADO connection string, may it be that timeouting of
connection prior to data are inserted could cause not performing of file
growth ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23gBBktgWFHA.2572@.TK2MSFTNGP14.phx.gbl...
> Hi
> How big is your database?
> It might take time .For example if the database is 20GB and you set a 20%
> growth rate that means if the database grows it will increase by 2GB.
This
> may or may not be what you want.
>
>
>
> "eXavier" <fhns@.centrum.cz> wrote in message
> news:ekIyJogWFHA.2740@.TK2MSFTNGP14.phx.gbl...
> > Hi all,
> > we encountered problem on testing environment that database does not
grow
> > even though it is configured to grow automatically. There is SQL Server
> 2000
> > installed on two Windows Server 2003 in cluster. Application runs on its
> > dedicated WinServer using ADO.NET for data manipulation. When data file
is
> > full (or it remains only small free space ~2MB), all application's db
> > requests fail with timeout. When I manually enlarge data file,
application
> > starts to work again.
> > Is there any known issue regarding to automatical grow of database. Does
> > anyone face this problem ?
> >
> > eXavier
> >
> >
>|||Well, what is about your hardware? Do you have enough space for the database
file?
How many users connected to the database? Have you checked are there
blocking,locking?
Try to change a TimeOut command to 0
"eXavier" <fhns@.centrum.cz> wrote in message
news:OS9EcBhWFHA.3840@.tk2msftngp13.phx.gbl...
> After restore, the database is about 1.7 GB, I tried to set growing to
> both - fixed amount and percentage factor with no success. When I did SQL
> insert from QA - it took about 3 minutes but the file increased. I have
only
> 60 seconds timeout on ADO connection string, may it be that timeouting of
> connection prior to data are inserted could cause not performing of file
> growth ?
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23gBBktgWFHA.2572@.TK2MSFTNGP14.phx.gbl...
> > Hi
> > How big is your database?
> > It might take time .For example if the database is 20GB and you set a
20%
> > growth rate that means if the database grows it will increase by 2GB.
> This
> > may or may not be what you want.
> >
> >
> >
> >
> >
> >
> >
> > "eXavier" <fhns@.centrum.cz> wrote in message
> > news:ekIyJogWFHA.2740@.TK2MSFTNGP14.phx.gbl...
> > > Hi all,
> > > we encountered problem on testing environment that database does not
> grow
> > > even though it is configured to grow automatically. There is SQL
Server
> > 2000
> > > installed on two Windows Server 2003 in cluster. Application runs on
its
> > > dedicated WinServer using ADO.NET for data manipulation. When data
file
> is
> > > full (or it remains only small free space ~2MB), all application's db
> > > requests fail with timeout. When I manually enlarge data file,
> application
> > > starts to work again.
> > > Is there any known issue regarding to automatical grow of database.
Does
> > > anyone face this problem ?
> > >
> > > eXavier
> > >
> > >
> >
> >
>|||First off you should never rely on Autogrow to do the work for you. You
should always have plenty of free space in the files so Autogrow never kicks
in. If a thread invokes the autogrow process and during the growth the user
connection times out it can roll back the growth that it did as well. So it
may not look like it grew when in fact it did and then shrunk again. Never
use the default of 10% on anything over a few hundred MB's. And make it just
a few MB so as you are sure it will grow in less than 30 seconds if you have
a slow disk subsystem.
--
Andrew J. Kelly SQL MVP
"eXavier" <fhns@.centrum.cz> wrote in message
news:ekIyJogWFHA.2740@.TK2MSFTNGP14.phx.gbl...
> Hi all,
> we encountered problem on testing environment that database does not grow
> even though it is configured to grow automatically. There is SQL Server
> 2000
> installed on two Windows Server 2003 in cluster. Application runs on its
> dedicated WinServer using ADO.NET for data manipulation. When data file is
> full (or it remains only small free space ~2MB), all application's db
> requests fail with timeout. When I manually enlarge data file, application
> starts to work again.
> Is there any known issue regarding to automatical grow of database. Does
> anyone face this problem ?
> eXavier
>|||Thank you for your explanation. In fact, I was facing similar issue, when
transaction log was growing too fast and when it was about 2 GB, the
application also started to timeout. To avoid this I created job for
shrinking transaction log every midnight. Is it good practice to do some
file size check/grow job yet?
eXavier
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23f3AFLhWFHA.3176@.TK2MSFTNGP12.phx.gbl...
> First off you should never rely on Autogrow to do the work for you. You
> should always have plenty of free space in the files so Autogrow never
kicks
> in. If a thread invokes the autogrow process and during the growth the
user
> connection times out it can roll back the growth that it did as well. So
it
> may not look like it grew when in fact it did and then shrunk again.
Never
> use the default of 10% on anything over a few hundred MB's. And make it
just
> a few MB so as you are sure it will grow in less than 30 seconds if you
have
> a slow disk subsystem.
> --
> Andrew J. Kelly SQL MVP
>
> "eXavier" <fhns@.centrum.cz> wrote in message
> news:ekIyJogWFHA.2740@.TK2MSFTNGP14.phx.gbl...
> > Hi all,
> > we encountered problem on testing environment that database does not
grow
> > even though it is configured to grow automatically. There is SQL Server
> > 2000
> > installed on two Windows Server 2003 in cluster. Application runs on its
> > dedicated WinServer using ADO.NET for data manipulation. When data file
is
> > full (or it remains only small free space ~2MB), all application's db
> > requests fail with timeout. When I manually enlarge data file,
application
> > starts to work again.
> > Is there any known issue regarding to automatical grow of database. Does
> > anyone face this problem ?
> >
> > eXavier
> >
> >
>|||Why are you shrinking the files? You just proved to yourself that the
growth was causing problems and yet you still continue to shrink. Have a
look here:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Andrew J. Kelly SQL MVP
"eXavier" <fhns@.centrum.cz> wrote in message
news:eIfscSiWFHA.1796@.TK2MSFTNGP15.phx.gbl...
> Thank you for your explanation. In fact, I was facing similar issue, when
> transaction log was growing too fast and when it was about 2 GB, the
> application also started to timeout. To avoid this I created job for
> shrinking transaction log every midnight. Is it good practice to do some
> file size check/grow job yet?
> eXavier
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23f3AFLhWFHA.3176@.TK2MSFTNGP12.phx.gbl...
>> First off you should never rely on Autogrow to do the work for you. You
>> should always have plenty of free space in the files so Autogrow never
> kicks
>> in. If a thread invokes the autogrow process and during the growth the
> user
>> connection times out it can roll back the growth that it did as well. So
> it
>> may not look like it grew when in fact it did and then shrunk again.
> Never
>> use the default of 10% on anything over a few hundred MB's. And make it
> just
>> a few MB so as you are sure it will grow in less than 30 seconds if you
> have
>> a slow disk subsystem.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "eXavier" <fhns@.centrum.cz> wrote in message
>> news:ekIyJogWFHA.2740@.TK2MSFTNGP14.phx.gbl...
>> > Hi all,
>> > we encountered problem on testing environment that database does not
> grow
>> > even though it is configured to grow automatically. There is SQL Server
>> > 2000
>> > installed on two Windows Server 2003 in cluster. Application runs on
>> > its
>> > dedicated WinServer using ADO.NET for data manipulation. When data file
> is
>> > full (or it remains only small free space ~2MB), all application's db
>> > requests fail with timeout. When I manually enlarge data file,
> application
>> > starts to work again.
>> > Is there any known issue regarding to automatical grow of database.
>> > Does
>> > anyone face this problem ?
>> >
>> > eXavier
>> >
>> >
>>
>|||I shrink the transaction log because the application hangs if the file
becomes too large (~2GB). There is enough space on disk array (~40GB).
Probably it could be the same problem as with data file - timeouted
connection together with autogrow, I'll have to test it.
If I 'd set max size of log file, does SQL Server reuses the file from
beggining ? Now it looks like the log size is still increasing, appending
data at the end - this is the reason for my daily shrink. (I left default
values for auto grow - i.e. unrestricted grow by 10%, I'll change it.). What
are best practices for setting size / max siz of database/log. I expect data
file size could be 5-10 GB in my application, but don't have idea about
optimal size of transaction log and if it is better to set max size or
rather letting it grow unrestricted.
The application is highly transactional, but there are typically not much
transactions running in parallel - it processes text-based business messages
mapping them to database - several clients then operates on data typically
changing states again in DB transaction.
Do you have any tips or could you recomend some articles or books on this
topic ?
Thanks a lot
eXavier
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uwlMFsiWFHA.796@.TK2MSFTNGP09.phx.gbl...
> Why are you shrinking the files? You just proved to yourself that the
> growth was causing problems and yet you still continue to shrink. Have a
> look here:
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Andrew J. Kelly SQL MVP
>
> "eXavier" <fhns@.centrum.cz> wrote in message
> news:eIfscSiWFHA.1796@.TK2MSFTNGP15.phx.gbl...
> > Thank you for your explanation. In fact, I was facing similar issue,
when
> > transaction log was growing too fast and when it was about 2 GB, the
> > application also started to timeout. To avoid this I created job for
> > shrinking transaction log every midnight. Is it good practice to do some
> > file size check/grow job yet?
> >
> > eXavier
> >
> > "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> > news:%23f3AFLhWFHA.3176@.TK2MSFTNGP12.phx.gbl...
> >> First off you should never rely on Autogrow to do the work for you.
You
> >> should always have plenty of free space in the files so Autogrow never
> > kicks
> >> in. If a thread invokes the autogrow process and during the growth the
> > user
> >> connection times out it can roll back the growth that it did as well.
So
> > it
> >> may not look like it grew when in fact it did and then shrunk again.
> > Never
> >> use the default of 10% on anything over a few hundred MB's. And make it
> > just
> >> a few MB so as you are sure it will grow in less than 30 seconds if you
> > have
> >> a slow disk subsystem.
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >>
> >> "eXavier" <fhns@.centrum.cz> wrote in message
> >> news:ekIyJogWFHA.2740@.TK2MSFTNGP14.phx.gbl...
> >> > Hi all,
> >> > we encountered problem on testing environment that database does not
> > grow
> >> > even though it is configured to grow automatically. There is SQL
Server
> >> > 2000
> >> > installed on two Windows Server 2003 in cluster. Application runs on
> >> > its
> >> > dedicated WinServer using ADO.NET for data manipulation. When data
file
> > is
> >> > full (or it remains only small free space ~2MB), all application's db
> >> > requests fail with timeout. When I manually enlarge data file,
> > application
> >> > starts to work again.
> >> > Is there any known issue regarding to automatical grow of database.
> >> > Does
> >> > anyone face this problem ?
> >> >
> >> > eXavier
> >> >
> >> >
> >>
> >>
> >
> >
>|||> the application hangs if the file
> becomes too large (~2GB
Yes, because with a 2GB log and 10% growth you are forcing SQL Server
to allocate upto 200MB in a transaction! Best policy is to assess the
correct size under test conditions, then fix the size and leave it. No
shrinking and no autogrow. Log usage should be controlled by the
frequency of log backups, not by shrinking. Shrinking achieves nothing
in a production OLTP environment.
Once you've fixed the size, monitor usage and create a new log file if
you need one rather than increase the size of the existing one. Since
your file system will already be highly fragmented you should probably
start afresh with a new file of the correct size for optimum
performance.
--
David Portas
SQL Server MVP
--|||> If I 'd set max size of log file, does SQL Server reuses the file from
> beggining ?
If SQL Server were to do that, you could end up in a situation where SQL Server had break your
sequence of transaction log backup files. If the db is in full recovery model, the log is emptied
when you do log backup. If you don't do log backup, run in simple recovery mode.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"eXavier" <fhns@.centrum.cz> wrote in message news:ufn39WjWFHA.3240@.TK2MSFTNGP10.phx.gbl...
>I shrink the transaction log because the application hangs if the file
> becomes too large (~2GB). There is enough space on disk array (~40GB).
> Probably it could be the same problem as with data file - timeouted
> connection together with autogrow, I'll have to test it.
> If I 'd set max size of log file, does SQL Server reuses the file from
> beggining ? Now it looks like the log size is still increasing, appending
> data at the end - this is the reason for my daily shrink. (I left default
> values for auto grow - i.e. unrestricted grow by 10%, I'll change it.). What
> are best practices for setting size / max siz of database/log. I expect data
> file size could be 5-10 GB in my application, but don't have idea about
> optimal size of transaction log and if it is better to set max size or
> rather letting it grow unrestricted.
> The application is highly transactional, but there are typically not much
> transactions running in parallel - it processes text-based business messages
> mapping them to database - several clients then operates on data typically
> changing states again in DB transaction.
> Do you have any tips or could you recomend some articles or books on this
> topic ?
> Thanks a lot
> eXavier
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uwlMFsiWFHA.796@.TK2MSFTNGP09.phx.gbl...
>> Why are you shrinking the files? You just proved to yourself that the
>> growth was causing problems and yet you still continue to shrink. Have a
>> look here:
>> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "eXavier" <fhns@.centrum.cz> wrote in message
>> news:eIfscSiWFHA.1796@.TK2MSFTNGP15.phx.gbl...
>> > Thank you for your explanation. In fact, I was facing similar issue,
> when
>> > transaction log was growing too fast and when it was about 2 GB, the
>> > application also started to timeout. To avoid this I created job for
>> > shrinking transaction log every midnight. Is it good practice to do some
>> > file size check/grow job yet?
>> >
>> > eXavier
>> >
>> > "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> > news:%23f3AFLhWFHA.3176@.TK2MSFTNGP12.phx.gbl...
>> >> First off you should never rely on Autogrow to do the work for you.
> You
>> >> should always have plenty of free space in the files so Autogrow never
>> > kicks
>> >> in. If a thread invokes the autogrow process and during the growth the
>> > user
>> >> connection times out it can roll back the growth that it did as well.
> So
>> > it
>> >> may not look like it grew when in fact it did and then shrunk again.
>> > Never
>> >> use the default of 10% on anything over a few hundred MB's. And make it
>> > just
>> >> a few MB so as you are sure it will grow in less than 30 seconds if you
>> > have
>> >> a slow disk subsystem.
>> >>
>> >> --
>> >> Andrew J. Kelly SQL MVP
>> >>
>> >>
>> >> "eXavier" <fhns@.centrum.cz> wrote in message
>> >> news:ekIyJogWFHA.2740@.TK2MSFTNGP14.phx.gbl...
>> >> > Hi all,
>> >> > we encountered problem on testing environment that database does not
>> > grow
>> >> > even though it is configured to grow automatically. There is SQL
> Server
>> >> > 2000
>> >> > installed on two Windows Server 2003 in cluster. Application runs on
>> >> > its
>> >> > dedicated WinServer using ADO.NET for data manipulation. When data
> file
>> > is
>> >> > full (or it remains only small free space ~2MB), all application's db
>> >> > requests fail with timeout. When I manually enlarge data file,
>> > application
>> >> > starts to work again.
>> >> > Is there any known issue regarding to automatical grow of database.
>> >> > Does
>> >> > anyone face this problem ?
>> >> >
>> >> > eXavier
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>

Saturday, February 25, 2012

Autogrowth automatically set to 640 percent

Hello,
I've configured SQL Server 2005 express to use autogrowth by 5mb.
After a few weeks the autogrowth option automatically switched to 640
percent what will lead to performance problems.
After is set back the autogrowth to 5mb, a few weeks later the same
problem occurs.
Does anyone know what can cause this problem?
Thanks in advance,
PimWhich servicepack is installed?
You can disable autogrow and set the database size manually as temporarly
workaround.
greetz
"Pim75" wrote:
> Hello,
> I've configured SQL Server 2005 express to use autogrowth by 5mb.
> After a few weeks the autogrowth option automatically switched to 640
> percent what will lead to performance problems.
> After is set back the autogrowth to 5mb, a few weeks later the same
> problem occurs.
> Does anyone know what can cause this problem?
> Thanks in advance,
> Pim
>|||hi
make sure no one else is playing with the server
Regards
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"Pim75" <p.megens@.tiscali.nl> wrote in message
news:1181732495.637264.178440@.d30g2000prg.googlegroups.com...
> Hello,
> I've configured SQL Server 2005 express to use autogrowth by 5mb.
> After a few weeks the autogrowth option automatically switched to 640
> percent what will lead to performance problems.
> After is set back the autogrowth to 5mb, a few weeks later the same
> problem occurs.
> Does anyone know what can cause this problem?
> Thanks in advance,
> Pim
>|||We use Microsoft SQL Server Express Edition, version 9.00.1399.06
Windows 2003 webserver edition, servicepack 1.
We have some more servers but this is the only one where the problem
occurs.
On 13 jun, 13:37, Hate_orphaned_users
<Hateorphanedus...@.discussions.microsoft.com> wrote:
> Which servicepack is installed?
> You can disable autogrow and set the database size manually as temporarly
> workaround.
> greetz
>
> "Pim75" wrote:
> > Hello,
> > I've configured SQL Server 2005 express to use autogrowth by 5mb.
> > After a few weeks the autogrowth option automatically switched to 640
> > percent what will lead to performance problems.
> > After is set back the autogrowth to 5mb, a few weeks later the same
> > problem occurs.
> > Does anyone know what can cause this problem?
> > Thanks in advance,
> > Pim- Tekst uit oorspronkelijk bericht niet weergeven -
> - Tekst uit oorspronkelijk bericht weergeven -|||Pim75 wrote:
> Hello,
> I've configured SQL Server 2005 express to use autogrowth by 5mb.
> After a few weeks the autogrowth option automatically switched to 640
> percent what will lead to performance problems.
> After is set back the autogrowth to 5mb, a few weeks later the same
> problem occurs.
> Does anyone know what can cause this problem?
> Thanks in advance,
> Pim
>
Hi
Not that it helps you a lot, but we see the same thing happening on one
specific database. Occasionally the mdf file for this database is being
set to a growth rate of 12800% and then the file is around 258 GB.
This has started after we moved this database from a SQL2000 server to a
SQL2005 server. The vendor knows about the issue and they has the same
problem with a few other customers. Since it happens quite seldom, they
haven't been able to figure out what it is that causes it to happen. As
a temporary workaround, I'v written a little sql script that runs every
15 minuttes to check the filesize and filegrowth. If one of them has
changed since last run it sends me an email. I can then go in an correct
the values.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Personally I would just set the job to issue the necessary ALTER DATABASE
statement to fix the growth increment when identified (as well as send an
email that it had been done).
Also, I didn't investigate, but it may be possible to use a DDL trigger to
trap ALTER DATABASE calls on this database to 1) prevent the growth factor
change and 2) identify the offending code and get it fixed.
--
TheSQLGuru
President
Indicium Resources, Inc.
""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:%23lpkSXbrHHA.1296@.TK2MSFTNGP06.phx.gbl...
> Pim75 wrote:
>> Hello,
>> I've configured SQL Server 2005 express to use autogrowth by 5mb.
>> After a few weeks the autogrowth option automatically switched to 640
>> percent what will lead to performance problems.
>> After is set back the autogrowth to 5mb, a few weeks later the same
>> problem occurs.
>> Does anyone know what can cause this problem?
>> Thanks in advance,
>> Pim
> Hi
> Not that it helps you a lot, but we see the same thing happening on one
> specific database. Occasionally the mdf file for this database is being
> set to a growth rate of 12800% and then the file is around 258 GB.
> This has started after we moved this database from a SQL2000 server to a
> SQL2005 server. The vendor knows about the issue and they has the same
> problem with a few other customers. Since it happens quite seldom, they
> haven't been able to figure out what it is that causes it to happen. As a
> temporary workaround, I'v written a little sql script that runs every 15
> minuttes to check the filesize and filegrowth. If one of them has changed
> since last run it sends me an email. I can then go in an correct the
> values.
>
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator

Autogrowth automatically set to 640 percent

Hello,
I've configured SQL Server 2005 express to use autogrowth by 5mb.
After a few weeks the autogrowth option automatically switched to 640
percent what will lead to performance problems.
After is set back the autogrowth to 5mb, a few weeks later the same
problem occurs.
Does anyone know what can cause this problem?
Thanks in advance,
Pim
Which servicepack is installed?
You can disable autogrow and set the database size manually as temporarly
workaround.
greetz
"Pim75" wrote:

> Hello,
> I've configured SQL Server 2005 express to use autogrowth by 5mb.
> After a few weeks the autogrowth option automatically switched to 640
> percent what will lead to performance problems.
> After is set back the autogrowth to 5mb, a few weeks later the same
> problem occurs.
> Does anyone know what can cause this problem?
> Thanks in advance,
> Pim
>
|||We use Microsoft SQL Server Express Edition, version 9.00.1399.06
Windows 2003 webserver edition, servicepack 1.
We have some more servers but this is the only one where the problem
occurs.
On 13 jun, 13:37, Hate_orphaned_users
<Hateorphanedus...@.discussions.microsoft.com> wrote:
> Which servicepack is installed?
> You can disable autogrow and set the database size manually as temporarly
> workaround.
> greetz
>
> "Pim75" wrote:
>
>
> - Tekst uit oorspronkelijk bericht weergeven -
|||Pim75 wrote:
> Hello,
> I've configured SQL Server 2005 express to use autogrowth by 5mb.
> After a few weeks the autogrowth option automatically switched to 640
> percent what will lead to performance problems.
> After is set back the autogrowth to 5mb, a few weeks later the same
> problem occurs.
> Does anyone know what can cause this problem?
> Thanks in advance,
> Pim
>
Hi
Not that it helps you a lot, but we see the same thing happening on one
specific database. Occasionally the mdf file for this database is being
set to a growth rate of 12800% and then the file is around 258 GB.
This has started after we moved this database from a SQL2000 server to a
SQL2005 server. The vendor knows about the issue and they has the same
problem with a few other customers. Since it happens quite seldom, they
haven't been able to figure out what it is that causes it to happen. As
a temporary workaround, I'v written a little sql script that runs every
15 minuttes to check the filesize and filegrowth. If one of them has
changed since last run it sends me an email. I can then go in an correct
the values.
Regards
Steen Schlter Persson
Database Administrator / System Administrator
|||Personally I would just set the job to issue the necessary ALTER DATABASE
statement to fix the growth increment when identified (as well as send an
email that it had been done).
Also, I didn't investigate, but it may be possible to use a DDL trigger to
trap ALTER DATABASE calls on this database to 1) prevent the growth factor
change and 2) identify the offending code and get it fixed.
TheSQLGuru
President
Indicium Resources, Inc.
""Steen Schlter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:%23lpkSXbrHHA.1296@.TK2MSFTNGP06.phx.gbl...
> Pim75 wrote:
> Hi
> Not that it helps you a lot, but we see the same thing happening on one
> specific database. Occasionally the mdf file for this database is being
> set to a growth rate of 12800% and then the file is around 258 GB.
> This has started after we moved this database from a SQL2000 server to a
> SQL2005 server. The vendor knows about the issue and they has the same
> problem with a few other customers. Since it happens quite seldom, they
> haven't been able to figure out what it is that causes it to happen. As a
> temporary workaround, I'v written a little sql script that runs every 15
> minuttes to check the filesize and filegrowth. If one of them has changed
> since last run it sends me an email. I can then go in an correct the
> values.
>
> --
> Regards
> Steen Schlter Persson
> Database Administrator / System Administrator

Autogrowth automatically set to 640 percent

Hello,
I've configured SQL Server 2005 express to use autogrowth by 5mb.
After a few weeks the autogrowth option automatically switched to 640
percent what will lead to performance problems.
After is set back the autogrowth to 5mb, a few weeks later the same
problem occurs.
Does anyone know what can cause this problem?
Thanks in advance,
PimWhich servicepack is installed?
You can disable autogrow and set the database size manually as temporarly
workaround.
greetz
"Pim75" wrote:

> Hello,
> I've configured SQL Server 2005 express to use autogrowth by 5mb.
> After a few weeks the autogrowth option automatically switched to 640
> percent what will lead to performance problems.
> After is set back the autogrowth to 5mb, a few weeks later the same
> problem occurs.
> Does anyone know what can cause this problem?
> Thanks in advance,
> Pim
>|||hi
make sure no one else is playing with the server
Regards
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"Pim75" <p.megens@.tiscali.nl> wrote in message
news:1181732495.637264.178440@.d30g2000prg.googlegroups.com...
> Hello,
> I've configured SQL Server 2005 express to use autogrowth by 5mb.
> After a few weeks the autogrowth option automatically switched to 640
> percent what will lead to performance problems.
> After is set back the autogrowth to 5mb, a few weeks later the same
> problem occurs.
> Does anyone know what can cause this problem?
> Thanks in advance,
> Pim
>|||We use Microsoft SQL Server Express Edition, version 9.00.1399.06
Windows 2003 webserver edition, servicepack 1.
We have some more servers but this is the only one where the problem
occurs.
On 13 jun, 13:37, Hate_orphaned_users
<Hateorphanedus...@.discussions.microsoft.com> wrote:
> Which servicepack is installed?
> You can disable autogrow and set the database size manually as temporarly
> workaround.
> greetz
>
> "Pim75" wrote:
>
>
>
> - Tekst uit oorspronkelijk bericht weergeven -|||Pim75 wrote:
> Hello,
> I've configured SQL Server 2005 express to use autogrowth by 5mb.
> After a few weeks the autogrowth option automatically switched to 640
> percent what will lead to performance problems.
> After is set back the autogrowth to 5mb, a few weeks later the same
> problem occurs.
> Does anyone know what can cause this problem?
> Thanks in advance,
> Pim
>
Hi
Not that it helps you a lot, but we see the same thing happening on one
specific database. Occasionally the mdf file for this database is being
set to a growth rate of 12800% and then the file is around 258 GB.
This has started after we moved this database from a SQL2000 server to a
SQL2005 server. The vendor knows about the issue and they has the same
problem with a few other customers. Since it happens quite seldom, they
haven't been able to figure out what it is that causes it to happen. As
a temporary workaround, I'v written a little sql script that runs every
15 minuttes to check the filesize and filegrowth. If one of them has
changed since last run it sends me an email. I can then go in an correct
the values.
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||Personally I would just set the job to issue the necessary ALTER DATABASE
statement to fix the growth increment when identified (as well as send an
email that it had been done).
Also, I didn't investigate, but it may be possible to use a DDL trigger to
trap ALTER DATABASE calls on this database to 1) prevent the growth factor
change and 2) identify the offending code and get it fixed.
TheSQLGuru
President
Indicium Resources, Inc.
""Steen Schlter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:%23lpkSXbrHHA.1296@.TK2MSFTNGP06.phx.gbl...
> Pim75 wrote:
> Hi
> Not that it helps you a lot, but we see the same thing happening on one
> specific database. Occasionally the mdf file for this database is being
> set to a growth rate of 12800% and then the file is around 258 GB.
> This has started after we moved this database from a SQL2000 server to a
> SQL2005 server. The vendor knows about the issue and they has the same
> problem with a few other customers. Since it happens quite seldom, they
> haven't been able to figure out what it is that causes it to happen. As a
> temporary workaround, I'v written a little sql script that runs every 15
> minuttes to check the filesize and filegrowth. If one of them has changed
> since last run it sends me an email. I can then go in an correct the
> values.
>
> --
> Regards
> Steen Schlter Persson
> Database Administrator / System Administrator

Thursday, March 22, 2012

automatical grow does not work

automatical grow does not work

automatical grow does not work

automatical grow does not work

Saturday, February 25, 2012

Autogrowth automatically set to 640 percent

Autogrowth automatically set to 640 percent

Autogrowth automatically set to 640 percent

Sql Auto grow

Blog Archive

About Me