Abstract: Think infrastructure in the cloud is still just for sysadmins? Think again! As your organization moves into the cloud, infrastructure skills are more important than ever for DBAs to master. Expert knowledge of cloud-related infrastructure will help you maintain performance and availability for databases in the cloud. For example, know what an IOP is? How many does your database consume during a given day? Properly sizing a cloud database depends on your knowledge of this metric. Failure to properly configure storage performance at the time of deployment will slow down your SQL Server considerably. Come learn many of the key cloud infrastructure points that you should master as the DBA role continues to evolve!
Tomorrow I’ll be presenting a new session for the PASS Virtualization Virtual Chapter called “Virtual SQL Servers, Actual Performance” tomorrow at 1PM Eastern time. Register for this free webinar today!
Presentation abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance.
This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.
Next Wednesday, January 13th, at 1pm Eastern the PASS Virtualization Virtual Chapter will be holding an open questions and answers session on anything related to SQL Server virtualization, with me as your host! Send over your questions to either Tom Norman (VC lead), or over to me and we’ll get them answered for you! Any SQL Server virtualization question is welcomed in this no-holds-barred open session. We’ve had a blast with these in the past, and look forward to answering all of your questions!
Next Wednesday, August 19th, at noon Eastern the PASS Virtualization Virtual Chapter will be holding an open questions and answers session on anything related to SQL Server virtualization, with me as your host! Send over your questions to either Tom Norman (VC lead), or over to me and we’ll get them answered for you! Any SQL Server virtualization question is welcomed in this no-holds-barred open session.
RSVP for this free webinar here! I look forward to seeing you all there.
Today I presented a new session on the various paths to becoming a consultant to the PASS Professional Development Virtual Chapter. I thoroughly enjoyed presenting this session, and the questions were great! Plus, the coordinators for the VC have the session up on YouTube already!
The slides for this presentation are available for you to download here, and the sample rate estimator that I put together is available for you here. Please let me know if you have any more questions!
Today I presented the final ramp up session entitled “Virtualization for SQL Server DBAs 499” for the SQL PASS Virtualization Virtual Chapter. It’s the last session in a four-part where the goal is to take the DBA from knowing nothing about infrastructure and virtualization technologies up to where they can identify specific issues with performance and availability and work directly with the VM administrators – in their nomenclature – to get the VMs stable, highly available, and tuned for maximum performance. This last session worked on common performance troubleshooting scenarios and the quick hits for remediation from both perspectives. The previous session recordings (101-301) are available on my videos page here.
Special thanks goes to Matt Penny (@salisbury_matt) for an absolutely awesome SketchNote!
Next it’s on to special topics! In January I will be working with the chapter to present an updated version of my Summit 2014 session – “How to Right-Size Your SQL Server VMs“, and after that, I’m going to be working on a session to demonstrate configuring and using cluster and Availability Groups in a virtual environment. If you have any special topics that you’d like to learn more about and/or see demos of, please let me know! I’m always looking for new ideas for topics, and if it matters to you, it’s guaranteed to matter to someone else, and I’m willing to get a webinar put together to make it happen.