Okay. Nice to know, but
our recommendation is also SP3a. The problem seems not to be related to Axapta
then, but my described scenarios could also cause similar problems.
Have a nice day.
Med venlig
hilsen / Best regards
Kim Truelsen
Microsoft Denmark
Tuborg Boulevard 12
DK-2900 Hellerup
Phone + 45 44 89 01 00
Mobile + 45 29 49 99 58
mailto:[EMAIL PROTECTED]
From:
juepeterberlin
[mailto:[EMAIL PROTECTED]
Sent: 19.
januar 2004 09:58
To: [EMAIL PROTECTED]
Subject: Re: SV: SV: [development-axapta]
SQL Server 2000: since some weeks DB-size grows
Hi Kim,
installing SP3a for SQL-Server solved the problem.
I don't believe it was one of the reasons below,
because page-density
dropped continually and not in leaps. One table
(salesparmline) did
need 800 MB and 600 MB from this was
"unused" (looked with sp_spaceused).
At the end 1,5 new records (statistically) in
salesparmline led to the
creation of a new page for salesparmline though 20
maxsize-records
should need less than one page.
re 1. no "leaps"
re 2. that would 1 GB more and no exponentially
growth, in fact we had
3,6 GB and a growth of 400-600 MB per day at last.
re 3. indexes, that doens't explain the
"unused" for salesparmline
re 4. that didn't happen, user data input was
"normal" and no external
data import took place.
regards
Jürgen Peter
(CAM
Berlin)
--- In [EMAIL PROTECTED],
"Kim Truelsen \(MICROSOFT
BUSINESS SOLUTIONS\)" <[EMAIL PROTECTED]>
wrote:
> Hi all
>
>
>
> I can maybe give you some explanation why
your database size is growing
>
>
>
> 1. Sometimes
changes in the data model are leading the
synchronization mechanism to create a shadow
"X897" table. All data
from the original table is copied to this table
and the old one
dropped and recreated. The behaviour was very
normal in 2.5, but
doesn't show up that much in 3.0. The space of the
table X897 (where
897 is the number of the table) is the same as the
original and
therefore the used database space will rise.
> 2. Cross
References. If you updated your cross references doing
update or later. It can explain the expansion of
your DB. (Around 1 GB)
> 3. Indexes. If
you have added a lot of indexes on large tables. It
might also explain something.
> 4. Import of external
data and deletion afterwards of the data from
the tables???
>
>
>
> I hope that might give you some clue.
>
>
>
>
>
>
>
> Med venlig hilsen / Best regards
>
> Kim Truelsen
>
>
>
> Microsoft Denmark
>
> Tuborg Boulevard 12
>
> DK-2900 Hellerup
>
>
>
> Phone + 45 44 89 01 00
>
> Mobile + 45 29 49 99 58
>
> mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
>
> ________________________________
>
> From: Torgeir Toms [mailto:[EMAIL PROTECTED]
> Sent: 18. januar 2004 17:27
> To: [EMAIL PROTECTED]
> Subject: SV: SV: SV: [development-axapta] SQL
Server 2000: since
some weeks DB-size grows exponentially
>
>
>
> Very Good - should find out more on this.
Maybe Kim Trulsen on this
list from MBS can throw some light on this ??
>
>
> Med vennlig hilsen
> Torgeir Toms
> Systemkonsulent Teknisk IT
>
> ==================================
> Good Judgment Comes From Experience.
Experiences Comes From Bad
Judgment.
> =====================================
>
> -----Opprinnelig melding-----
> Fra: juepeterberlin
[mailto:[EMAIL PROTECTED]
> Sendt: 18. januar 2004 14:49
> Til: [EMAIL PROTECTED]
> Emne: Re: SV: SV: [development-axapta] SQL
Server 2000: since some
weeks DB-size grows exponentially
>
>
> well whatever the background reason your tip
worked out fine,
>
> many thanks again
> regards
> Jürgen Peter
> (CAM
Berlin)
>
>
>
> --- In [EMAIL PROTECTED],
"Torgeir Toms"
> <[EMAIL PROTECTED]> wrote:
> > No
> > Not realy. Perhaps MSTechnet can
help you
> > Med vennlig hilsen
> > Torgeir Toms
> > Systemkonsulent Teknisk IT
> > _
> >
> > ==================================
> > Good Judgment Comes From Experience.
Experiences Comes From Bad
> Judgment.
> > =====================================
> >
> > -----Opprinnelig melding-----
> > Fra: juepeterberlin
[mailto:[EMAIL PROTECTED]
> > Sendt: 12. januar 2004 22:44
> > Til: [EMAIL PROTECTED]
> > Emne: Re: SV: [development-axapta] SQL
Server 2000: since some
> weeks DB-size grows exponentially
> >
> >
> > Thanks very much Torgeir,
> >
> > we will try that.
> >
> > Do you know more about the background of
this error?
> >
> > regards
> > Jürgen Peter
> > (CAM
Berlin GmbH)
> >
> >
> > --- In [EMAIL PROTECTED],
"Torgeir Toms"
> > <[EMAIL PROTECTED]> wrote:
> > > i have experienced that - its an
error in SQL Server. I applyed
> > SP3a. It fixed it
> > >
> > >
> > > Med vennlig hilsen
> > > Torgeir Toms
> > > Systemkonsulent Teknisk IT
> > > ==================================
> > > Good Judgment Comes From
Experience. Experiences Comes From Bad
> > Judgment.
> > >
=====================================
> > >
> > > -----Opprinnelig melding-----
> > > Fra: Preston A. Larimer
[mailto:[EMAIL PROTECTED]
> > > Sendt: 12. januar 2004 16:05
> > > Til: [EMAIL PROTECTED]
> > > Emne: RE: [development-axapta] SQL
Server 2000: since some weeks
> > DB-size grows exponentially
> > >
> > >
> > > Looks like you have 3 gigs of
unused space, more than likely
> > during the upgrade your database grew in
size due to the
> transaction
> > logs and it hasn't shrunk back
yet. If your maintenance jobs and
> > backups are set correctly to shrink the
database you should see
> the
> > size deflate on the next scheduled
maintenance run or you could
> > always try to shrink the files manually
from the enterprise
> manager,
> > back up first though.
> > >
> > > -Preston
> > >
> > > -----Original Message-----
> > > From: juepeterberlin
[mailto:[EMAIL PROTECTED]
> > > Sent: Monday, January 12, 2004 9:51
AM
> > > To: [EMAIL PROTECTED]
> > > Subject: [development-axapta] SQL
Server 2000: since some weeks
> DB-
> > size grows exponentially
> > >
> > > Hi all,
> > >
> > > since some weeks our DB-size went
from 2GB to 5.5 GB although
> the
> > > user data input was more or less
the same.
> > >
> > > sp_spaceused on the DB results in
> > >
> > > database_size 5620.00 MB
> > > unallocated space 50.03 MB
> > > reserved 5375968 KB
> > > data 1516608 KB
> > > index_size 818368 KB
> > > unused 3040992
KB
> > >
> > > We use Axapta 3.0 SP2 with SQL
Server 2000. There is a
> > possibility,
> > > that this growth began with going
from SP1 to SP2.
> > >
> > > Does someone know anything how such
unusual database growth and
> > > such an high "unused"
factor could happen?
> > >
> > >
> > > regards
> > > Jürgen Peter
> > > (CAM
Berlin GmbH)
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> > >
· To visit your group on the
web, go to:
> > > http://groups.yahoo.com/group/development-axapta/
> > >
> > >
· To unsubscribe from this group,
send an email to:
> > >
[EMAIL PROTECTED]
> > >
> > >
· Your use of Yahoo! Groups is
subject to the Yahoo!
> Terms
> > of Service.
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > > To visit your group on the web, go
to:
> > > http://groups.yahoo.com/group/development-axapta/
> > >
> > > To unsubscribe from this group,
send an email to:
> > > [EMAIL PROTECTED]
> > >
> > > Your use of Yahoo! Groups is
subject to the Yahoo! Terms of
> > Service.
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/development-axapta/
> >
> > To unsubscribe from this group, send an
email to:
> >
[EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to
the Yahoo! Terms of
> Service.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>
> To unsubscribe from this group, send an email
to:
>
[EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
Yahoo! Terms of Service.
>
> ________________________________
>
> Yahoo! Groups Links
>
> * To visit your
group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>
> * To unsubscribe
from this group, send an email to:
>
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>=
>
> * Your use of
Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/>
.
Yahoo! Groups Links
