Performance goes down

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mansoor Azam (mansoorb_at_shoa.net)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 15:49:22 +0500

We're an ISP using SQL 6.5. When the user connects to us, the RADIUS server
queries the database to authenticate the user. This is happening all the
time. However when I run a query against the database that effects a large
no. of rows and runs for a minute or two, often the authentication process
stops and
we start getting calls from our customers complaining they cant connect. We
then have to start and stop the RADIUS service and SQL to enable the process
again.

Any ideas to get around this problem are appreciated.

thx

Relevant Pages

  • Performance goes down
    ... We're an ISP using SQL 6.5. ... When the user connects to us, the RADIUS server ... queries the database to authenticate the user. ... However when I run a query against the database that effects a large ...
    (microsoft.public.sqlserver.server)
  • Re: Performance goes down
    ... > We're an ISP using SQL 6.5. ... When the user connects to us, the RADIUS server ... > queries the database to authenticate the user. ... However when I run a query against the database that effects a large ...
    (microsoft.public.sqlserver.programming)
  • Re: Performance goes down
    ... > We're an ISP using SQL 6.5. ... When the user connects to us, the RADIUS server ... > queries the database to authenticate the user. ... However when I run a query against the database that effects a large ...
    (microsoft.public.sqlserver.server)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)