Coeo SQLBits 5 sessions now available
Thank you very much to the SQLBits organizers for the best SQLBits ever at the weekend! The get better every time but this time they put the conference into a different league. Well done guys!
We’ve uploaded the slides and demos scripts for all four of the Coeo sessions to our website for you to download here: http://coeo.com/sql-server-events/sql-server-conferences.html
As a reminder, here are the titles and agendas:
Strapped for Cache? Troubleshooting memory problems in SQL Server 2008 By Christian Bolton
- Physical vs. Virtual Memory
- What uses SQL Server’s Virtual Memory?
- MemToLeave
- What happens when SQL Server starts?
- SQL Server’s Memory Model
- Memory Nodes, Clerks, Caches, and Pools
- Data Cache, Plan Cache
- Best Practices
Virtualising SQL Server By Justin Langford
- Business and technical drivers
- Why virtualise?
- Project goals, benefits and pitfalls
- Virtualisation planning
- Special aspects of SQL Server's resource requirements
- SQL Instance design
- Virtualisation Design and implementation
- Considerations for solution design
- Using Virtualisation to provide High Availability
- Configuration optimisations
- Potential issues and solutions
- Troubleshooting SQL Server on virtualised platforms
Vital Statistics By Christian Bolton
- The need for Statistics
- What they are and what they look like
- How and when statistics are created
- When to manually create statistics
- How and when statistics are updated
- What you should be doing
- New features for SQL Server 2005 and 2008
- Upgrading SQL Server
Server Consolidation with SQL Server By Justin Langford
- Business and technical drivers
- Why consolidate?
- Type of consolidation (physical, storage, geographic)
- Planning and considerations
- Key considerations (SQL Server behaviour/ characteristics in shared environments disk/ CPU/ memory)
- Designing SQL instance and common configurations
- Guiding principles for consolidation Design and implementation
- Consolidation process
- Migration Techniques
- Potential issues and solutions
- Shared components (schedulers, buffer pool, procedure cache, disk IO, tempdb)
- Using Windows Server Resource Manager or Resource Governor
The sessions were also filmed by Microsoft so I’ll update this post with the links when they’ve been edited and made available.
Regards,
Christian Bolton - MCA: SQL Server 2005, MCM: SQL Server 2005, MVP
Technical Director
http://coeo.com - SQL Server Consulting & Managed Services