Iowa Code Camp 2008-2 Windows and SQL 2008

puffyyaphankyonkersNetworking and Communications

Oct 26, 2013 (4 years and 14 days ago)

100 views

Todd Klindt

Solanite Consulting


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


What You Need in Windows Server 2008


Manageability


PowerShell
, 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


Will SharePoint 2007 work with Windows
Server 2008?


Absolutely!


Requires Slipstream WSS 3.0 with SP1 and MOSS
2007 with SP1


Note:



New STSADM command
-

Mergecontentdbs


Last 32 bit version of SharePoint



Requires IIS 6 Backward compatible
components for IIS 6 Metabase compatibility
(ADSI and WMI)


Windows SharePoint 3.0 with SP1 includes
dependencies will configure IIS 7 Role config


WSS or MOSS will fail install if not with SP1


Server Manager


Reliability Manager


PowerShell


Server Management (700+new settings)


Event Viewer & Task Scheduler


Create configuration as templates for reuse


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

WinRM

(Remote Management)


Management “despite” firewalls


Implementation of WS
-
Management protocol


Based on HTTP/HTTPS connectivity


XML is the data structure

WinRS

(Remote Shell)


Executes command line commands and
executed locally


WINRS <Server> <Command>



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


Events


Notifications and user
-
defined actions on events


Richer online event information


Event Forwarding


Consolidate events remotely over WS
-
Management


XPath

subscriptions



Trigger on events


Password resilience


Execution History


Task Import and Export


Failure Notification


.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


SharePoint 14 will likely leverage
PowerShell

extensively


Built in Firewall


SCW 2.0


URLScan


Minimal Application footprint


Minimal Services


(Imagine core with
HyperV
)

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

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

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

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


SMB2.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)


SMB 1.0

Write

Request

Write

Response

SMB 2.0

Branch

Hub

Windows Server
2008

Windows Server
2008

0
200
400
600
800
1000
268MB file (268MB total) upload
268MB file (268MB total) download
1MB files (100MB total) upload
1MB files (100MB total) download
Duration in Seconds (lower is better)

WS03
WS08

The file transfer improvements in SMB2 improve
large
-
file Office and Windows shell interactions


0
5
10
15
20
25
30
35
Explorer 6MB
file copy
Explorer 50-
file browse
Word 2MB
file open
Excel 47kB
file open
Duration in Seconds (lower is better)

Office 2007 and Shell Operations WAN (100ms latency)

XP SP2 (SMB 1)
Vista SP1 (SMB 2)

Requests/sec (bigger is
better)



0
50
100
150
200
WS 2003
WS 2008
Microsoft.com

Microsoft.com website

10%
higher throughput
(normalized to CPU usage)


Production server
performance monitored over
72 hours


WS08/IIS7 enables MS.COM
to process over
100 million
additional web requests per
day at current CPU usage
level (extrapolation based on
existing hardware)



On Windows Server 2003


Upgrade to SP1 or later first


Upgrade any Database engine storage to Windows
Internal Database Engine SP2


Backup your Farm (to separate server)


Proceed with OS upgrade


Verify Upgrade


Upgrade Complete
-

Windows Server 2008


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
WS03, (we did NOT expect this!)


Didn’t really notice most of the time it wasn’t
WS03 (very quick ramp up)



http://technet.microsoft.com/en
-
us/office/sharepointserver/bb735844.aspx


AMD Developer Case Study


Upgrading to 64 bit Windows Server 2008 (Steve
Smith & Penny Coventry MVPs)


Coming Soon!


Updated
Eval

Guides and WS08 Better together with
SharePoint detailed analysis


Downloadable HOLs


Windows Server 2008 and MOSS install


Powershell

and SharePoint


SharePoint and WS08 Customizing Event Viewer


IIS 7 failed request tracing (Hot!)

Management


Database Mirroring Enhancements


Policy Based Administration


Cluster enhancements


Resource Governor


Easier to deploy

Security


Transparent Database Encryption


Backup compression (25
-
35% at least)


Reporting Services in SharePoint Mode


Data compression



SharePoint 2007 SP1 supports SQL 2008


SQL 2008