Startseite
Willkommen, Gast. Einloggen.

SQL Server

VMware vCenter Server - database maintenance shall be a weekly task

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.
    • Weiterlesen »

    vCenter Configuration Manager - can't create new schedule jobs after SQL Update

    If you update the SQL Server on your VCM install after the original installation you might run into the issue that you can't schedule any jobs anymore.

    A quick fix can be achieved by the following SQL statement:


    USE msdb
    GRANT EXECUTE ON OBJECT::dbo.sp_add_category TO public
    GRANT EXECUTE ON OBJECT::dbo.sp_add_job TO public
    GRANT EXECUTE ON OBJECT::dbo.sp_add_jobschedule TO public
    GRANT EXECUTE ON OBJECT::dbo.sp_add_jobserver TO public
    GRANT EXECUTE ON OBJECT::dbo.sp_add_jobstep TO public
    GRANT EXECUTE ON OBJECT::dbo.sp_add_schedule TO public     Weiterlesen »

    Syndicate content