RE: SQLSERVE.EXE MSDE instance for ISA 2k4

The problem with ISA MSDE logging is that it maintains indexes to all
existing log files so that online log queries can be made (Monitoring
tab for non-live queries).
The MSDE logs top out at 2GB per file per day, so you can easily create
multiple files per service per day.
If:
1. you have ISA set to maintain 7 days worth of max file size logs
  and
2. you generate log files of 2GB or more
..you'll be indexing no less than 4GB per day.

Sounds index-expensive to me...

Yes, if you want more strongerer SQL, then change your logging to
off-box SQL.

  Jim Harrison
  MCP(NT4, W2K), A+, Network+, PCG
  http://isaserver.org/Jim_Harrison/
  http://isatools.org
  Read the help / books / articles!
 
 

-----Original Message-----
From: Mike Anderson [mailto:mike@xxxxxxxxxxxx] 
Sent: Friday, December 10, 2004 9:19 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: SQLSERVE.EXE MSDE instance for ISA 2k4

http://www.ISAserver.org

In cases like this, isn't it better to just run a dedicated instance of
SQL Server (if you got it) which resides on a separate box, OR have a
single instance of MSDE host both Databases?

If I remember correctly, MSDE is just a crippled version of SQL Server
7.0 - in which concurrent connections are just limited.  Otherwise, it's
pretty much the same animal.

In fact, since I have a dedicated super fast SQL Server on my network, I
was hoping to uninstall MSDE on the ISA Box, and redirect all the
Database activity to my SQL Server.  Can this be done - anybody do this
yet?

I don't mean to steal the fire away from your original post, but I think
this sort of parallels what I suggest doing, which goes back to the
question: "why have two instances of MSDE running?".  Use the one that
is working better (the one with less memory consumption), and host the
database on that instance.

I am just throwing out ideas here...

Mike 

-----Original Message-----
From: Crockett, Gregory [mailto:Gregory.Crockett@xxxxxxxxx] 
Sent: Friday, December 10, 2004 5:40 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] SQLSERVE.EXE MSDE instance for ISA 2k4

http://www.ISAserver.org

Anyone notice the MSDE instance for ISA 2k4 memory increase to over 1gb
mem usage?  We host two instances of MSDE on the ISA2k4 machine, one for
Surf Control and the other for ISA2K4.  Surf Control instance is stable,
while the ISA 2k4 instance hogs a lot of memory.  Current mem usage =
786,004k.  Wait, wait -- 786,012k , 786,528k and growing. 

MSDE versions:          SurfControl = 8.00.761
                        ISA2k4      = 8.00.818

Server has 3gb memory
ISA2K4 version = trial

TIA

Have fun!

greg

------------------------------------------------------
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
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com Leading
Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org Windows
Security Resource Site: http://www.windowsecurity.com/ Network Security
Library: http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
mike@xxxxxxxxxxxx To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx

------------------------------------------------------
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
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
jim@xxxxxxxxxxxx
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx

All mail to and from this domain is GFI-scanned.



Other related posts: