Welcome to Sign in | Help
in Search

Neverending queries

Last post 06-02-2009, 11:24 PM by rremus. 2 replies.
Sort Posts: Previous Next
  •  06-02-2009, 1:29 PM 7246

    Neverending queries

    De azi dimineata se intampla ceva foarte ciudat.
    Toate query-urile dureaza la infinit (ne se mai termina).
    Daca dau restart la serviciul SQLServer totul revine la normal dar dureaza doar 10 min.
    Ceva idei ce pot sa verific ?

    Sorin Sandu
  •  06-02-2009, 2:18 PM 7247 in reply to 7246

    Re: Neverending queries

    Dupa un backup totul a revenit la normal

    Sorin Sandu
  •  06-02-2009, 11:24 PM 7248 in reply to 7246

    Re: Neverending queries

    OK ca idee generala cind tu sau altcineva da peste o astfel de problema: primul lucru, masori. In SQL 2000 exista sysprocesses, in 2K5 exista sys.dm_exec_requests . Te uiti si vezi de ce sint blocate query-urile. Te uiti in blocking_session_id, in wait_type si last_wait_type si la wait_resource. In 99% din cazuri te prinzi imediat care-i problema. In celelate 1% din cazuri te putem ajuta, dar trebuie sa ne spui ce anume blocheaza.

    http://rusanu.com
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems