hopefully this can be a straight forward question, but at the same time, looking to get some advice and if possible experience from someone that tried this... but as the title says, My company has large databases, about 1.5 tb, and dont want to invest in software, but of course we do have good hardware, and trying to speed up the backup process.
so, someone from the group suggested to create a powershell script that utilizes runspace, which spins up multiple threads to do the process. I am testing that as we speak, but so far doesnt seem to increase the backup performance and speed of shrinking down backup time (usually takes 10-15 hours). is Powershell/runspace good or can it actually take backups faster?
Again, i am testing it now, and so far it seems to be stuck on 1 database at a time, though i do see multiple SPIDS on several databases, but, it seems using sp_whoisactive, i only see 1 database with percent_complete going up, again only 1 database, others are null, and are in suspended... very slow.
I tried Ola hallengren, and that seems to increase speed, but i have to make multiple jobs and use Parallel=Y, new i guess feature from Ola Hallengren.
So, the last question I have is, On Performance Monitor, what metrics can i use to see or should I use to measure to give me a good reading on which process works best?
Also any other backup ideas anyone can throw out for me to try and increase backup times?
thanks in advance 🙂