Start a Conversation

ZianPaul

updated

13 years ago

Solved!

Go to Solution
Z

ZianPaul

90 Posts

0

24189

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 

  • Z

    ZianPaul

    90 Posts

    992

    0

    Posted 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

  • Z

    ZianPaul

    90 Posts

    992

    0

    Posted 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

  • Z

    ZianPaul

    90 Posts

    992

    0

    Posted 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

  • Z

    ZianPaul

    90 Posts

    992

    0

    Posted 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

     

Dell Support Resources

Latest Solutions

View More