The Quick Scan report in Database Health Monitor detects when you are performing SQL Server backups without compression, when the compression option is available. This applies to Full backups, Transaction log backups and Differential backups. Not using compressed backups? Why not? Benefits of compressed backups Faster backup time Faster restore time Less I/O at backup and restore time Since you are …
Max Server Memory Setting Explained If you have more memory than your database and applications on the SQL Server will ever use than this is not a problem, but when you run into memory constraints this setting is much more important. SQL Server attempts to use as much memory as possible, and when there is no more memory available, SQL …
SQL Server Performance Tuning Tips – Wait Statistics Wait statistics are commonly overlooked ways to quickly find out what is causing your SQL Server to be slow. One of the reasons is it’s difficult to see how they are trending over time. >>> It is not difficult with a monitoring tool. <<< When someone reports a slow database yesterday at …