-
-
Simon Sabin and I will be presenting at the next London UG tomorrow night at:
NYSE Euronext
Cannon Bridge House
1 Cousin Lane
London
EC4R 3XX
(nearest tube is Cannon Street)
We’ve got some great content to cover so if you’re around it will definitely be worth a visit. The meeting runs from 18:00-21:00. Here is the agenda:
Optimising tempdb and Temporary Object Re-use
Presented by Christian Bolton, Technical Director, Coeo, Ltd.
Microsoft Certified Architect (MCA), Master (MCM), and MVP for SQL Server
This session will cover how and why you should configure tempdb, how to troubleshoot tempdb issues, and how to detect resolve, and mitigate allocation contention issues by creating multiple data files, optimizing temporary object reuse, and using trace flag 1118.
Strategies for Generating and Optimizing SQL Server Query Plan for Maximum Performance
Presented by Simon Sabin, SQL Server Consultant
Microsoft MVP for SQL Server
This session will explore useful techniques for improving queries in Microsoft SQL Server. There are always a large number of tips and techniques applicable in narrow classes of programming tasks, each one offering a small improvement in performance. Knowing as many of these tuning tricks and techniques as possible expands your options when tuning for performance. In addition, knowing an effective process for analyzing query performance and behaviour is an essential skill for any SQL Server professional.
You can register here: http://www.sqlpass.org.uk/
Regards,
Christian Bolton - MCA: SQL Server 2005, MCM: SQL Server 2005, MVP
Technical Director
http://coeo.com - SQL Server Consulting & Managed Services
-
-
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
-
-
I joined Kevin Kline from Quest on Thursday for a webcast on "The 5-minute SQL Server Healthcheck" which is now available online. I hope you find it useful!
http://www.quest.com/events/listdetails.aspx?contentid=10581&technology=34&prod=&prodfamily=&loc=
Regards,
Christian Bolton - MCA: SQL Server 2005, MCM: SQL Server 2005, MVP
Technical Director
http://coeo.com - SQL Server Consulting & Managed Services
-
-
We’re very proud to be sponsoring SQLBits again next week in Newport, Wales and thrilled to have been invited to speak at the event once again. We’re delivering 4 sessions in all so I wanted to give them a quick plug before you all start building your agendas:
Friday 20th November
2:40pm-3:40pm
Strapped for cache? – Troubleshooting memory problems in SQL Server 2008 – Christian Bolton
Learn the terminology, architecture, features, and best practices that can help you understand, troubleshoot and avoid memory
problems in SQL Server 2008.
4:00pm-5:00pm
Virtualising SQL Server – Justin Langford
This session provides attendees with details on how to approach a SQL Server virtualisation project. Discussing topics central
to server virtualisation such as performance and scalability considerations.
Saturday 21st November
2:40pm-3:40pm
Vital Statistics – Christian Bolton
In this session I will be exploring the role that statistics play in query optimization covering how and when they are created, what they look like, how they are updated, and what scenarios will benefit from you creating them yourself.
4:00pm-5:00pm
Server consolidation with SQL Server – Justin Langford
This session will provide attendees with an insight into running a SQL Server consolidation project. We will cover the crucial points to ensure successful server consolidation from both technical and business perspectives.
Regards,
Christian Bolton - MCA: SQL Server 2005, MCM: SQL Server 2005, MVP
Technical Director
http://coeo.com - SQL Server Consulting & Managed Services
-
-
I've been pretty rubbish at blogging over the last 9 months or so but I've got a good excuse; I’ve been hard at work putting together a new book with a few other SQL Server bods and I’m very pleased to say that we are just about done JThe book is called Professional SQL Server 2008 Internals and Troubleshooting. We designed it in two parts: Part 1 deals with internals information on SQL Server, Windows, and Hardware to enable you to work effectively with the troubleshooting tools covered in Part 2 which include SQLDiag, PerfStats, SQLNexus and the Management Data Warehouse.The book will be published under the Wrox brand owned by Wiley and it’ll be one of the first releases in their jazzy new format. We’ve just finalized the cover which you can see below and its available for pre-order on Amazon now with an expected release date of around 22nd December (if everything stays on track).
Now that’s out the way I’m looking forward to getting back to blogging. We’ve got some amazing stuff in the book but there’s still a ton of stuff I just didn’t have time to include which gives me lots of ideas for blog posts! Watch this space...
Order from amazon.com: http://tinyurl.com/yerhl7t
Order from amazon.co.uk: http://tinyurl.com/ydtubhf
I'll blog more about the book's content closer to the release date!
Christian Bolton - MCA: SQL Server 2005, MCM: SQL Server 2005, MVP
Technical Director
http://coeo.com - SQL Server Consulting & Managed Services