• Brandie Tarvin (1/26/2015)


    SQLRNNR (1/26/2015)


    K, change the Packet size in SQL Server. But that won't help any with the fact that a file copy also fails.

    Change it to the same size as the MTU?

    Disable TCP chimney offload.

    Is this a VM or physical?

    VM

    Can you copy a file that is about 1/2 the size of the backup you are trying to copy?

    Haven't tried exactly half, but I know I can copy smaller files. I will see if I have a half sized file to copy.

    You may benefit from bumping up the swap file size (and make sure it is contiguous).

    I would also disable tcpv6. I have run into problems with v6 causing odd behaviors. I'd have to find some other resources supporting that (they are out there just don't remember them off the top of my head).

    If you find those resources, would you let me know? We don't have control over the servers and network, just over SQL Server. And if I want to change something from a corporate standard, I have to have documentation proving why something needs to be shut off.

    And how do I verify the swap file is contiguous? Is there something on Disk Manager that shows the swap file?

    Yes same size as MTU.

    Contiguous - check a disk defragging utility to see how many chunks that swap file is in.

    IPv6

    Don't disable unless you have a good reason...

    http://sqlha.com/2010/01/12/ipv6-windows-server-2008-rtm-and-r2-and-failover-clustering/

    SQL Browser Service issues when IPv6 enabled...

    https://support.microsoft.com/kb/2526552/en-us

    Google-fu is failing me for solid stuff but still looking.

    If nothing else, start with disabling the chimney offload.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events