DB Name Purpose Size (MB) SharePointAdminContent_<GUID> SharePoint Central Administration Database 768 SharePoint_Config SharePoint Configuration Database 1,574 System Databases – tempdb SQL Server Temporary Database 16,384 ReportServer A Microsoft SQL Server database that stores all report metadata including report definitions, report history and snapshots, and scheduling information. 10 ReportServerTempDB A Microsoft SQL Server database that stores all of the temporary snapshots while reports are running. 3 SPContent01 (Document Center 1 content database) SharePoint content databases 15,601,286 SPContent02 (Document Center 2 content database) SharePoint content databases 15,975,266 FAST_Query_CrawlStoreDB_<GUID> Crawler for the FAST Search Query Search Service Application. This crawl store database is only used for user profiles (People Search). 15 FAST_Query_DB_<GUID> Administration database for the FAST Search Query Search Service Application. 125 FAST_Query_PropertyStoreDB_<GUID> Stores the metadata properties and security descriptors for the user profile items in the people search index. It is involved in people search queries and returns standard document attributes for people search query results. 173 FASTContent_CrawlStoreDB_<GUID> Crawler store for the FAST Search Content Search Service Application. This crawl store database is used for all crawled items except user profiles. 502,481 FASTContent_DB_<GUID> Administration database for the FAST Search Content Search Service Application. 23 FASTSearchAdminDatabase Administration database for the FAST Search Server 2010 for SharePoint farm. Stores and manages search setting groups, keywords, synonyms, document and site promotions and demotions, property extractor inclusions and 4
Available RAM PACNEC01 899,613 400,059 814,485 812,027 808,842 875,890 Avg CPU APP-1 8.27% 14.50% 17.8% 20.7% 18.4% 16.2% Available RAM APP-1 13,687 13,804 14,002 13,991 13,984 13,413 Avg CPU APP-2 0.28% NA 0.88% 0.8% 0.79% 0.14% Available RAM APP-2 13,916 NA 14,839 14,837 14,833 13,910 Avg CPU FAST-1 8.39% NA NA NA NA 16.6% Available RAM FAST-1 13,998 NA NA NA NA 13,686 Avg CPU FAST-2 8.67% NA NA NA NA 16.7% Available RAM FAST-2 14,135 NA NA NA NA 13,837 Avg CPU FAST-IS1 37.8% NA NA NA NA 83.4% Available RAM 2,309 NA NA NA NA 2,298 Avg CPU FAST-IS2 30.2% NA NA NA NA 66.1% Available RAM 5,162 NA NA NA NA 5,157 Avg CPU FAST-IS3 30.6% NA NA NA NA 69.9% Available RAM 5,072 NA NA NA NA 5,066 Avg CPU FAST-IS4 25.6% NA NA NA NA 58.2% Available RAM FAST 5,243 NA NA NA NA 5,234 - Detailed Results from Series C Testing Test Series D – Vary Web Server RAM In this test series, we vary the amount of RAM on each front-end Web server virtual machine. Figure - Average RPS Figure - Page and transaction response time
Avg CPU WFE-3 NA 52.5% 43.9% 37.7% 31.2% Available RAM WFE-3 NA 6,124 6,008 5,940 6,227 Avg CPU WFE-4 NA NA 44.5% 34.8% 34.7% Available RAM WFE-4 NA NA 6,068 6,083 6,359 Avg CPU WFE-5 NA NA NA 35.1% 32% Available RAM WFE-5 NA NA NA 6,090 6,245 Avg CPU WFE-6 NA NA NA NA 33.9% Available RAM WFE-6 NA NA NA NA 5,893 Avg CPU PACNEC01 2.13% 1.93% 2.54% 2.48% 2.5% Available RAM PACNEC01 899,970 815,502 397,803 397,960 397,557 Avg CPU APP-1 9.77% 11.7% 15% 14.7% 13.6% Available RAM APP-1 14,412 13,990 14,230 14,227 14,191 Avg CPU APP-2 1.06% 0.92% 1% 1% 1.04% Available RAM APP-2 14,928 14,841 14,874 14,879 14,869 Table - Detailed Results from Series E Testing Test Series F – Vary SQL Server CPUs In this test series we vary the number of CPUs available to SQL Server. Figure - Average RPS for series F You can see in Figure 28 that despite minimal CPU use on the SQL Server computer, the page and transaction response times go up when SQL Server has fewer CPUs available to work with. Figure - Page and transaction time for series F In Figure 29 the SQL Server average CPU for the whole computer does not go over 3%. The three front-end Web servers are all around 55% throughout the tests. Figure - Average CPU for series F
(http://code.msdn.microsoft.com/Bulk-Loader-Create-Unique-eeb2d084) (http://code.msdn.microsoft.com/Load-Bulk-Content-to-3f379974) (http://code.msdn.microsoft.com/SharePoint-Testing-c621ae38)