RE: Strange behaviour of MS SQL 2000

From: JimRuddy (jruddyse_at_hotmail.com)
Date: 11/25/03

  • Next message: ed.devlin_at_detica.com: "how do I force secure ASP.NET session cookies?" 
    To: "'Gianni Arru'" <arru@comi.it>, <focus-ms@securityfocus.com>
Date: Mon, 24 Nov 2003 22:21:17 -0500

    You should be able to narrow this down by executing the following query in
    query analyzer...

    select * from sysprocesses where spid > 50 and blocked > 0

    I would run this every few seconds over a minute period or when the server
    appears hung. If you get anything returned chances are this is an
    application issue. If so I would recommend the Microsoft Newsgroups they are
    pretty good at providing the information you will need further to track down
    the issue.

    JimR

    -----Original Message-----
    From: Gianni Arru [mailto:arru@comi.it]
    Sent: Friday, November 21, 2003 05:47
    To: focus-ms@securityfocus.com
    Subject: Strange behaviour of MS SQL 2000

    At the moment I have no idea if this problem is caused by a DOS to our
    win2000 box or
    is only a bug triggered by some client application that connects to the sql
    server.

    However this is what it happens:
    - client applications connected to the sql server stop working giving a
    timeout runtime
    error or freeze if CommandTimeout property is set to 0 in the
    ADODB.Connection object
    of the client apps.
    - no other clients can connect to the sql server.

    It is possible to login from remote to the server via terminal service and
    all seems to be
    normal, sql server working, there is no strange disk activity, memory usage
    or other
    resource leaks.

    The only way to solve this block is to log in and log off on physical
    console! I'm getting
    crazy! How can be possible that services that run in background are
    influenced from an
    interactive login on console?

    I've made several analyses using a packet sniffer on the lan and doing sql
    traces
    running sql profiler and it seems to be all ok but never happend this
    problem during
    these analyses!

    Thank you in advance for any help. 

    -- 
Gianni Arru
gianni@comi.it
---------------------------------------------------------------------------
---------------------------------------------------------------------------
---------------------------------------------------------------------------
---------------------------------------------------------------------------
  • Next message: ed.devlin_at_detica.com: "how do I force secure ASP.NET session cookies?"

    Relevant Pages

    • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
      ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
      (microsoft.public.sqlserver.connect)
    • Composite index and data distribution
      ... SQL> create table foobar ... COMPOSITE INDEX (BEST I CAN THINK OF FOR THE QUERY TO BE EXECUTED): ... Execution Plan ... 395 bytes received via SQL*Net from client ...
      (comp.databases.oracle.server)
    • Re: connect to named instance w/ non-default port
      ... SQL Native Client Configuration. ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ...
      (microsoft.public.sqlserver.connect)
    • Re: Query to Count Duplicate Values in a Given Date Range
      ... Show" to note whether the client showed up at the pantry. ... Now, if I try to run the query with that field, it returns no results. ... Here's my final SQL code if you see anything else that may need adjusting. ... use a WHERE clause rather than HAVING for the dates, ...
      (microsoft.public.access.queries)
    • Re: Is there ever a reason to have a transaction around a select..
      ... cache-size rows are found during the SELECT operation, the client ... on the rowset state as the SELECT query walks the query plan fetch rowset. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
      (microsoft.public.dotnet.framework.adonet)