Hello Mike,
I'm currently using Microsoft SQL v7 already. I've also ran the MS-SQL v7 index tuning wizard, and it did not find any optimizations.
When I set up the database on MS-SQL, I'm just using createdb script that came with RAdmin, and I hope that's OK.
The puzzling part is whenever I stop and restart Radiator on NT, the TPS would go back up to 12 and then degrade back down to 4 again quickly after several thousands AUTH requests. Would that imply any kind of memory leaks, etc. with the specific combination of Radiator/ACTIVESTATE PERL/NT/ODBC ? Are you aware of any successful high performance deployment of Radiator on a NT and MS-SQL based configuration?
By the way, the supplier of ActiveState Perl is also selling something called PerlEx which will accelerate PERL performance on NT. Would that help?
Thanks for help.
Cheers
> -----Original Message-----
> From: Mike McCauley [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 28, 1999 8:19 AM
> To: Jonathan Ng; '[EMAIL PROTECTED]'
> Subject: Re: (RADIATOR) performance issue with Radiator & MS-SQL
>
>
> Hello Jonathan,
>
> On Dec 26, 4:41pm, Jonathan Ng wrote:
> > Subject: (RADIATOR) performance issue with Radiator & MS-SQL
> >
> > I've installed Radiator v2.1.4 and Radmin v1.3 on one NT
> Server, and MS
> > SQL on another NT Server. Both servers are based on
> PIII-500MHz with
> > 256MB RAM and SCSI disk.
> >
> > I measured the average throughput with the following command:
> >
> > radpwtst -iterations 1000 -noacct -user john -password hello -time
> >
> > The best number I could get is around 12 transactions per
> sec. The NT
> > server running Radiator is only 20% utillized for CPU.
> The NT server
> > running MS-SQL is around 50% utlitilzed for CPU. It seems
> a bit low to
> > me.
> >
> > The interesting part is when I keep on running the radpwtst
> above, the
> > number will keep on going down to around 5 tps. However,
> whenever I
> > stop and restart Radiator, the performance number will go
> back up to 12
> > tps, and then degrade again. Is that indicative of some issue with
> > Radiator configuration?
>
> Given those figures, I think that the limiting factor is in
> the MS-SQL server.
> Before migrating to 7.0 as Tim Minchin suggests, I would be
> inclined to check
> whether the indexes in the tables your Radiator accesses are OK.
>
> >
> > I would like to find out if the above results are typical,
> and what are
> > the numbers that others are observing on a NT-based setup
> using MS-SQL.
>
> On such boxes, I would expect to see considerably better performance.
>
> Cheers.
>
> --
> Mike McCauley [EMAIL PROTECTED]
> Open System Consultants Pty. Ltd Unix, Perl,
> Motif, C++, WWW
> 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
> Phone +61 3 9598-0985 Fax +61 3 9598-0955
>
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
> NT, Rhapsody
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>
