Transcript SPUG November - Turners SharePoint Web Site

Turners SharePoint Web Site
How we did it
Page
Anatomy
Custom menu control
ASP.Net
Forms
Controls
HTML Content
Data Form Web Parts
Custom
Search
Web
Part
2
Content Query Web
Part
HTML
Content
Search
Anatomy
Custom search web part
Full Text Query
3
Details
Pages
Data Form web part
Custom web part
Data Form web part
4
Data Form
web part
Platform Architecture
Get Lookups
Auction
Mgmt
System
5
Export XML
file of
Changes
Biztalk
process File
Index Lists
SP Lists Web
Service
Get Existing
Items
Alternate Architecture
Auction
Mgmt
System
6
Export XML
file of
Changes
Biztalk
process File
Index BDC
Update SQL
Tables
BDC Entities
Search
• Advanced Search only works from Search
Centre
• Search hits only logged in Search Centre
• Items not returned when sorting on
property
•
7
Registry change
Server Topologies
NLB
NLB
Index /
Query
Server
Web
Query
Server
Web
Query
Server
Index
Server
Active
Directory
8
Web
Query
Server
Active
Directory
Performance Analysis
Disk IO
SQL Queries
LAN Speed
Web Server
Data Forms
Lists
Page size
Bottle Neck
Internet
Browser
0%
9
20%
40%
60%
80%
100%
Disk Configuration
Local
Disk
Operating
System
Temp DB
Temp DB
DB Logs
Backups
SAN
10
Search
Database
Content
Databases
Large Lists
• More than 2000 use sub folders
• Select only fields needed in Data Form Web Part
•
<DataFields><DataFields> does not do this
•
Modify Datasource Query with <ViewFields>
• 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
11
Windows Load Balancing
• Supported by Microsoft
• Affinity
•
IP address sticky
• Query and Index Servers
12
•
Index server does not propagate if also Query
•
All queries go to query server regardless of web front
end
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
13
•
Compression and Optimisation
•
Must test thoroughly
•
Disable BlobCache?
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
14
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
15
Blobcache – How it works
5. Return Image
1. Request Image
Server
4. File with
Cache Header
2. is File Cached
Disk Cache
3. Get File
3b. Re-Write to
Disk Cache
Memory
Cache
index
3a. Get File
From SQL
SQL Server
6. Refresh Memory Cache
16
• 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
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
17
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
18