Especially in a growing environment you will identify a performance degrade on the MS SQL Server after some time.
There is an easy way to setup the most common jobs in a simple weekly maintenance plan.
Please login to the MS SQL Server serving your vCenter Server, or directly onto the vCenter Server if you use an internal database server.
Start the Microsoft SQL Server Management Studio and login with an administrative user, this is in many cases the "sa" user or an Administrator of the system.