Re: SQLServer stops responding w/SQLServer Agent

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 05/05/04 

Date: Wed, 5 May 2004 18:16:21 +0200

Perhaps Agent started a job which blocks some query that your web app is running? 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Travis Crook" <travis@visionsbeyond.com> wrote in message news:ujFSCirMEHA.3556@TK2MSFTNGP09.phx.gbl...
> Hi all,
>      I am running SQL Server 2000 (sp3) on Windows 2000 Server (sp4) on an HP Netserver e800 dual processor
box (2048 RAM, plenty of hard drive space).  I am running about 50 databases on the box.  I have one database
that gets far more traffic than the others.
>      What happens every-once-in-awhile is that SQL Server will stop responding.  I start to get database
timeout requests, etc. and the Web sites connected to the databases no longer function.  It seems to only
happen when I have SQL Server agent running in the background (which is a problem because I would really like
the agent to be running).  I have tried to find errors in the log files but see nothing unusual or that would
seem to be the cause of the problem.  SQL Server still indicates that it is running fine (in the Task
Manager), query analyzer will return results, etc. but no Web traffic goes through.  Rebooting only seems to
work if I can stop the SQL Server Agent before I start to get any Web traffic coming across.
>      Any ideas?  I've looked on Google, other forums, etc. and can't find any relevant information.
>
> Thanks!
>
> Travis Crook
> Visions Beyond
>
> **********************************************************************
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Relevant Pages

  • Re: Network traffic with transactional replication with immediate updates (SQL 2005)
    ... publisher/distributor running on the main office and a subscriber at the ... This is a new SQL Server 2005 behaviour, ... the agent should execute them (maybe the agent just ... I cannot find a way to explain why Distributor Agents are to ...
    (microsoft.public.sqlserver.replication)
  • Re: Network traffic with transactional replication with immediate updates (SQL 2005)
    ... publisher/distributor running on the main office and a subscriber at the ... the agent should execute them (maybe the agent just launches ... Looking for a SQL Server replication book? ... I cannot find a way to explain why Distributor Agents are to ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Server 2005 replication monitor questions
    ... >> To get to the agents expand SQL Server Agent jobs, ... click on your publication in Enterprise ... >> bottom half you will see your snapshot and distribution agent. ... >> monitor it there (through replication monitor). ...
    (microsoft.public.sqlserver.replication)
  • Re: Server CE 2.0 Merge Replication
    ... This morning I am not able to access sscesa20.dll both from the emulator nor ... To change your connection settings, ... > your first goal should be to access the server agent from Pocket IE ... >> My SQL Server instance name be YYY ...
    (microsoft.public.sqlserver.ce)
  • Re: sp_replcmds
    ... It is possible that there is an open transaction ... Looking for a book on SQL Server replication? ... >> Stop SQL Server agent, restart it and see if this clears the error. ... Use Replication Monitor to view the details of> this ...
    (microsoft.public.sqlserver.replication)