Forum Discussion

Almassud_221797's avatar
Almassud_221797
Icon for Cirrus rankCirrus
Aug 06, 2017

SSRS 2012 Load Balance and Monitor

Hello all,

 

I am 100% sure that this question been asked before many times, and I have seen lots of it with lots of answerers, but thus far I have not seen an answer that covers it all, so I would really appreciated all the assistance I can get so that I can get this done right and according to experts recommendations.

 

So I have 2 SSRS servers with scale out deployment, and I need to load balance them on our F5 and I need a monitor that can actually detect application level failure to mark a node as down and not for ping gateway only.

 

I have not been able to find a step-by-step guide that I could use, which is why I had to post to dev central to get some help with this.

 

Any & All Help is much appreciated.

 

application delivery
BIG-IP
LTM
  • jaikumar_f5's avatar
    jaikumar_f5
    Icon for Noctilucent rankNoctilucent
    Aug 07, 2017

    let me share my inputs as I dont know what SSRS servers really do.

     

    QQ's,

     

    Do you want the node to be monitored ? Since you specified it... The default monitor of a node is ICMP. Yea you can change it. But is there a need ?

     

    Your traffic will be load balanced to the pool. You can work on the pool monitor instead of the node monitor unless there's a specific reason.

     

    BIGIP has EAV monitors as you should know. Did you refer this article. If you're still facing some issue, let us know where your facing trouble. Even if in setting this up :)

     

  • Almassud_221797's avatar
    Almassud_221797
    Icon for Cirrus rankCirrus
    Aug 21, 2017

    sorry guys I don't think I did this intentionally, but I am still looking for an answer to my original question.

     

    so i am basically looking for a health monitor that can detect the health of the SSRS service.

     

    Thanks MJ

     

  • RossVermette's avatar
    RossVermette
    Icon for Nimbostratus rankNimbostratus
    Aug 21, 2017

    Here is what I've seen done.

     

    A SSRS Report was created to return a simple static message on the screen. On F5 an "HTTP/or/HTTPS Monitor" was created to request to run that specific report:

     

    Code GET /Reports/Pages/Report.aspx?ItemPath=%2NameofReport HTTP/1.1\r\nHost: friendlyname.fqdn.com\r\n

    The receive string in the monitor looked for the "Title of the Page"

     

    Code "NameofReport - Report Manager"

    With both the HTTP/HTTPS monitor you can pass username/password for credentials.