Re: How BAD is SQL on ISA?
- From: "shane mullins" <tsmullins@xxxxxxxxxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Tue, 14 Jan 2003 08:08:25 -0500
Hey William,
We have a very busy ISA server that logs to an sql database on another
server. We have logged on that server before and it did not seem to make
much of a difference. But we moved the database to another server because
it is a better way to go. We log every thing a student does on the internet
and we have about 3000 machines on our WAN. From 8:30 to 3:30 there is
about 300 or more students using the internet.
What you could do is perform the logging on an old internal NT4 box that
everyone has hanging around. It depends on how much data you log, but at
one time we logged to an Access database. But, with Access you can only log
two gigs, or is it four? What we did is have the database recreate itself
when it got full.
Shane
----- Original Message -----
From: "William Robertson" <robertson.william@xxxxxxxxxxxxxx>
To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
Sent: Tuesday, January 14, 2003 5:11 AM
Subject: [isalist] How BAD is SQL on ISA?
> http://www.ISAserver.org
>
>
> Hi there
>
> I live in a principle of least privileges and so I do not install anything
> on my ISA Server which is not absolutely CRUCIAL to the survival of my
> Firewalling Strategy.
>
> However, I have been considering the option to start logging all ISA
> requests to a SQL Database as opposed to flat files which is currently the
> default logging method.
>
> If I was to do this then I would like to keep the ISA Firewall independant
> of any other server and as a result I would need to install SQL Server
> onto my ISA Firewall.
>
> What I would like to know is this:
> 1) Is it at all a good idea to install a product such as SQL Server onto
> my ISA Firewall?
> 2) How robust is ISA when it comes to logging to a SQL Database as opposed
> to the flat files?
> 3) How will it impact any Server Publishing rules that I have already
> created on port 1433 (SQL Server)?
>
> Cheers
> William R.
>
>
> ------------------------------------------------------
> List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
> ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
> ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
> ------------------------------------------------------
> Exchange Server Resource Site: http://www.msexchange.org/
> Windows Security Resource Site: http://www.windowsecurity.com/
> Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
> ------------------------------------------------------
> You are currently subscribed to this ISAserver.org Discussion List as:
tsmullins@xxxxxxxxxxxxxx
> To unsubscribe send a blank email to $subst('Email.Unsub')
>
>
Other related posts:
