Welcome to Sign in | Help

Re: Neverending queries

  •  06-02-2009, 11:24 PM

    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 Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems