Skip to content

Benchmark / Slow Output #6

@ghost

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

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