Seeking Cluster performance

• fkk2001

  SSC Enthusiast

  Points: 102

  More actions

  November 10, 2005 at 1:53 am

  #115492

  Hello,

  I have a performance problem with clustered sql server 2000 quite a while now.

  I'm looking for some tips where to search for the bottleneck next.

  My profile shows, that simple selects and updates takes about 9 and 40 seconds:

  StatementCPUReadsWritesDurationCPIDSPID

  UPDATE Userdata SET lastlogin = CURRENT_TIMESTAMP WHERE id = 2159080405131800155

  SELECT * FROM ErmUserdata WHERE userref = 139023097334452392

  The CPU and Disk load shows nothing spechial.

  Is there any way to query sql server why this takes so long?

  Thanky in advance for any hint!

  Frank

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  November 10, 2005 at 3:08 am

  #603182

  tricky - out of date stats, no indexes, auto close set on database.

  I usually check out the est query plan as first step with any query, then maybe test on another system and link to profiler for full details.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/