Post reply

Configuration in the case of SAN replication

  • March 19, 2009 at 10:33 am

    #207611

    my databases are replicated on other servers. One server, we use it for OLTP and another for OLAP...

    Major differences of Configuration on Servers are :

    Fill Factor on Primary: 90

    Fill Factor on secondary: 0

    DOP on Primary: 1 (It has got 16 physical servers)

    DOP on secondary: 0 (4 Physical servers)

    Maximum Memory on Primary: 53000 MB

    Max memory on secondary: 25000 MB..

    we recently moved reporting to secondary, now performance is little slow. Can you let me know what changes i need to make in this case. Please let me know if you need more info..

  • March 19, 2009 at 10:48 am

    #962900

    More info on Disk fragmentation -

    There are 4 drives

    C: 40% fragmented

    F: 49% fragmented

    S: 45% fragmented

    T: 39% fragmented..

  • March 20, 2009 at 10:33 am

    #963666

    Check for index fragmentation and also don't forget to leave enough memory for OS.

    MJ

Viewing 3 posts - 1 through 2 (of 2 total)

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