March 19, 2009 at 10:33 am
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
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
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