Post reply

high internal Catch Latch

  • November 15, 2012 at 6:22 am

    #266967

    hi all,

    I have a situation here where i am getting high internal catch latch.

    we are using sql 2005 sp2 and we have installed Foglight PA for to analysis and it start appearing high internal Catch Latch since last 2 weeks.

    Any idea how it appears all of sudden , as it give me little bit poor performance and having high cpu usage.

    Thanks In Advance for all your help

  • November 15, 2012 at 7:08 am

    #1559345

    'Catch Latch'? That's not a SQL wait type or latch type. Can you be more specific please?

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 15, 2012 at 12:22 pm

    #1559480

    it cache latch. not catch its typo.

  • November 15, 2012 at 12:31 pm

    #1559489

    Still not a SQL wait type or latch. There are 13 latches that have the word Cache in their name, 24 wait types that have the word 'latch' in their name.

    Going to need a lot more info.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 16, 2012 at 6:14 am

    #1559764

    I See PAGEIOLATCH_SH ,writelog wait type are common here in my environment now a days.

  • November 16, 2012 at 1:48 pm

    #1559940

    Those are IO-related waits. You might want to take a look at your IO subsystem, make sure you're not putting more demand than it can handle.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply