Post reply

What is Deadlock

  • April 23, 2009 at 11:15 pm

    #384434

    hi Experts,

    What is deadlock , When it will occurred ? How can we prevent that? and What is timestamp datatype.. why we using? Any practically examples i need

    Please tell me Clearly....

  • April 24, 2009 at 1:09 am

    #983397

    Check this out...

    http://www.sqlservercentral.com/articles/Administration/exploringdeadlocks/616/">

    http://www.sqlservercentral.com/articles/Administration/exploringdeadlocks/616/

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

  • April 24, 2009 at 1:12 am

    #983398

    http://sqlinthewild.co.za/index.php/2008/07/08/what-is-a-deadlock/

    As for timestamp, have a look in Books Online. There's a lot of info on timestamp there.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 24, 2009 at 3:18 am

    #983426

    Hi,

    Deadlock : Deadlock occurs when two or more tasks permanently block each other by each task having a lock on a resource which the other tasks are trying to lock

    Both transactions in a deadlock will wait forever unless the deadlock is broken by an external process. The Microsoft SQL Server Database Engine deadlock monitor periodically checks for tasks that are in a deadlock. If the monitor detects a cyclic dependency, it chooses one of the tasks as a victim and terminates its transaction with an error. This allows the other task to complete its transaction. The application with the transaction that terminated with an error can retry the transaction, which usually completes after the other deadlocked transaction has finished.

    TimeStamp Data Type: Timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes.

    Check this link for more info

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

  • April 24, 2009 at 6:34 am

    #983490

    Very Very Thanks to all...

Viewing 5 posts - 1 through 4 (of 4 total)

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