Any thoughts on this previous post?
This 100% thing is driving us crazy...
Mike
----------------
Email from: Michael Hobach <radiusnt@iea-software.com>
On 5 Jun 99, at 22:50, Michael Hobach wrote
> We are running RadiusNT 2.5.175 on NT 4.0 SP4 with SQL 7.0.
>
> We migrated to SQL 7.0 from an Access database about a month ago. We
> created the SQL database from the SQL script included with the latest
> version, and then imported the data from the Access database.
>
> Since moving to SQL we have experienced several oddities...
>
> First, with ODBC logging turned on, we keep getting errors logged like
>
> ODBC Error:23000:2627:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY
> KEY constraint 'pk_Calls'. Cannot insert duplicate key in object 'Calls'.
>
> ODBC Error:37000:170:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
> near 's'.
>
>
> Second, about once a week the SQL server goes to 100% processor
> utilization. Stopping RadiusNT and Cold Fusion does nothing. It appears
> that the RadLogs table may be the problem - deleting the RadLogs table
> brings the server back down to realistic CPU utilization.
>
> Thanks in advance...
>
> Mike
>
>
> --------------------------------
> Michael Hobach <mhobach@cyberlynk.net>
> CyberLynk Network, Inc.
> 6214 Washington Ave Suite C16
> Racine, WI 53406
> (414) 884-1088 Fax (414) 884-1053
> http://www.cyberlynk.net
--------------------------------
Michael Hobach <mhobach@cyberlynk.net>
CyberLynk Network, Inc.
5801 Washington Ave
Racine, WI 53406
(414) 884-1088 Fax (414) 884-1053
http://www.cyberlynk.net