SHAREPOINT 2007 WITH WINDOWS 2008 AND SQL 2008

SHAREPOINT 2007 WITH WINDOWS 2008 AND SQL 2008 Todd Klindt Solanite Consulting

Who is this Todd guy? � � � WSS MVP since 2006 Speaker, writer, consultant, Aquarius Personal Blog www. toddklindt. com/blog Company web site www. solanite. com E-mail todd@solanite. com

Agenda � What You Need in Windows Server 2008 � Manageability Power. Shell, Task Manager, Server Manager IIS 7, Tracing and Diagnostics � Security IIS 7 Minimal Install, URLScan, SCW 2. 0 � Performance TCP/IP Optimization, SMB 2. 0 � What’s Key in SQL 2008? � Database compression � Database encryption

Windows Server 2008 � Will Share. Point 2007 work with Windows Server 2008? � Absolutely! � Requires Slipstream WSS 3. 0 with SP 1 and MOSS 2007 with SP 1 � Note: � New STSADM command - Mergecontentdbs � Last 32 bit version of Share. Point

Quick Lessons � � � Requires IIS 6 Backward compatible components for IIS 6 Metabase compatibility (ADSI and WMI) Windows Share. Point 3. 0 with SP 1 includes dependencies will configure IIS 7 Role config WSS or MOSS will fail install if not with SP 1

Managability � � � Server Manager Reliability Manager Power. Shell Server Management (700+new settings) Event Viewer & Task Scheduler Create configuration as templates for reuse

Server Manager � � Replaces Computer Management Uses role/feature model � Add roles � Add features � Roles have a dependency database � � Multiple roles/features can be installed and configured in one operation Can be managed from Command Line

Windows Remote Management Win. RM (Remote Management) � Management “despite” firewalls � Implementation of WS-Management protocol � Based on HTTP/HTTPS connectivity � XML is the data structure Win. RS (Remote Shell) � Executes command line commands and executed locally � WINRS <Server> <Command>

Event Viewer - Windows Server 2008 � Event Viewer Console � Complete rewrite for Windows Vista & Windows Server 2008 � Improved organization, integration, filtering, and searching � Event Logs � Viewable and exportable to XML � Channels for administrative events, global view across logs

More Event Viewer goodness � Events � Notifications and user-defined actions on events � Richer online event information � Event Forwarding � Consolidate events remotely over WS-Management � XPath subscriptions

Task Scheduler � � � Trigger on events Password resilience Execution History Task Import and Export Failure Notification

Power. Shell � . NET-based interactive shell and scripting language � � Interactive, programmable, secure, and task-oriented Efficient control and automation of admin tasks Manage both desktops and servers in mixed environments Core Windows administration technology In the box for Windows Server 2008 Available as a download for Windows XP, Windows 2003, Windows Vista � Extensible for developers to easily build their own tools � Enables strong command line and GUI integration � � � Broad adoption Exchange Server 2007, Microsoft System Center Operations Manager, Microsoft System Center Virtual Machine Manager � Share. Point 14 will likely leverage Power. Shell extensively �

Demo

Security Focused � � � Built in Firewall SCW 2. 0 URLScan Minimal Application footprint Minimal Services (Imagine core with Hyper. V)

Performance Improvements Next Generation TCP/IP Stack and SMB 2. 0 Automatically adjusts for maximum efficiency Faster network transfers, especially across WAN links Optimized use of available network bandwidth Reduced packet loss resulting in fewer retransmits Optimized performance without loss Intelligent, automated tuning of TCP receive window size Better packet loss resiliency (e. g. wireless connectivity) Advanced congestion control for better throughput

Next Generation TCP Stack #2 Transport Offload Engine Support for dedicated network adapter hardware Offloads TCP processing and/or acceleration Unburden the system CPU from intense TCP/IP processing Good for heavy TCP/IP receive processing with small/ medium numbers of active connections e. g. File Backup Receive Side Scaling Leverage multiple processors for greater parallelism in network receives Good for heavy receive processing with large numbers of connections i. e. web, FTP

File Server – SMB 2. 0 SMB 1. 0 � SMB 2. 0 (Remote File sharing protocol) introduced in Windows Vista and Windows Server 2008 � Helps to reduce network traffic � Greatly increases the number of shared files supported � Improved Performance (can result in many orders of magnitude improvement in throughput) Write Request Write Response

Remote Large File Copy On WAN (100 ms Latency) 1 MB files (100 MB total) download WS 03 WS 08 1 MB files (100 MB total) upload 268 MB file (268 MB total) download 268 MB file (268 MB total) upload 0 200 400 600 800 1000 Duration in Seconds (lower is better) Branch Hub Windows Server 2008

Remote File Applications � The file transfer improvements in SMB 2 improve large-file Office and Windows shell interactions Office 2007 and Shell Operations WAN (100 ms latency) Excel 47 k. B file open Word 2 MB file open Explorer 50 file browse Explorer 6 MB file copy -5 XP SP 2 (SMB 1) Vista SP 1 (SMB 2) 5 15 25 Duration in Seconds (lower is better) 35

Web Server Microsoft. com website Microsoft. com Requests/sec (bigger is better) 10% higher throughput (normalized to CPU usage) 200 WS 2003 150 Production server performance monitored over 72 hours WS 2008 100 50 0 WS 08/IIS 7 enables MS. COM to process over 100 million additional web requests per day at current CPU usage level (extrapolation based on existing hardware)

How Do I Upgrade? � On Windows Server 2003 � Upgrade to SP 1 or later first � Upgrade any Database engine storage to Windows Internal Database Engine SP 2 � Backup your Farm (to separate server) � Proceed with OS upgrade � Verify Upgrade � Upgrade Complete - Windows Server 2008

AMD Developer Central Lessons � � IIS 7 takes a bit of ramp up, but pays off FAST! Install seemed a lot easier and seamless with slipstream Using existing hardware it was faster than WS 03, (we did NOT expect this!) Didn’t really notice most of the time it wasn’t WS 03 (very quick ramp up)

Windows Server 2008 Resources � � http: //technet. microsoft. com/enus/office/sharepointserver/bb 735844. aspx AMD Developer Case Study Upgrading to 64 bit Windows Server 2008 (Steve Smith & Penny Coventry MVPs) Coming Soon! � Updated Eval Guides and WS 08 Better together with Share. Point detailed analysis � Downloadable HOLs Windows Server 2008 and MOSS install Powershell and Share. Point and WS 08 Customizing Event Viewer IIS 7 failed request tracing (Hot!)

What about SQL 2008?

SQL 2008 for Share. Point Admins Management � Database Mirroring Enhancements � Policy Based Administration � Cluster enhancements � Resource Governor � Easier to deploy Security � Transparent Database Encryption

Cost Savings � Backup compression (25 -35% at least) Reporting Services in Share. Point Mode Data compression � Share. Point 2007 SP 1 supports SQL 2008 � �

Demo � SQL 2008