Text 891, 72 rader
Skriven 2004-10-11 22:58:54 av Geo (1:379/45)
    Kommentar till text 889 av Glenn Meadows (1:379/45)
Ärende: Re: Software Magnate gets spammed, 0wned; sees light
============================================================
From: "Geo" <georger@nls.net>

right click on the database, pick properties

on the options tab select "select into/bulk copy" and "truncate log on
checkpoint"

Geo.

"Glenn Meadows" <gmeadow@comcast.net> wrote in message
news:416ab48a@w3.nls.net...
> Speaking or Transaction Log, I've been unable to successfully get that log
> to auto maintain itself using SQL manager.  We go bopping along fine for
> some time, I keep checking it's size on it's separate 36gig array, and
just
> when they start processing the end of month, or so, BOOM, it fills up, and
> won't let anyone access the system, till BACKUP the transaction log, then
> SHRINK the database.  Very frustrating. (Luckily, I THINK, we'll be off
this
> system in the next few months).  That's going to give me a nice 8 way Dell
> server to play with (if we keep it, which I'm lobbying for, converting it
to
> our primary file sever <smile>).
>
> --
> Glenn M.
>
>
> "Ellen K" <Ellen.K@harborwebs.com> wrote in message
> news:808710.4b1c2e@harborwebs.com...
> > Disk I/O is way more important for database performance than CPU speed.
> Just
> > putting the transaction log on its own array speeds things up
> considerably.
> >
> >
> > > From: "Geo." <georger@nls.net>
> > > It doesn't limit the log to 250K rows, it limits each field to X
> characters.
> > >The 250K limit is because there are time sensitive queries goin on in
> order to
> > > filter the spam, too much time and things start to break so they
limited
> the
> > > log to a rotating 250K lines, add a line and a line pops off the other
> end.
> > > I imagine the faster the box the bigger this limit (it is 250K on
their
> model
> > > 400, the 600 may allow more I dunno but it has a faster cpu).
> > > Geo.
> > > "Ellen K." <72322.enno.esspeeayem.1016@compuserve.com> wrote in
message
> > > news:idnhm0h7icvfgg5jcocqp3r8lrten6d4m6@4ax.com...
> > >> Why would using a SQL database limit the log to 250,000 rows?   I
have
> > >> about 27 million rows in my biggest table.
> > >>
> > >> On Sat, 9 Oct 2004 21:30:38 -0400, "Geo." <georger@nls.net> wrote in
> > >> message <41688f87$1@w3.nls.net>:
> > >>
> > >>>That could be a problem, they use an sql database to hold the message
> log so
> > >> >you only get the last 250,000 connect attempts logged and however
many
> > >> >characters.
> > >>
>
>

--- BBBS/NT v4.01 Flag-5
 * Origin: Barktopia BBS Site http://HarborWebs.com:8081 (1:379/45)