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.

Reply via email to