This post is more than 5 years old
90 Posts
0
24156
September 23rd, 2013 05:00
Dell EQL PS4100xv problem with MS SQL replication
Hi,
I got a Dell PowerEdge server R420 connected to an EQL. Installed is ESXi 5.1 U1 (free version). There is only one data store.
VM runs Windows 2008 R2 STD with MS SQL 2008 R2 STD. The change in database size per day is around 2 to 3 MB base on my daily full backups via MS SQL backup.
However, when I initiate a replication session between my PROD EQL and DR EQL that delta size is ranging from 1 GB to 50 GB each time I executed a replication ? Interval is around 5 to 10 minutes. I tried 20 mins also the size to be replicated is erratic.
Why is the replica so huge its more than 1000 MB per replication.
Hope someone can help me on this.
Thanks,
Paul
No Events found!
ZianPaul
90 Posts
0
September 23rd, 2013 07:00
Hi,
Will try out storage direct as soon as possible and install HIT/ME. Will this greatly reduce the replica volumes?
However, Im using the free version of VMware without VCenter...
Will I be still able to use VSM ?
Thanks,
Paul
ZianPaul
90 Posts
0
September 23rd, 2013 16:00
Hi,
How about for MS SQL, is there any guide to optimize that, so I won't be replicating none important bits ?
As I understand when I use storage direct and present a EQL volume directly to my new VM, when a snapshot or replica is created
shouldn't that exclude unnecessary VMware files located on its data store ? Since, the SQL database is now located on a different volumes?
How can we optimize MS SQL so that it wont update the bits if a read operation is executed ? My database is read extensive.... So most of the bit are always being read and updated....
Thanks,
Paul
ZianPaul
90 Posts
0
September 23rd, 2013 22:00
Hi,
Last Question, can VSM be used with the free version of ESXi 5.1 ?
Someone advice me to use RDM from VMware to mount a LUN....
Can I get your comment on this. I would really appreciate any inputs..
Thanks,
Paul
ZianPaul
90 Posts
0
September 25th, 2013 00:00
Hi,
I just tested the RDM, I still get large replication data.. I transferred the temp db, transaction logs and other to a different volume but still the data being replicated is huge...
I also set NtfsDisableLastAccessUpdate = 1....
the RDM volumes just contain the database file.
Can the Microsoft Auto Snapshot manager detect only changes in files and not the blocks... Per review the change in database size per day is only around 10 mb... but my replication per 3 hours reaches 2 GB...
Thanks,
Paul