Reporting Server

  • Admingod

    SSCertifiable

    Points: 5611

    I have reporting server which gets replicated from other OLTP server.However, the reporting server has low PLE and hig disk queue which make sense having low PLE could lead to high disk queue length and this trigger alerts. However, adding more memory on reporting server would help but it's reporting server so it would take more memory any way. But setting the alerts to different threshold is good option or try adding more memory? Only ETL process runs against this reporting server other then data is populated through replication. Not many direct reports runs against. Please advise?

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715845

    What are your target server memory and current memory settings?

  • Admingod

    SSCertifiable

    Points: 5611

    16 is the total memory and 12 is assigned to sql.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715845

    The performance counter. Not total memory, the target memory the reporting instance is wanting

  • Admingod

    SSCertifiable

    Points: 5611

    Sorry i didn't get you.

  • Sue_H

    SSC Guru

    Points: 90260

    Do a search on this: target server memory total server memory sql server

    Then you'll know what it means and understand why Steve asked that. Also you can query the performance counters using a DMV in SQL Server. And hopefully no one posts all of that for you - you'll remember it better when you go find it out yourself. 🙂

    Sue

  • Admingod

    SSCertifiable

    Points: 5611

    Thank you

  • Jeff Moden

    SSC Guru

    Points: 994667

    Admingod wrote:

    16 is the total memory and 12 is assigned to sql.

    How big is your largest clustered index?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

Viewing 8 posts - 1 through 8 (of 8 total)

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