Transcript Upgrading to SQL Server 2012 *Done Right*

[email protected]
www.ilikesql.com
Dandy
Weyn
@ilikesql
Ideal discovery tool for Database Migration, Upgrade
And Consolidation Projects
http://www.microsoft.com/map
Upgrade Methods / Scenarios
•
•
•
•
Less granular control over upgrade process
Instance remains offline during part of upgrade
Not best practice for all components
Considerations for Rollback Strategy
•
•
•
•
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
•
•
•
•
•
•
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 upgrade
Goes frequently together with platform upgrade (x86->x64)
•
•
•
•
Easier, mostly automated, generally fast overall process
System data upgraded
May require no additional hardware
Applications remain pointing to same server/DB
•
•
•
Usually require additional hardware
Server/database name changes
Not practical for VLDB unless utilizing SAN
•
•
•
Requires additional Hardware
Server/Database name changes
Not practical for VLDB unless utilizing SAN
Map Toolkit
Assessment and
Reporting
SQL Server / Instance
Discovery
•
•
Distributed Replay
SQL Server Upgrade Advisor
•
•
•
Prepares for upgrade
Analyzes installed components
Generates a report with blockers
•
•
•
•
Simulates a mission-critical
workload
Application compatibility
Performance testing
Capacity Planning
RMLUtils
SQL Server Upgrade
Assistant
•
•
Complements the upgrade process
Incredible instruments in complex upgrade
scenarios
•
•
•
Capture test workload
Setup baseline environment
Used to identify compatibility
issues
Batch Request
1 Preprocess
Batch Request
Batch Request
User
Controller
2 Replay
…
SQL Server
Batch Request
Multiple Replay Clients
\\UNCPath
mva
http://northamerica.msteched.com
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn