Processes blocked due to PAGELATCH_UP

• Preethi S Raj

  SSCommitted

  Points: 1523

  More actions

  February 2, 2009 at 8:59 am

  #97100

  Hello,

  Our production servers are using SQL server 2000. We are facing a n issue due to the latches.

  The blocking process is

  lastwaittype - PAGELATCH_UP

  waitresource - 2:6:13

  spid - 245

  waittype - 0x0000

  waittime - 0

  A series of processes are blocked .

  waitresource - 2:6:13 - 2 indicates tempdb

  I tried to google and the info i found was to increase the no of files in the tempdb. But there are already 8 files associated with the tempdb.

  Any inputs or feedback would be of great help.

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  February 2, 2009 at 12:10 pm

  #936639

  The # of tempdb files you should use is dependent on the number of CPU's in the system, and it won't necessarily protect against issues.

  The first point of attack should be to look at the queries that are causing the blocking and find out why the writes to tempdb are happening.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net