Dandy Weyn DBI335 Dandy Weyn dandywmicrosoftcom wwwilikesqlcom ilikesql AlwaysOn Reliable Secondaries FileTable xVelocity 15k Partitions SQL Server Data Tools Power View BI Semantic Model ID: 435899
Download Presentation The PPT/PDF document "Upgrading to SQL Server 2012 “Done Rig..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Upgrading to SQL Server 2012 “Done Right”
Dandy Weyn
DBI335Slide2
Dandy Weyn
dandyw@microsoft.com
www.ilikesql.com
@
ilikesqlSlide3Slide4Slide5
AlwaysOn
Reliable
Secondaries
FileTable
xVelocity
15k Partitions
SQL Server Data Tools
Power View
BI Semantic Model
Data Quality Services
Full-Text Search Performance
Distributed Replay
Reporting Alerts
ODBC Driver for LinuxStatistical Semantic Search
Windows Server Core SupportMultiple SecondariesAvailability GroupsDefault Scheme for Windows GroupsT-SQL EnhancementsFull Globe SpatialSSMS to Windows Azure Platform
PowerPivot EnhancementsMaster Data Management Excel Add-inPowerShell 2.0 SupportPHP & Java Connectivity
SQL Audit for All Editions
CDC Support for SSIS
New SSIS Design SurfaceOnline Operation EnhancementsMulti-site ClusteringUnstructured Data PerformanceResource Governor EnhancementsDatabase Recovery AdvisorHA for StreamInsightFlexible Failover Policy
Extended Events Enhancements
Contained Database Authentication
SharePoint Active Directory Support
SQL Server Express
LocalDB
User-defined Audit
Audit Filtering
Audit Resilience
FTS Support for Czech and Greek
AlwaysOn
Connection Director
Ad Hoc Reporting
SSIS Troubleshooting
SSIS Package Management
T-SQL Debugger Enhancements
Spatial 2D Support
Unstructured Data PerformanceSlide6
Upgrade Methodology Overview
Landscape
Advisory
Compatibility
Strategy
Upgrade
Post UpgradeSlide7
Microsoft Assessment and Planning (MAP) Toolkit
Ideal discovery tool for Database Migration, Upgrade
And Consolidation Projects
http://www.microsoft.com/map
Agentless
Assessment
ReportingSlide8
Map ToolkitSlide9
Upgrade Methods / Scenarios
Replace an existing instance by one/one upgrade
IN PLACE UPGRADE
Install an instance next to the existing one
SIDE BY SIDE
Install a new server and instances
NEW INSTALLATION
Requires additional Hardware
Server/Database name changes
Not practical for VLDB unless utilizing SAN
More granular control over upgrade process at DB level
Can be used to perform test migration
Ability to run systems side-by-side for parallel runs
Relatively straightforward rollback strategy
Goes frequently together with OS upgradeGoes frequently together with platform upgrade (x86->x64)Usually require additional hardwareServer/database name changesNot practical for VLDB unless utilizing SAN
More granular control over upgrade process at DB levelCan be used to perform test migrationAbility to run systems side-by-side for parallel runsRelatively straightforward rollback strategyEasier, mostly automated, generally fast overall processSystem data upgradedMay require no additional hardware
Applications remain pointing to same server/DB
Less granular control over upgrade process
Instance remains offline during part of upgradeNot best practice for all components Considerations for Rollback StrategySlide10
In-place upgrade – overview
Same Machine and Platform
Keeps Instance Name
Removes the old one
New Shared Components
Mostly Automated
Same or higher editionSlide11
In-place upgrade – pros/cons
Automated
Full Upgrade
Less Granular
No Platform Change
No Rollback StrategySlide12
What’s your plan?Slide13
Upgrade Tools
Map Toolkit
SQL Server Upgrade Advisor
Assessment and Reporting
SQL Server / Instance Discovery
Prepares for upgrade
Analyzes installed components
Generates a report with blockers
RMLUtils
Complements the upgrade process
Incredible instruments in complex upgrade scenarios
Distributed Replay
Simulates a mission-critical workload
Application compatibility
Performance testingCapacity PlanningSQL Server Upgrade Assistant Capture test workloadSetup baseline environmentUsed to identify compatibility issuesSlide14
Upgrade planning – pre-upgrade
Run UA
Run BPA
DBCC CHECKDB
DBCC
SHRINKDATABASE
BACKUP
Environment
DocumentSlide15
Upgrade planning – the upgrade
Checklist
Upgrade
Validate
Go/No Go
SwitchSlide16
Upgrade planning – post-upgrade
Run UA
Run BPA
DBCC CHECKDB
DBCC SHRINKDATAASE
BACKUP
Environment
DocumentSlide17
Upgrade AdvisorSlide18
Distributed Replay
What is Distributed Replay?
Multi-client scalability to drive higher throughput
Higher workload replay fidelity
Useful for stress testing production workload or performing application compatibility testing before upgrades
Why an enhanced replay tool?
Use multiple low-cost clients (workstations) to handle large workload traces within reasonable timeAddress limitations of current SQL Trace based tools (Profiler, Upgrade Assistant)Provide enhanced featuresGroundwork for future workload testing capabilitiesSlide19
…
Controller
Multiple Replay Clients
SQL Server
Trace File
Preprocess
Replay
IR file
IR file
IR file
IR file
IR file
Batch Request
Batch Request
Batch Request
Batch Request
User
1
2
Distributed Replay data & workflowSlide20
Slipstreaming
New common line parameters
UpdateSource
: Where to search for updates
MU: Microsoft update
\\UNCPath (network share) or local folder
UpdateEnabledTrue/False: turns feature on or offFor example:
Setup.exe /
Action=Install /UpdateSource=U:\sql2012Slide21
Upgrade Scenarios ImplementedSlide22
Your to-do list
Upgrade Technical Reference Guide – SQL Server 2008 R2
Upgrade Technical Reference Guide – SQL Server 2012Slide23
Track Resources
@sqlserver
@ms_teched
m
v
a
Microsoft Virtual Academy
SQL Server 2012 Eval Copy
Get Certified!
Hands-On LabsSlide24
Resources
Connect. Share. Discuss.
http://northamerica.msteched.com
Learning
Microsoft Certification & Training Resources
www.microsoft.com/learning
TechNet
Resources for IT Professionals
http://microsoft.com/technet
Resources for Developers
http://microsoft.com/msdn Slide25
Required Slide
Complete an evaluation on CommNet and enter to win!Slide26
Please Complete an Evaluation
Your feedback is important!
Multiple
ways to
E
valuate
S
essions
Be eligible
to win great daily prizes and the grand prize of a $5,000 Travel Voucher!
Scan the Tag
to evaluate this
session now
on
myTechEd MobileSlide27
©
2012 Microsoft
Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the
part
of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation.
MICROSOFT
MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.Slide28