{"id":1682,"date":"2013-06-30T10:08:02","date_gmt":"2013-06-30T10:08:02","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=1682"},"modified":"2024-04-26T12:48:56","modified_gmt":"2024-04-26T12:48:56","slug":"getting-your-arms-around-the-database-sizing-of-your-sharepoint-farm","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/getting-your-arms-around-the-database-sizing-of-your-sharepoint-farm\/","title":{"rendered":"Getting your arms around the database sizing of your SharePoint farm"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/getting-your-arms-around-the-database-sizing-of-your-sharepoint-farm\/#SharePoint_Database_Size_Planning\" title=\"SharePoint Database Size Planning\">SharePoint Database Size Planning<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/getting-your-arms-around-the-database-sizing-of-your-sharepoint-farm\/#Size_of_all_SharePoint_Databases\" title=\"Size of all SharePoint Databases\">Size of all SharePoint Databases<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/getting-your-arms-around-the-database-sizing-of-your-sharepoint-farm\/#RBS_Report\" title=\"RBS Report\">RBS Report<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/getting-your-arms-around-the-database-sizing-of-your-sharepoint-farm\/#Site_Collection_size_report\" title=\"Site Collection size report\">Site Collection size report<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/getting-your-arms-around-the-database-sizing-of-your-sharepoint-farm\/#Quota_Report\" title=\"Quota Report\">Quota Report<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"SharePoint_Database_Size_Planning\"><\/span>SharePoint Database Size Planning<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In order to manage your SharePoint farm, and especially for planning for backup\/recovery you need to understand data sizing of your farm. Here are the steps you can take to gather the information needed to understand the existing farm and estimate its growth. This will give you a clear understanding of the size of your backups, so you can plan for recovery timeframes, and will also give insights into the rate of growth and on quotas that can govern growth of databases.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Size_of_all_SharePoint_Databases\"><\/span>Size of all SharePoint Databases<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To plan for DR one needs to know the size of all databases to be backed up and restored. This small script will produce a CSV report of the bytes per database attached to the SharePoint farm:<\/p>\n<pre lang=\"php\">\t\r\nGet-SPDatabase | select name,DiskSizeRequired | convertto-csv | set-content \"C:DBsize.csv\"<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"RBS_Report\"><\/span>RBS Report<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There is no direct mechanism in Central Admin to view RBS configuration. This script will give you a report of the RBS settings throughout your farm:<\/p>\n<pre lang=\"php\">Get-SPContentDatabase | foreach {$_;\r\n  try {\r\n \r\n      $rbs = $_.RemoteBlobStorageSettings;\r\n      write-host \"Provider  Name=$($rbs.GetProviderNames())\";\r\n      write-host \"Enabled=$($rbs.enabled)\";\r\n      write-host \"Min Blob  Size=$($rbs.MinimumBlobStorageSize)\"\r\n      }\r\n  catch\r\n  {write-host -foregroundcolor red \"RBS not installed on this database!`n\"}\r\n  finally {write-host \"End`n\"}\r\n}<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Site_Collection_size_report\"><\/span>Site Collection size report<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>It is useful to know the sizes of your Site Collections, and their distribution among your Content Databases. You can report on the size of each Site Collection within each Content DB within a given Web Application with the script below. The output is a CSV (Comma Separated Value) file easily read into Excel. If you have a lot of Site Collections, just convert to a PivotTable, to see the distribution and sizes of Site Collections across Content Databases.<\/p>\n<pre lang=\"php\">get-spwebapplication http :\/\/SharePoint | Get-SPSite -Limit all | select url,contentdatabase,@{label=\"Size in GB\";Expression={$_.usage.storage\/1GB}} | convertto-csv | set-content \"C:TEMPDBsize.csv\"\r\n<\/pre>\n<p>Site Collection sizes help inform how to rebalance Content Databases for optimal sizing to allow you to meet your RTO.<br \/>\nOne common situation is for MySites to be distributed unevenly across Content Databases, leading to one Content Database being much larger than others. As discussed earlier, managing Content Database sizes is key to meet your RTO.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Quota_Report\"><\/span>Quota Report<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Setting quotas puts in place limits on Site Collection growth. It also gives the Administrator weekly notification of Site Collections that have exceeded a preset warning size.<br role=\"presentation\" data-uw-rm-sr=\"\" \/>This report gives you a list of all the quotas in place across a Web Application:<\/p>\n<pre lang=\"php\">\r\n$webapp = Get-SPwebapplication \"http :\/\/SharePoint\"\r\n$webapp | get-spsite -Limit ALL | ForEach-Object {\r\n$site = $_;\r\n$site;\r\n$site.quota;\r\n}\r\n$site.dispose()\r\n$webapp.dispose()\r\n<\/pre>\n<p>What you want to look for first are Site Collections that have no quotas. These represent opportunities for unconstrained growth without notification that could result in Content Database growth that exceeds your RTO targets.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SharePoint Database Size Planning In order to manage your SharePoint farm, and especially for planning for backup\/recovery you need to understand data sizing of your farm. Here are the steps you can take to gather the information needed to understand the existing farm and estimate its growth. This will give you a clear understanding of [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":1683,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[25],"tags":[],"class_list":["post-1682","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-architecture"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=1682"}],"version-history":[{"count":1,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1682\/revisions"}],"predecessor-version":[{"id":1690,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1682\/revisions\/1690"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/1683"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=1682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=1682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=1682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}