{"id":254,"date":"2018-01-22T09:55:53","date_gmt":"2018-01-22T09:55:53","guid":{"rendered":"http:\/\/labiol.xyz\/?p=254"},"modified":"2018-01-22T11:53:34","modified_gmt":"2018-01-22T11:53:34","slug":"problemy-z-vcenter-przepelniona-baza-danych-mssql","status":"publish","type":"post","link":"https:\/\/www.labiol.xyz\/index.php\/2018\/01\/22\/problemy-z-vcenter-przepelniona-baza-danych-mssql\/","title":{"rendered":"Problemy z vcenter &#8211; przepe\u0142niona baza danych mssql"},"content":{"rendered":"<p>Problem znany z baz MSSQL Express gdzie licencja dla bazy danych (bez umieszczania op\u0142at) ma ograniczenie co do ilo\u015bci przechowywania danych. Starsze wersje mia\u0142y ograniczenie do 4GB, natomiast nowsze wersje MSSQL maj\u0105 ograniczenie do 10GB.<\/p>\n<p>W zwi\u0105zku z powy\u017cszym w tej chwili mamy kilka rozwiaza\u0144.<\/p>\n<ol>\n<li>Mo\u017cna przenie\u015b\u0107 baz\u0119 MSSQL do vPostgreSQL. Problem polega na tym, \u017ce mo\u017cemy to zrobi\u0107 tylko przy upgrade mi\u0119dzy wersjami. Dodatkowo vPostgreSQL MUSI dzia\u0142a\u0107 na tym samym ho\u015bcie co vCenter. Nie mo\u017cemy tego rozdzieli\u0107, co mo\u017ce ew. powodowa\u0107 problemy przy badaniu problem\u00f3w z wydajno\u015bci\u0105.<\/li>\n<li>Wykupi\u0107 licencj\u0119 MSSQL, ale to kosztuje, nie zawsze znajdzie si\u0119 na to bud\u017cet<\/li>\n<li>Rozwi\u0105zanie tymczasowe, ale natychmiastowo skuteczne &#8211; wyczy\u015bci\u0107 baz\u0119 danych.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>Poni\u017cej artyku\u0142y dotycz\u0105ce pkt 3.<\/p>\n<pre>http:\/\/kb.vmware.com\/selfservice\/microsites\/search.do?language=en_US&amp;cmd=displayKC&amp;externalId=1007453\r\nhttp:\/\/kb.vmware.com\/selfservice\/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=2110031\r\n\r\n\r\ntruncate table VPX_HIST_STAT1;\r\ntruncate table VPX_SAMPLE_TIME1;\r\n\r\ntruncate table VPX_TEMPTABLE0;\r\ntruncate table VPX_TEMPTABLE1;\r\ntruncate table VPX_TEMPTABLE2;\r\n\r\n\r\nhttp:\/\/www.stopdoingitwrong.co.uk\/vmware-vcenter-server-5-1-database-is-full\/\r\n<blockquote class=\"wp-embedded-content\" data-secret=\"IrAKawHqUg\"><a href=\"https:\/\/www.bussink.ch\/?p=495\">Creating a Maintenance Plan for SQL Server 2008 R2 for vCenter\/UpdateMgr\/vCloud<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" src=\"https:\/\/www.bussink.ch\/?p=495&#038;embed=true#?secret=IrAKawHqUg\" data-secret=\"IrAKawHqUg\" width=\"600\" height=\"338\" title=\"&#8220;Creating a Maintenance Plan for SQL Server 2008 R2 for vCenter\/UpdateMgr\/vCloud&#8221; &#8212; Erik Bussink\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\r\n<blockquote class=\"wp-embedded-content\" data-secret=\"1smK2dpJ8k\"><a href=\"http:\/\/www.vbrain.info\/2014\/08\/19\/vcenter-database-running-full\/\">vCenter Database running full<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" src=\"http:\/\/www.vbrain.info\/2014\/08\/19\/vcenter-database-running-full\/embed\/#?secret=1smK2dpJ8k\" data-secret=\"1smK2dpJ8k\" width=\"600\" height=\"338\" title=\"&#8220;vCenter Database running full&#8221; &#8212; vBrain.info\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\r\nhttps:\/\/paulgrevink.wordpress.com\/2013\/06\/06\/vcenter-server-database-extreme-maintenance\/<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Problem znany z baz MSSQL Express gdzie licencja dla bazy danych (bez umieszczania op\u0142at) ma ograniczenie co do ilo\u015bci przechowywania danych. Starsze wersje mia\u0142y ograniczenie do 4GB, natomiast nowsze wersje MSSQL maj\u0105 ograniczenie do 10GB. W zwi\u0105zku z powy\u017cszym w tej chwili mamy kilka rozwiaza\u0144. Mo\u017cna przenie\u015b\u0107 baz\u0119 MSSQL do &hellip; <\/p>\n","protected":false},"author":1,"featured_media":245,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-254","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vmware"],"_links":{"self":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts\/254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/comments?post=254"}],"version-history":[{"count":3,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts\/254\/revisions"}],"predecessor-version":[{"id":257,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts\/254\/revisions\/257"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/media\/245"}],"wp:attachment":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/media?parent=254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/categories?post=254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/tags?post=254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}