November 5, 2010 at 1:58 am
Dear All,
I have a problem , number of latches increasing day by day. generaly it is due i/o issue. i have done indexing and restarted the server but still the problem is same. output of the following query is below 'select * from sys.dm_os_wait_stats'.
Note:- My tempdb and datafile are on same disk can that be a problem?? but the size of the tempdb is not more than 1 gb.
LATCH_SH7421921101578
LATCH_UP0000
LATCH_EX628403765384870396717176156
Thanks in Advance.
November 5, 2010 at 2:23 am
None of those waits are IO related.
The IO related waits are PAGEIOLatch_XX. Those latches are all memory-related latches. Without knowing more of your setup and what queries you're running and how they are impacted it's hard to say more.
btw, the wait stats DMV is cumulative. You would completely expect it to increase day by day because it's tracking total number and total wait time since the SQL instance last started. From the numbers it looks like you have lots of very short-lived latch waits. Are they causing a problem?
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply