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.