Re: ISA 2004 / MSDE Error Logging - bug?
- From: "Jim Harrison \(MSFT\)" <jmharr@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 11 Oct 2005 10:06:10 -0700
What you're seeing is the difference between what MSDE supports vs. what you have configured in ISA.
Remember that every day, ISA generates at least 2 log databases (web proxy and firewall); more if your ISA handles lots of traffic.
If you maintain 14 days worth of logs, you will force MSDE to open at least 28 logs, exceeding the 8 concurrent file limitation is
has.
This won't break MSDE, but it can easily impair your logging performance.
--
--
Jim Harrison [ISA SE]
Read the help, books and articles!
This posting is provided "AS IS" with no warranties, and confers no rights.
"fred" <jacma70@xxxxxxx> wrote in message news:AE0335B2-1FA6-416D-9FCD-CE144C59DF3D@xxxxxxxxxxxxxxxx
Hi Bill,
Thanks for the reply. Unfortunately it doesn't answer my queries.
I know these logs relate to SQL (MSDE) rather than the ISA log data. These
error logs are written to when ISA starts.
If I restart ISA now, in these error logs, I will see 000's of entries of
the form "Starting up database 'ISALOG_20050412_WEB_000'". Now I get one of
these messages for everyday that ISA has been installed. This says to me
that MSDE is attempting to open 000's of databases rather than the 14 which
it should have open due to my 14 day retention of ISA logs. Hence the
questions in my original post.
I hope this clarifies my queries.
"Bill Peng [MSFT]" wrote:
> Hi Fred,
>
> Thank you for posting here.
>
> By default, after you installed ISA and configured logging to MSDE,
> ERRORLOG and ERRORLOG.1 through to ERRORLOG.6 already exist. This behavior
> is by design and it is not a bug.
>
> Infact, the log folder only records the logs for the SQL database, not the
> ISA log. The ISA logs are stored in the data folder as database files.
>
> At this point, you do not need to delete any of these logs.
>
> In addition, you can choose to logging into text file instead of databases.
> To do so:
>
> 1. Open ISA Management.
> 2. Click Monitoring and click Logging tab.
> 3. Click Tasks tab.
> 4. You can configure Firewall/Web Proxy/SMTP Message logging settings here.
>
> I hope the above info helps.
>
> If you have any question, please don't hesitate to post back.
>
> Regards,
>
> Bill Peng
> MCSE 2000, MCDBA, CCNP, CCDA
> Microsoft CSS Online Newsgroup Support
>
> Get Secure! - www.microsoft.com/security
> =====================================================
> The public newsgroup only focuses on SBS related technical issues, for
> other Microsoft products, we recommend you to post to appropriate newsgroup
> to get most qualified responses.
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
>
> When opening a new thread via the web interface, we recommend you check the
> "Notify me of replies" box to receive notification. When responding to
> posts via your newsreader, please "Reply to Group" so that others may learn
> and benefit from your issue.
>
> Microsoft engineers can only focus on one issue per thread. Although we
> provide other information for your reference, we recommend you post
> different incidents in different threads to keep the thread clean. In doing
> so, it will ensure your issues are resolved in a timely manner.
>
> For urgent issues, you may want to contact Microsoft PSS directly. Please
> check http://support.microsoft.com for regional support phone numbers.
>
> Any input or comments in this thread are highly appreciated.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --------------------
> >Thread-Topic: ISA 2004 / MSDE Error Logging - bug?
> >thread-index: AcXNsiOEMku8Y/OcSLureEWtQukWaQ==
> >X-WBNR-Posting-Host: 82.71.104.129
> >From: "=?Utf-8?B?ZnJlZA==?=" <jacma70@xxxxxxx>
> >Subject: ISA 2004 / MSDE Error Logging - bug?
> >Date: Mon, 10 Oct 2005 08:49:03 -0700
> >Lines: 21
> >Message-ID: <943DB189-2341-4506-8A3C-4836823E79E0@xxxxxxxxxxxxx>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.isa
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.isa:59598
> >X-Tomcat-NG: microsoft.public.isa
> >
> >Hi
> >ISA 2004 SP1 on Win 2003 SP1 - logging to MSDE. I have noticed some
> rather
> >large files in the \Program files\Microsoft SQL Server\MSSQL$MSFW\Log
> >directory. These are ERRORLOG and ERRORLOG.1 through to ERRORLOG.6.
> >
> >Opening these in Wordpad, it seems that MSDE attempts to start up a
> separate
> >database for every day since ISA was installed (about a year now!) - even
> >though I only retain 14 days of logs. This problem seems to be at the
> root
> >of this ISA box becoming unresponsive after a week or so and needing a
> >reboot. So I have a few questions:
> >
> >Is this a bug - do all these databases really exist in MSDE?
> >Do all these open databases consume resources (memory, handles etc)?
> >How do I remove references to db's older than my 14 day retention?
> >Can I disable this MSDE ERRORLOG function?
> >
> >Many thanks,
> >
> >Fred
> >
> >
> >
>
>
.
- Follow-Ups:
- Re: ISA 2004 / MSDE Error Logging - bug?
- From: fred
- Re: ISA 2004 / MSDE Error Logging - bug?
- References:
- RE: ISA 2004 / MSDE Error Logging - bug?
- From: Bill Peng [MSFT]
- RE: ISA 2004 / MSDE Error Logging - bug?
- From: fred
- RE: ISA 2004 / MSDE Error Logging - bug?
- Prev by Date: Re: Unable to upload with FTP from internet to network with ISA 2004 - Error 550
- Next by Date: Re: please help with very simple (I hope) question
- Previous by thread: RE: ISA 2004 / MSDE Error Logging - bug?
- Next by thread: Re: ISA 2004 / MSDE Error Logging - bug?
- Index(es):
Relevant Pages
|
