Message 2: Re: OPtimize SQL & Emerald
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 3: RadiusNT startup
from "Robert H. Clugston" <robert@csnsys.com>
Message 4: Re: OPtimize SQL & Emerald
from John Lange <radadmin@palacenet.net>
Message 5: Expire field locked out
from "John Dodd" <jmdodd@mychoice.net>
Message 6: Re: Expire field locked out
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 7: Re: OPtimize SQL & Emerald
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 8: Re: RadiusNT startup
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 9: Re: OPtimize SQL & Emerald
from John Lange <radadmin@palacenet.net>
Message 10: Re: Expire field locked out
from "John Dodd" <jmdodd@mychoice.net>
Message 11: Re: Expire field locked out
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 12: Database Full
from "Robert H. Clugston" <robert@csnsys.com>
Message 13: RE: Expire field locked out
from "Gary Walworth" <garydean@beachlink.com>
Message 14: Re: New NAS
from Duane Schaub <dschaub@terraworld.net>
Message 15: Re: New NAS
from John Lange <radadmin@palacenet.net>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: OPtimize SQL & Emerald
From: John Lange <radadmin@palacenet.net>
Date: Thu, 09 Jul 1998 12:01:53 -0500
HI
We are setting up a new SQL server and have a few questions.
New System:
PII 233 - 128MB - 9GB UW SCSI - 3C905B-TX & 10/100MB Hub, etc.
I notice that SQL on our current server only uses about 8 MB ram.
How do I tell SQL to use all the ram in the system - ie: 96 to 128 MB ram?
Will this make Emerald & SQL faster?
What is the optimal amount of ram for SQL, Emerald with 500MB database?
Would adding Seagate Backup Exec Enterprise to this server detract from
it's performance?
I really appreciate any help you all can give me on this topic.
Thanks
JOhn :}
John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers, Inc.
608.742.1601 & 6980 2800 New Pinery Road
http://www.palacenet.net/ Portage, WI 53901
Visit our online store @ http://www.microt.com/
Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: OPtimize SQL & Emerald
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Thu, 09 Jul 1998 11:00:41 -0700
John Lange wrote:
>
> We are setting up a new SQL server and have a few questions.
>
> New System:
> PII 233 - 128MB - 9GB UW SCSI - 3C905B-TX & 10/100MB Hub, etc.
>
> I notice that SQL on our current server only uses about 8 MB ram.
>
> How do I tell SQL to use all the ram in the system - ie: 96 to 128 MB ram?
You can tell SQL Server the max amount of ram to use in the
confgiuration
tab. Right click over your server in EM, select configure. Go to the
COnfiguration tab, and find memory. Set it to 1/2 of what you want,
since
its in 2k block. For Example 40000 would be 80mb.
> Will this make Emerald & SQL faster?
Definately.
> What is the optimal amount of ram for SQL, Emerald with 500MB database?
I like to have the same amount of RAM as the size of the database. This
isn't always feasible, but the rule is the more ram you have, the faster
SQL Server will run.
> Would adding Seagate Backup Exec Enterprise to this server detract from
> it's performance?
Only when its doing a backup. BE typically uses over 50% of the CPU to
backup (unless you have a slow network). At night its typically not
an issue (but you better have a lot of ram).
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RadiusNT startupFrom: "Robert H. Clugston" <robert@csnsys.com>Date: Thu, 9 Jul 1998 12:04:26 -0700
List, I hardly ever reboot my radius server, but when I do it radius NT doesn'tcome correctly up. I have to stop and restart the service in order for it toauthenticate. I remember I had this problem once before on a differentserver. The problem was that the SQL started after the radius. This isradius NT 2.5. Any ideas?
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: OPtimize SQL & EmeraldFrom: John Lange <radadmin@palacenet.net>Date: Thu, 09 Jul 1998 14:37:28 -0500
HI
Thanks Dale,
I thought there was a way to do this on the fly with an sql command, butcannot remember how. Doing it in the config requires a reboot or sqlre-start, and I cannot take it down right now.
I would like to try it on the current server to help me determine how muchram to put in the new one. Your help is greatly appreciated.
JOhn :}
>> New System:>> PII 233 - 128MB - 9GB UW SCSI - 3C905B-TX & 10/100MB Hub, etc.>> How do I tell SQL to use all the ram in the system - ie: 96 to 128 MB ram?>>You can tell SQL Server the max amount of ram to use in the>confgiuration>its in 2k block. For Example 40000 would be 80mb.
John C. Lange, Sr. PALACE dot NET, INC.microjl@palacenet.net MICRO-TECH Computers, Inc.608.742.1601 & 6980 2800 New Pinery Roadhttp://www.palacenet.net/ Portage, WI 53901Visit our online store @ http://www.microt.com/Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
--- __o --- _-\<,_ Fastest Service in Town --- (_)/ (_)
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Expire field locked outFrom: "John Dodd" <jmdodd@mychoice.net>Date: Thu, 9 Jul 1998 15:01:03 -0500
Hi,
We are running Emerald 2.1.11 and Radius 2.5, and have been for a while withvery few problems. Now for some reason I can't change the "Expire" field onthe "Billing" tab. The numbers are gray instead of black. It seems to be apermission problem somewhere, but I'm at a loss as to where to startlooking. I added a new operator hoping Emerald would allocate defaultpermissions, but it didn't help.
Any Ideas? Anyone? Please!!
Just found out that if I add a new customer MBR, then magically I can changethe Expire field on all records. Unfortunately as soon as I close theEmerald Interface and restart it the problem returns...???
ThanksJohn
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Expire field locked outFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 09 Jul 1998 13:19:13 -0700
John Dodd wrote:> > We are running Emerald 2.1.11 and Radius 2.5, and have been for a while with> very few problems. Now for some reason I can't change the "Expire" field on> the "Billing" tab. The numbers are gray instead of black. It seems to be a> permission problem somewhere, but I'm at a loss as to where to start> looking. I added a new operator hoping Emerald would allocate default> permissions, but it didn't help.
In the Emerald Administratorm, uncheck the "restrict expire changing" inthe Config client.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: OPtimize SQL & EmeraldFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 09 Jul 1998 13:26:34 -0700
John Lange wrote:> > I thought there was a way to do this on the fly with an sql command, but> cannot remember how. Doing it in the config requires a reboot or sql> re-start, and I cannot take it down right now.
You have to restart SQL Server no matter which way you change thatsetting.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: RadiusNT startupFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 09 Jul 1998 13:38:08 -0700
Robert H. Clugston wrote:> > I hardly ever reboot my radius server, but when I do it radius NT doesn't> come correctly up. I have to stop and restart the service in order for it to> authenticate. I remember I had this problem once before on a different> server. The problem was that the SQL started after the radius. This is> radius NT 2.5. Any ideas?
Upgrade to the latest RadiusNT 2.5 on the ftp site. We have added someintelligence to the lateset version to make the startup wait if itencounters an error and should resolve this problem.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: OPtimize SQL & EmeraldFrom: John Lange <radadmin@palacenet.net>Date: Thu, 09 Jul 1998 15:35:15 -0500
Your right (Who'd guess)
I was thinking that the sp_configure command would do it on the fly, but itwon't.
ThanksJOhn :}
At 01:26 PM 7/9/1998 -0700, you wrote:>John Lange wrote:>> >> I thought there was a way to do this on the fly with an sql command, but>> cannot remember how. Doing it in the config requires a reboot or sql>> re-start, and I cannot take it down right now.>>You have to restart SQL Server no matter which way you change that>setting.> >>-- >Dale E. Reed Jr. (daler@iea-software.com)>_________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com>>
John C. Lange, Sr. PALACE dot NET, INC.microjl@palacenet.net MICRO-TECH Computers, Inc.608.742.1601 & 6980 2800 New Pinery Roadhttp://www.palacenet.net/ Portage, WI 53901Visit our online store @ http://www.microt.com/Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
--- __o --- _-\<,_ Fastest Service in Town --- (_)/ (_)
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Expire field locked outFrom: "John Dodd" <jmdodd@mychoice.net>Date: Thu, 9 Jul 1998 15:43:47 -0500
Doh! Thanks for the help, but that brings up another question.
With the restrict Expire change checked, why were we able to modify theexpire fields on all records after creating a new account?
Again ThanxJohn
-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: emerald@iea-software.com <emerald@iea-software.com>Date: Thursday, July 09, 1998 3:07 PMSubject: Re: Expire field locked out
>John Dodd wrote:>>>> We are running Emerald 2.1.11 and Radius 2.5, and have been for a whilewith>> very few problems. Now for some reason I can't change the "Expire" fieldon>> the "Billing" tab. The numbers are gray instead of black. It seems tobe a>> permission problem somewhere, but I'm at a loss as to where to start>> looking. I added a new operator hoping Emerald would allocate default>> permissions, but it didn't help.>>In the Emerald Administratorm, uncheck the "restrict expire changing" in>the Config client.>>>-->Dale E. Reed Jr. (daler@iea-software.com)>_________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Expire field locked outFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 09 Jul 1998 15:12:51 -0700
John Dodd wrote:> > Doh! Thanks for the help, but that brings up another question.> > With the restrict Expire change checked, why were we able to modify the> expire fields on all records after creating a new account?
Its most likely a bug. I'll see if its still in 2.5.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Database FullFrom: "Robert H. Clugston" <robert@csnsys.com>Date: Thu, 9 Jul 1998 16:05:19 -0700
Dale, This happens every time I play with my Emerald Database. I've got a 130mBdatabase that is full. I've tried Call Consolidation, but that doesn't work.How can I regain the space?
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Expire field locked outFrom: "Gary Walworth" <garydean@beachlink.com>Date: Thu, 9 Jul 1998 19:26:14 -0400
Can I see if it's in 2.5? :)
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Gary WalworthBeachLink Internet Serviceshttp://www.beachlink.comgarydean@beachlink.comICQ: 257388
> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.> Sent: Thursday, July 09, 1998 6:13 PM> To: emerald@iea-software.com> Subject: Re: Expire field locked out> > > John Dodd wrote:> > > > Doh! Thanks for the help, but that brings up another question.> > > > With the restrict Expire change checked, why were we able to modify the> > expire fields on all records after creating a new account?> > Its most likely a bug. I'll see if its still in 2.5.> > -- > Dale E. Reed Jr. (daler@iea-software.com)> _________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: New NASFrom: Duane Schaub <dschaub@terraworld.net>Date: Fri, 19 Jun 1998 09:15:12 -0500
I have had VERY good luck with my PM3's. Livingston, unlike Ascend,doesn't release code until it is relatively Rock solid. After some effortwith previous Pipeline 50, 75, 130's and Max 1800's - I have sworn off ofall Ascend products except the P50/130 for end customers. The upper endmodels simply don't have the huevos to keep up. Witness the Max 4004 whichwas originally sold as a 96 port solution and has now been de-rated to the4048. The 4004 would only do 60 simultaneous PPP sessions. Computone usedto make a termserver with more ports than it could handle. This was ouroriginal impetus into Livingston. The PM2's were popular for a reason!
In an effort to shave costs, we have recently tried BayNetwork RemoteAccess 5399 and 8000 units. I am here to tell you that BayNetwork does notunderstand the Market. Their product was so complicated that I finallyprinted the 1800 page manual and it took nearly two weeks of configuring toget the thing to accept calls. Now that I am more used to it, they havesome VERY powerful capabilities, but it makes Cisco look like a cakewalk inthe initial configs. I mean this thing has an http server, ftp server,finger server, telnet, temperature readouts.... everything. But don'texpect to make it run right away, and don't try using the "Quick Config"utility that is shipped with the unit... It doesn't work!
One last item.... Compatibility. The Bay Boxes have PISS POORcompatibility with older modems. Specifically, they will NOT connect toUSR (Manufaturer or OEM models) with Eprom dates of 5/30/96. This includesthe TI manufactured Telelink II modems used by Gateway and 10 other leadingcompatible vendors and includes at least 15% of our customers. Even thoughthe problem is actually a USR bug, I have never had a problem with theseusers until the Bay units arrived....
I am currently running the Livingston V.90 beta code. Unlike normal, theyreleased the beta code for general testing. Although the code works well,I get an occasional problem where the PM3 will simply stop authenticating.A code update is expected soon. The previous 56Flex release did not havethese problems. BayNetworks has not released any V.90 code.
Bottom Line... We have $100K of Bay equipment that is being exchanged forPM3/4's. For the ISP... BAY SUCKS!
On the positive note - They have Very responsive support (not free) withoutwhich these boxes would have been dumped when they arrived.
Duane Schaub.
At 10:51 AM 7/8/98 -0500, you wrote:>I will be upgrading our NAS to do 56k and have found that populating my max >with 56k cards would cost more than buying a new max already populated with >modems.
================================================================Terra World, Inc. | Duane Schaub200 ARCO Place, Suite 252 | PresidentIndependence, KS 67301 | dschaub@terraworld.net(316) 332-1616, Toll Free (888) 332-1616 | www.terraworld.netFax: (316) 332-1451 | S.E. Kansas Largest Internet Provider================================================================
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: New NASFrom: John Lange <radadmin@palacenet.net>Date: Thu, 09 Jul 1998 21:14:55 -0500
[begin vent]
My 2 cents worth...
At 09:15 AM 6/19/1998 -0500, you wrote:>I have had VERY good luck with my PM3's.
I love my PM3's even with the beta v.90 code "GREAT" support for USR v.90and NO support for Rockwell v.90 (imagine that...from a kFlux company). Myold PM2's & Sportsters, were even more reliable.
>Livingston, unlike Ascend, doesn't release code until it is relativelyRock solid.
This is weird, Ascend called me today to tell me that their v.90 code is nolonger beta. I told them to late, and stop calling. We just spent $50K onnew Livingston/Lucent equipment.
The USR eWhine list has more complaints then all the other lists together.And the $2K per year for service contracts are a joke.
All the other stuff on the market is either unsupported junk or WAY toexpensive. Or has more bells & wistles than we will ever need, Unless GTE-North starts spending some of the money We pay them. Can't doBRI can't do PRI, lucky to be able to do trunkside CT1, untill last monthwe had lineside.
[end of vent]JOhn :}
John C. Lange, Sr. PALACE dot NET, INC.microjl@palacenet.net MICRO-TECH Computers, Inc.608.742.1601 & 6980 2800 New Pinery Roadhttp://www.palacenet.net/ Portage, WI 53901Visit our online store @ http://www.microt.com/Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
--- __o --- _-\<,_ Fastest Service in Town --- (_)/ (_)