none
Publisher which is sql server failover cluster, ran slowly

    Question

  • I have a sql server failover cluster with 2 nodes (named DBS). The database runs normally. The OS is Windows Server 2012 Standard Edition. The version of DBS is sql server 2012 enterprise.

    And I have 4 stand-alone databases (DB1, DB2, DB3, Dist). The Dist is set up to a distribution database. DBS is a publisher. DB1, DB2, DB3 are subscribers.

    But the DBS ran very slowly. Actually, it very hard to use Management Studio. I usually have got error message: Time out.

    Therefore, I have to install another stand-alone database, and make it to a publisher. And the replication is fine.

    So what 's happened with my sql cluster ???

    I can not find any errors or warnings in Event viewer and Sql server logs. Anybody has the same problem ?

    Saturday, September 21, 2013 2:32 PM

All replies