So be aware of that if databases on your server require different maintenance scenarios. The jobs created by the Maintenance Solution automatically process all user databases on the server. But it can also be used successfully with the default settings on simpler servers and databases. As it takes many parameters into account, it can be configured to fit most demanding environments. Ola Hallengren’s maintenance solution could be considered a hybrid of these two solutions, as it takes the best perks from both options: it is simple, highly customizable, and it’s free. The drawback to this solution is certainly its price. These applications usually come with the nicely-packed interfaces and do not require much of the experience from their users. The companies that design these applications invest a great amount of effort to make their apps simple to use and feature-rich at the same time. On the other hand, some administrators like the simplicity offered by the 3 rd party applications. Designing these solutions usually take time, and require an experienced DBA skilled in T-SQL or PowerShell scripting. Such solution is usually optimal for some demanding environments like high traffic servers or databases that are still in development. After the scripts are thoroughly tested, they often get included in a maintenance plan, or SQL Server agent job to automate their execution.
The scripts are usually designed to fit the requirements imposed by the specific environment.
Some more experienced administrators prefer to design and use their own scripts for these tasks. Database administrators tend to use various scripts or applications, to make the daily SQL Server database maintenance task easier.
0 kommentar(er)
