Turners SharePoint Web Site

How we did it

2 Page Anatomy Custom menu control ASP.Net

Forms Controls HTML Content Data Form Web Parts Custom Search Web Part Content Query Web Part HTML Content

3 Search Anatomy Custom search web part Full Text Query

4 Details Pages Data Form web part Custom web part Data Form web part Data Form web part

5 Platform Architecture Auction Mgmt System Export XML file of Changes Biztalk process File Index Lists SP Lists Web Service Get Lookups Get Existing Items

6 Alternate Architecture Auction Mgmt System Export XML file of Changes Biztalk process File Update SQL Tables Index BDC BDC Entities

7 Search • Advanced Search only works from Search Centre • Search hits only logged in Search Centre • Items not returned when sorting on property • Registry change

8 Server Topologies NLB Index / Query Server Web Query Server Active Directory NLB Web Query Server Web Query Server Index Server Active Directory

9 Performance Analysis Bottle Neck 0% 20% 40% 60% 80% 100% Disk IO SQL Queries LAN Speed Web Server Data Forms Lists Page size Internet Browser

10 Disk Configuration Local Disk Operating System Temp DB SAN Temp DB Backups DB Logs Search Database Content Databases

11 Large Lists • More than 2000 use sub folders • Select only fields needed in Data Form Web Part • • does not do this Modify Datasource Query with • Index columns you filter on • • Creates a lookup table in SQL that is indexed Use query optimise stored procedure (will be in SP2) • Indexes become fragmented quickly if frequent data changes • Cache XSLT output

12 Windows Load Balancing • Supported by Microsoft • Affinity • IP address sticky • Query and Index Servers • Index server does not propagate if also Query • All queries go to query server regardless of web front end

13 Compression • • • • • IIS compressing everything • Cannot exclude web services IISExpress • Doesn’t compress postbacks F5 • • Hardware based Optimisation modules costs more PipeBoost • • Good compression and granularity No Optimisation RPO • • • Compression and Optimisation Must test thoroughly Disable BlobCache?

14 Page Optimisation • Core.js in an IFRAME and only when authenticated • Modify init.js to remove ActiveX control • Remove view state at a page level set on controls • Remove in line Javascript and CSS • Combine CSS and JS files

15 Output Cache • Cache’s entire page output • Set globally and overridden at site level • Can also be by page layout • Templates for Internet, Extranet and Internet • Can vary by user rights • Vary by Parameters or Querystring • Consider cache hit ratio

16 Blobcache – How it works Disk Cache 5. Return Image 1. Request Image Server 4. File with Cache Header 2. is File Cached 3. Get File Memory Cache index 3a. Get File From SQL 3b. Re-Write to Disk Cache • • • • No BlobCache no image or file cache headers • Browser will issue 403 • All 403’s are checked and session updated in SSP Database Http Modules to add headers do not work Set max-age – not always default correctly Set Frequency to check cache file • changeCheckInterval SQL Server 6. Refresh Memory Cache

17 Vanity URL • HTTP Module • Uses SharePoint list and page event handler • Re-Write • Used for SEO • External published links • Re-Direct • Support old site URLS with 301 Redirect • Page re-write in future

18 Security • Block calls to web services • _vti_bin by internal IP only in IIS • Block Access to /lists and /forms • Out-of-the-box lockdown feature also blocks indexer from indexing lists • Remove ability to add attachments