RE: SQLSERVE.EXE MSDE instance for ISA 2k4
- From: "Roy Tsao" <roy_tsao@xxxxxxxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Sat, 11 Dec 2004 15:43:08 +0800
----- 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:
