Post reply

Process

  • April 16, 2010 at 4:25 am

    #220497

    friends one of my production server one database process is in suspend mode.could u plz let me know how can i solve this issue

  • April 16, 2010 at 4:35 am

    #1152676

    Just find out what query is running and what resource it is waiting for. Its OK for a process to go suspended unless it does not wait for too long

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • April 16, 2010 at 4:53 am

    #1152687

    suspend or suspect?

  • April 16, 2010 at 4:58 am

    #1152690

    A database can become suspect for several reasons. Possible causes include denial of access to a database resource by the operating system, and the unavailability or corruption of one or more database files.

    set ur database to emergency .will only be available to members of SYSADMIN role

    then make it into single user

    run dbcc checkdb repair (check dbcc checkdb command)

    http://msdn.microsoft.com/en-us/library/aa258278(SQL.80).aspx

  • April 16, 2010 at 5:05 am

    #1152694

    hi roshan,

    thanks for response

    DECLARE @OlapEvent BIGINT;SELECT @OlapEvent = ObjIdUpdate(3);

    SELECT (@OlapEvent & convert(bigint, 0xffff000000000000)) / 0x0001000000000000

    AS Status, (@OlapEvent & convert(bigint, 0x0000ffff00000000)) / 0x0000000100000000

    AS DbId, @OlapEvent & convert(bigint, 0xffffffff) AS ObjId;

    this is query wait time is 1546

    plz tell me the solution what can i do thanks in advance

  • April 16, 2010 at 5:11 am

    #1152700

    what is the lastwaitype in sysprocesses also take a not of hostname and program which is executing this query.

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • April 16, 2010 at 5:16 am

    #1152704

    wAITTYPE IS TRACE

  • April 16, 2010 at 5:36 am

    #1152719

    R u running trace? .

    Then stop it

    Select * from fn_trace_getinfo(null)

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • April 16, 2010 at 5:51 am

    #1152735

    Roshan trace files have been already stopped.can i kill processid.please

    tell me.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply