August 18, 2011 at 2:04 pm
Alex Webber (8/18/2011)
How could user permissions have anything to do with it? Surely you either have the right permissions or you don't?
Agreed. I don't see how permissions could play into the issue.
And as for Instant File Initialisation, that's only for creating new data files (skipping the zero'ing phrase) so how does that come in to play?
That setting doesn't affect backup files, only data files.
The facts don't compute Alex, which probably why you posted. I'll step aside now 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
August 19, 2011 at 1:52 am
Yeah, it's painful! Another point of note, the old server (1hr backup) was a Dell 515r and the new server (15hr backup) is a HP DL380 G7.
So yeah I guess if anyone has had any pain from switching to Dell to HP then that might give me some pointers?
August 19, 2011 at 2:04 am
Also just to add for even more info, the major differences between the two are
Dell
Raid Controller: Perc(megaraid)
NOC chipset: Broadcom
CPU: AMD
HP
Raid Controller: LSI (variant)
NOC chipset: Intel
CPU: Intel
August 19, 2011 at 9:52 am
I'd expect the Dell raid controller to be better but the HP chipset and processor to be better or at least as good.
I am scratching my head on this one.
You said firewall was configured the same - does that include windows firewall on destination server?
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
August 22, 2011 at 9:37 am
Yup. tried with all firewalls disabled.
August 23, 2011 at 7:37 am
Another "out there" thought... Have you made sure that nothing else IO intensive is happening on the destination server when the UNC backup is run? Tried scheduling for a different time? I say this because I encountered a mysterious slowdown once that turned out to be Windows Shadow Copy consuming IO and diskspace in the background.
August 23, 2011 at 7:41 am
You said that you have HP server now. How many NICS does it have? How is it configured? Teaming or do you have a dedicated NIC for just File copy and one Public for SQL Server?
-Roy
August 23, 2011 at 1:10 pm
I hate to admit this, but if we need a bunch of scratch space on a disk and we can't do anything else, we just go buy a 500 gb portable USB drive, and attach to the server. This is pretty slow (compared to SaS), but it sure beats 15 hrs. We can usually do about a gb a minute. USB 3.0 is even faster, if the server can do it.
August 23, 2011 at 3:18 pm
Had a similar issue at a previous employer, turned out the port on one of the switches was set to half-duplex. Just an idea.
August 24, 2011 at 1:37 am
you can configure through LiteSpeed.Lite Speed Provide
Compresses backups up to 85% more than competing full backup solutions
Analyzes for the best compression options for databases
Provides automatic recovery from I/O issues
Performs object-level recovery from
backup files to prevent having to restore
August 24, 2011 at 2:17 am
Lynn Pettis (8/23/2011)
Had a similar issue at a previous employer, turned out the port on one of the switches was set to half-duplex. Just an idea.
That was where my thoughts were turning too. I would check that the NICs are actually set to the same values and not relying on autoconfigure - especially after a change in hardware.
But I agree that the practical solution is to provide some sort of local storage to hold a backup until you copy it to a network drive, for security or further backup to other medium.
August 24, 2011 at 3:36 am
Cheers for those responses guys. Our sys guys are currently looking at that so I'll feedback should they find anything!
February 16, 2012 at 8:49 am
Hi
I know this is quite an old thread but may still be interesting.
Have been struggling with net backups as well. Noticed CPU priv time% gradually going up while backup throughput doing down when backing up large database (300Gb). This only occurs on Win2003SP2/SQL 2005.
After 2 days of investigating (robocopy, teracopy, unbuffered I/O stuff, SystemCacheDirtyPageThreshold registry setting...) I finally found this...
We're on SQL 2008R2 now and we don't have any problems. No idea what SP or hotfix the patch is included in though.
Regards
Thierry
Viewing 13 posts - 16 through 27 (of 27 total)
You must be logged in to reply to this topic. Login to reply