Post reply

HP StorageWorks DButil as part of a strategy of replicating SQL databases

  • November 11, 2009 at 9:48 am

    #213779

    We have recently started evaluating the HP StorageWorks DButil utility as part of a strategy of replicating our production databases to a reporting environment, so our users can issue ad-hoc queries in that environment instead of production.

    The tool works to take a snapshot of the source database before replicating the database files across to the target LUN. This process takes from a few seconds to a few minutes, depending on database size. During that interval, write operations are suspended and are resumed when the snapshot is completed.

    Has anyone had experience with this tool?

    Any issues with it that I should be aware of?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • November 29, 2009 at 12:49 pm

    #1085154

    Hi we did a test using HP StorageWorks DButil and EMC technology as well, they works fine in small database with low transaction processing, but when the databases were big and important transaction running the servers had a delay and in sometime timeout were raised.

    You should evaluate your environment about the size and the transaction rate.

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

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

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