{"id":784,"date":"2013-02-04T12:45:15","date_gmt":"2013-02-04T12:45:15","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=784"},"modified":"2024-04-26T12:51:07","modified_gmt":"2024-04-26T12:51:07","slug":"system-characteristics-of-a-well-performing-sharepoint-farm","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/system-characteristics-of-a-well-performing-sharepoint-farm\/","title":{"rendered":"System characteristics of a well performing 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\/system-characteristics-of-a-well-performing-sharepoint-farm\/#DB_management\" title=\"DB management\">DB management<\/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\/system-characteristics-of-a-well-performing-sharepoint-farm\/#Monitor_the_database_server\" title=\"Monitor the database server\">Monitor the database server<\/a><\/li><\/ul><\/nav><\/div>\n<h4>Characteristics of a well-performing SharePoint Farm<br \/>\nTempdb data files<\/h4>\n<ul>\n<li>Dedicated disks for the tempdb<\/li>\n<li>Tempdb should be placed on RAID 10<\/li>\n<li>The number of tempdb files should be equal the number of CPU Cores, and the tempdb data files should be set at an equal size<\/li>\n<\/ul>\n<p>The size of the tempdb data files should be equal to the (Physical memory no. of processor). That\u2019s the initial size of the tempdb data files.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"DB_management\"><\/span>DB management<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>\u00a0Enough headroom must be available for the databases and log files, plus enough capacity to keep up the requests<\/li>\n<li>Pre grow all databases and logs if you can. Be sure to monitor the sizes so that you do not run out of disk space<\/li>\n<li>When using SQL Server mirroring, do not store more than 50 databases on a single physical instance of SQL Server<\/li>\n<li>Database servers should not be overloaded by using too many databases or data<\/li>\n<li>The content databases must be limited to 200GB. Limit content databases to 200GB Indices must be Defragmented and rebuilt daily, if users can absorb the downtime required to rebuild<\/li>\n<li>More than 25% disk space must be free.<\/li>\n<li>Another instance of SQL must be created for data exceeding 5 TB.<\/li>\n<li>When using SQL Server mirroring, more than 50 databases must not be stored on a single physical instance of SQL Server<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Monitor_the_database_server\"><\/span>Monitor the database server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Key performance counters to monitor are:<\/p>\n<ul>\n<li>Network Wait Queue: at 0 or 1 for good performance<\/li>\n<li>Average disk queue Length (latency): less than 5 ms<\/li>\n<li>Memory used: less than 70%<\/li>\n<li>Free disk space: more than 25%<\/li>\n<\/ul>\n<h2><\/h2>\n<p>&nbsp;<\/p>\n<h2><\/h2>\n","protected":false},"excerpt":{"rendered":"<p>Characteristics of a well-performing SharePoint Farm Tempdb data files Dedicated disks for the tempdb Tempdb should be placed on RAID 10 The number of tempdb files should be equal the number of CPU Cores, and the tempdb data files should be set at an equal size The size of the tempdb data files should be [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":931,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[32],"tags":[],"class_list":["post-784","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sharepoint"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/784","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=784"}],"version-history":[{"count":3,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/784\/revisions"}],"predecessor-version":[{"id":791,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/784\/revisions\/791"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/931"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}