I just want to know how much space does your vCenter DB consume and what are your biggest tables?<\/p>\n
<\/p>\n
Earlier on my vCenter 5.5\u00a0we had a 90 GB Database. I shrinked it to 40 GB before i started my\u00a0upgrade to vCenter 6.<\/p>\n
To my environment:<\/p>\n
Now my vCenter DB has 69 GB and 165 GB<\/strong> transaction logs. That sounds huge, isn’t it? So i talked to\u00a0VMware Support, they gave me some scripts to shrink the Database (those I had already) and said that’s normal for that environment.<\/p>\n \n
![\n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nSQL Script to get the biggest tables:<\/p>\nselect object_name(id) [Table Name],\r\n[Table Size] = convert (varchar, dpages * 8 \/1024) + 'MB'\r\nfrom sysindexes where indid in (0,1)\r\noder by dpages desc<\/pre>\n\nWhat do you think? How big are your DB’s?<\/p>\nPlease leave a comment.<\/p>\n","protected":false},"excerpt":{"rendered":"I just want to know how much space does your vCenter DB consume and what are your biggest tables?<\/p>\n","protected":false},"author":1,"featured_media":414,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[11,10,7],"tags":[],"class_list":["post-390","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","category-vcenter","category-vsphere"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t](\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/vc-db\/1.JPG\"\n){kind=link}
![\n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\t\t\n\t\t\t\t \n \n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nSQL Script to get the biggest tables:<\/p>\nselect object_name(id) [Table Name],\r\n[Table Size] = convert (varchar, dpages * 8 \/1024) + 'MB'\r\nfrom sysindexes where indid in (0,1)\r\noder by dpages desc<\/pre>\n\nWhat do you think? How big are your DB’s?<\/p>\nPlease leave a comment.<\/p>\n","protected":false},"excerpt":{"rendered":"I just want to know how much space does your vCenter DB consume and what are your biggest tables?<\/p>\n","protected":false},"author":1,"featured_media":414,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[11,10,7],"tags":[],"class_list":["post-390","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","category-vcenter","category-vsphere"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t](\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/vc-db\/2.JPG\"\n){kind=link}
![\n \n <\/a>\n <\/div>\n\t\t\t\t\t\t\t<\/div> \n\t\t\t\n \n\t\t\n\t\t\n\t<\/div>\t<\/div>\n<\/p>\n\nSQL Script to get the biggest tables:<\/p>\nselect object_name(id) [Table Name],\r\n[Table Size] = convert (varchar, dpages * 8 \/1024) + 'MB'\r\nfrom sysindexes where indid in (0,1)\r\noder by dpages desc<\/pre>\n\nWhat do you think? How big are your DB’s?<\/p>\nPlease leave a comment.<\/p>\n","protected":false},"excerpt":{"rendered":"I just want to know how much space does your vCenter DB consume and what are your biggest tables?<\/p>\n","protected":false},"author":1,"featured_media":414,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[11,10,7],"tags":[],"class_list":["post-390","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","category-vcenter","category-vsphere"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t](\"http:\/\/vblog.hochsticher.de\/wp-content\/gallery\/vc-db\/3.JPG\"\n){kind=link}