RE: SQLSERVE.EXE MSDE instance for ISA 2k4

----- Original Message ----- 
From: "Roy Tsao" <roy_tsao@xxxxxxxxxxxx>
To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
Sent: Saturday, December 11, 2004 3:39 PM
Subject: Re: [isalist] RE: SQLSERVE.EXE MSDE instance for ISA 2k4


>I think the best way to improve performance of SQL database 
> at ISA 2K4 server is:
>   - install ISA2K4 (with bundled MSDE)
>   - upgrade ISA2K4 database instance "server\msfw"
>     into full version of SQL server 2000 by installation
>     of SQL server 2000
>   - at this end, ISA2K4 is managed under SQL2000 server
>   - when need to install Surfcontrol, use the same instance
>     "server\msfw", no need to install MSDE supplied by
>     Surfcontrol
> please comment.
> ----- Original Message ----- 
> From: "Mike Anderson" <mike@xxxxxxxxxxxx>
> To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
> Sent: Saturday, December 11, 2004 1:19 PM
> 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: 
> roy_tsao@xxxxxxxxxxxx
> To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist
> Report abuse to listadmin@xxxxxxxxxxxxx

Other related posts: