Re: Performance goes down

From: James Goodman (james_at_norton-associates.REMOVE.co.uk)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 13:08:19 +0000 (UTC)

Could it be the SQL Server is hogging all the resources when you submit
these queries & subsequently putting users on hold?

Have you run perfmon to checkout what is happening when you execute these
queries, & in particular the difference in utilisation between this & the
normal baseline utilisation? 

-- 
James Goodman
MCSE MCDBA
http://www.angelfire.com/sports/f1pictures/
"Mansoor Azam" <mansoorb@shoa.net> wrote in message
news:c39apn$2370k1$1@ID-31123.news.uni-berlin.de...
> 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

  • Re: Is it possible to link via ADODB from an Access 2K .mdb file?
    ... endless job with the amount of code and queries I have. ... This is a much better way of migration into SQL ... DAO to execute pass-through queries, ... programmatically to a SQL Server database. ...
    (microsoft.public.sqlserver.clients)
  • Re: Datenbankstruktur visualisieren
    ... All das wird der TA ebenfalls nicht können und eine Umsetzung nach SQL ... Server von Queries wird der FMS-TA ebenfalls nicht schaffen. ... das, was er macht, er ist ein Analyzer, nicht ein Designer. ... Leg' nur die Abfragen auf den SQL Server als Views, ...
    (microsoft.public.de.access)
  • Re: SSMA - Query Conversion to Stored Procedures.
    ... I'm wondering if you're running into the same bug that hits the older SQL ... As for the parameterized queries, ... You want to use SSMA to migrate your Access database to SQL Server 2005 ... But when I load those conversions to database, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Performance goes down
    ... Could it be the SQL Server is hogging all the resources when you submit ... queries, & in particular the difference in utilisation between this & the ... 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 ...
    (microsoft.public.sqlserver.programming)
  • Re: Access 2003 and SQL 2005 Mary Chipman?
    ... dynamically re-link on app startup and delete links on app exit. ... I've been doing a lot of research on the best way to integrate SQL Server ... Use pass through queries for reports. ...
    (microsoft.public.sqlserver.odbc)