Automatically Failover after the OLAP cycle RRS feed

  • Question

  • Hello All,

    have 3 node cluster using Sql server 2008. i have both OLAP and OLTP databases configured in my cluster
    once OLAP getting high usage that will automatically failover my other database to another node and we are facing so many performance bottlenecks after that.
    i have used “Possible Owners”  to overcome this issue, but still i can't control my cluster.

    can you kindly propose workaround to overcome this issue.

    Thanks in Advance,

    Monday, March 18, 2013 2:10 AM

All replies