{"id":180,"date":"2009-11-06T21:43:04","date_gmt":"2009-11-06T14:43:04","guid":{"rendered":"https:\/\/www.implementer.co.th\/wordpress\/?p=180"},"modified":"2020-05-10T00:27:06","modified_gmt":"2020-05-09T17:27:06","slug":"virtualcenter-2-5-performance-log-error","status":"publish","type":"post","link":"https:\/\/implementer.co.th\/wordpress\/knowledge\/problems\/virtualcenter-2-5-performance-log-error\/","title":{"rendered":"vCenter \u0e14\u0e39 Performance \u0e44\u0e21\u0e48\u0e44\u0e14\u0e49"},"content":{"rendered":"

\u0e1b\u0e31\u0e0d\u0e2b\u0e32\u0e19\u0e35\u0e49\u0e40\u0e01\u0e34\u0e14\u0e08\u0e32\u0e01\u0e01\u0e32\u0e23 Upgrade \u0e08\u0e32\u0e01 SQL 2005 Express \u0e44\u0e1b\u0e40\u0e1b\u0e47\u0e19\u0e40\u0e27\u0e2d\u0e23\u0e4c\u0e0a\u0e31\u0e48\u0e19\u0e2d\u0e37\u0e48\u0e19
\n\u0e40\u0e19\u0e37\u0e48\u0e2d\u0e07\u0e08\u0e32\u0e01\u0e43\u0e19 SQL 2005 Express \u0e44\u0e21\u0e48\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e43\u0e0a\u0e49\u0e07\u0e32\u0e19 SQL Server Agent \u0e44\u0e14\u0e49 \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e2a\u0e48\u0e27\u0e19\u0e19\u0e35\u0e49\u0e08\u0e36\u0e07\u0e42\u0e14\u0e19\u0e08\u0e31\u0e14\u0e01\u0e32\u0e23\u0e42\u0e14\u0e22 VirtualCenter Server service \u0e14\u0e31\u0e07\u0e19\u0e31\u0e49\u0e19\u0e40\u0e21\u0e37\u0e48\u0e2d\u0e44\u0e14\u0e49\u0e17\u0e33\u0e01\u0e32\u0e23 Upgrade SQL \u0e08\u0e36\u0e07\u0e15\u0e49\u0e2d\u0e07\u0e40\u0e1e\u0e34\u0e48\u0e21 Job \u0e43\u0e19 SQL Server Agent<\/p>\n

\u0e17\u0e35\u0e48\u0e21\u0e32 Vmware<\/a><\/p>\n

Adding the SQL Server Agent Jobs<\/h3>\n

This section describes how to install the SQL Server Agent jobs.\u00a0 \u00a0 To add a SQL Server Agent Job:<\/p>\n

    \n
  1. Open SQL Management Studio using the database login used by VirtualCenter to connect to the database (typically not SA or Administrator). See Administrative Credentials are required for Oracle and SQL Server databases when installing or upgrading Virtual Center (1003052)<\/a> to ensure you have the correct permissions.<\/li>\n
  2. Click File<\/strong> > Open<\/strong> > File<\/strong>.<\/li>\n
  3. Navigate to the location of the jobs:\n
      \n
    • For vCenter 2.5, go to C:Program FilesVMwareInfrastructureVirtualCenter ServerdbupgradeUpgrade-v3-to-v4PL-SQL<\/li>\n
    • For vCenter 4.0, go to C:Program FilesVMwareInfrastructureVirtualCenter Server<\/li>\n<\/ul>\n<\/li>\n
    • Open job_schedule1_mssql.sql.<\/li>\n
    • Ensure that the VirtualCenter Database<\/strong> is selected and that Master<\/strong> is not selected.<\/li>\n
    • Click Execute Query<\/strong>.<\/li>\n
    • Follow Steps 1 to 6 for job_schedule2_mssql.sql and job_schedule3_mssql.sql.<\/li>\n
    • After all three jobs are created, navigate to SQL Server Agent<\/strong> > Jobs in the Object Explorer<\/strong>.<\/li>\n
    • Right-click Past Day stats rollup<\/strong>, then click Properties<\/strong>. Ensure that the owner of the job is the same user as the owner of the database.<\/li>\n
    • Right-click Past Month stats rollup<\/strong>, then click Properties<\/strong>. Ensure that the owner of the job is the same user as the owner of the database.<\/li>\n
    • Right-click Past Week stats rollup<\/strong>, then click Properties<\/strong>. Ensure that the owner of the job is the same user as the owner of the database.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      \u0e1b\u0e31\u0e0d\u0e2b\u0e32\u0e19\u0e35\u0e49\u0e40\u0e01\u0e34\u0e14\u0e08\u0e32\u0e01\u0e01\u0e32\u0e23 Upgrade \u0e08\u0e32\u0e01 SQL 2005 Express \u0e44\u0e1b\u0e40\u0e1b\u0e47\u0e19\u0e40\u0e27\u0e2d\u0e23\u0e4c\u0e0a\u0e31\u0e48\u0e19\u0e2d\u0e37\u0e48\u0e19 \u0e40\u0e19\u0e37\u0e48\u0e2d\u0e07\u0e08\u0e32\u0e01\u0e43\u0e19 SQL 2005 Express \u0e44\u0e21\u0e48\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e43\u0e0a\u0e49\u0e07\u0e32\u0e19 SQL Server Agent \u0e44\u0e14\u0e49 \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e2a\u0e48\u0e27\u0e19\u0e19\u0e35\u0e49\u0e08\u0e36\u0e07\u0e42\u0e14\u0e19\u0e08\u0e31\u0e14\u0e01\u0e32\u0e23\u0e42\u0e14\u0e22 VirtualCenter Server service \u0e14\u0e31\u0e07\u0e19\u0e31\u0e49\u0e19\u0e40\u0e21\u0e37\u0e48\u0e2d\u0e44\u0e14\u0e49\u0e17\u0e33\u0e01\u0e32\u0e23 Upgrade SQL \u0e08\u0e36\u0e07\u0e15\u0e49\u0e2d\u0e07\u0e40\u0e1e\u0e34\u0e48\u0e21 Job \u0e43\u0e19 SQL Server Agent<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6,9],"tags":[103,145,153,212,216],"class_list":["post-180","post","type-post","status-publish","format-standard","hentry","category-problems","category-virtualization","tag-howto","tag-performance","tag-problem","tag-virtualcenter","tag-vmware"],"_links":{"self":[{"href":"https:\/\/implementer.co.th\/wordpress\/wp-json\/wp\/v2\/posts\/180"}],"collection":[{"href":"https:\/\/implementer.co.th\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/implementer.co.th\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/implementer.co.th\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/implementer.co.th\/wordpress\/wp-json\/wp\/v2\/comments?post=180"}],"version-history":[{"count":1,"href":"https:\/\/implementer.co.th\/wordpress\/wp-json\/wp\/v2\/posts\/180\/revisions"}],"predecessor-version":[{"id":2235,"href":"https:\/\/implementer.co.th\/wordpress\/wp-json\/wp\/v2\/posts\/180\/revisions\/2235"}],"wp:attachment":[{"href":"https:\/\/implementer.co.th\/wordpress\/wp-json\/wp\/v2\/media?parent=180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/implementer.co.th\/wordpress\/wp-json\/wp\/v2\/categories?post=180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/implementer.co.th\/wordpress\/wp-json\/wp\/v2\/tags?post=180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}