Monday, March 12, 2012

Excessive Latch Wait

Good evening,
Does anyone have advice on how to trim down excessive latch wait time?
One particular query (stored procedure) is to blame for almost all of it.
This query is joining 7 tables... 1 of which is joined twice... another of
which has several million rows in it.
The query has nolocks throughout...
Thanks in advance.
~lbIt's possible that parallelism is the problem here. Try adding OPTION
(MAXDOP 1) as the very last line in your SELECT.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Lonnye Blake Bower" <lbower@.excellerx.com> wrote in message
news:eq4zxN0KFHA.732@.TK2MSFTNGP12.phx.gbl...
Good evening,
Does anyone have advice on how to trim down excessive latch wait time?
One particular query (stored procedure) is to blame for almost all of it.
This query is joining 7 tables... 1 of which is joined twice... another of
which has several million rows in it.
The query has nolocks throughout...
Thanks in advance.
~lb

No comments:

Post a Comment