Forum for MS SQL Server

[mLipok]

Where do you think is the best forum for MS SQL Server ?

I need to ask some 'PRO' questions.

 

[JLogan3o13]

I usually use: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

I have perused: https://www.sqlservercentral.com/Forums/ before but have never asked any questions there.

[mLipok]

Thanks

Will check it in monday.

I'm little busy - Today is my son 8 birth day.

[mLipok]

Finally I ask here:

https://stackoverflow.com/questions/50882824/sql-server-why-is-the-backup-speed-so-slow

And found answer by my self (together with my co worker @dPilar).

[Andreik]

So what cause your backup to be slow?

[mLipok]

MS SQL instance installed a bit differently.

Interestingly, one of my employees installed two servers (of the same type) week by week for different clients, theoretically in the same way.
But as it turned out, they had different settings, because it worked differently for one client than for another - as evidenced by the speed of data backup.

 

I still don't know where the configuration files or the relevant settings were causing these problems.

Fortunately, setting the appropriate parameters in the SQL script for the data backup solved the problems.

 

[Andreik]

Beyond the simple procedure of backup there are many settings in SQL Server regarding backup . A decent amount of DBAs use Ola Hallengren scripts for database backups and indexes maintenance because these scripts are handy but it's fairly simple to set the appropriate parameters for specific backup scenarios. From my experience, if there are not disk related issues or any kind of weird bottlenecks, even with default SQL Server configuration you can obtain great backup optimizations just by tweaking BUFFERCOUNT and MAXTRANSFERSIZE. In the company I used to work the backup process for some large database usually took about 2-3 hours but with small tweaks in these parameters I managed to improve the backup process to 20 minutes. Anyway, if your scenario is more complex and you use compression then you can test your backup performance with trace flag 3042 (preferably not on production server) to see if there is any improvement,