Skip to content

Benchmark / Slow Output #6

Description

Hello,
first off all thanks for this great tool. I use it to encrypt SQL Backup on the fly.
Now I do some benchmark / debug to find the bottleneck.

My System is a Win2008R2 64bit with dualcore and ssd, SQL Server 10.50.
When I do a backup with SSMS the speed is round about 86 MB/s.
With sqlpipe I get 10-33 MB/s. sqlpipe is only 32bit but I do not think that this is the problem.

To reproduce it:
sqlpipe backup myDB -q | pv -s 10G > NUL
pv (Pipe Viewer) is part of cygwin.

Have you any ideas why it is so slow?

p.s. on Win2019with dualcore and ssd, SQL Server 14.0 I get 50-200 MB/s with sqlpipe

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions