Nov 062014
 

PASS Summit 2014 Logo_930x260Today I presented my SQL Server virtual machine “right-sizing” session at the SQL PASS 2014 Summit to a fantastic audience. I really appreciate each and every one of you for attending. This session was also broadcast on the Summit PASStv live video streaming session, and thanks to all of you who tuned in to watch!

As promised, I have attached the schema and scripts from the session, available to download here. These scripts will help you take Perfmon data that you have loaded into the database (use the Midnight DBAs code available here to do so, demo how-to video here) and run a statistical analysis on the data. The end goal is to help you understand the resource consumption of your SQL Servers, both physical or virtual, and take this data to determine the appropriate amount of CPU and memory needed to keep this SQL Server performing well while minimizing the size of the VM.

Also announced in this session is the target date of the end of the year for the beta release of a FREE standalone utility to run on your SQL Servers that will profile the performance trends of the server and present an estimation of the “right” amount of CPU and memory needed to balance the VM’s performance with the VM’s size. If you’d like to be added to the beta tester list, just contact me here and request to be added. Keep an eye on this blog for more details as the project nears a release date!

Nov 052014
 

PASS Summit 2014 Logo_930x260My session today at the SQL PASS Summit 2014 entitled “Right Sizing Your SQL Server Virtual Machine” is going to be broadcast live on the streaming session page called PASStv! It will start broadcasting right at 1:30 PM Pacific time today.  View it live here!

Right-Sizing Your SQL Server Virtual Machines

Wednesday, November 5, 1:30-2:45PM in Room 6E (Level 300)

Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now?

The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.

Oct 292014
 

PASS Summit 2014 Speaking Badge_250x250I can hardly believe how fast this year has flown by. My favorite SQL Server conference of the year, the PASS Summit, is just next week! I can hardly wait! This conference is one of the largest SQL Server and BI conferences of the year, planned and coordinated by the community for the community. It’s happening next week in Seattle, WA, and has over 200 fantastic sessions by the people that have been educating most of us for our entire careers.

It’ll be a crazy week of high-speed education, catching up with old friends, networking with new ones, sending random photos and posts on Twitter, and creating great memories to be retold over the next year.

If you are going to be there, I’d love to meet up! Ping me on Twitter and we’ll definitely get together. Networking is the best part of the Summit, and I encourage you to say hi to random strangers, go to after-hours events that you might ordinarily not attend, and make the most of this tight-knit and close community. Say hi to people! Strike up random conversations. Sit at tables with strangers. The friends you make will last a lifetime. Check out the after-hour gatherings because the list of gatherings and events is longer than my arm!

I’m also honored to have two sessions to present at this year’s Summit. I am thrilled to be able to present at this conference again this year. I know virtualization is not something most DBAs have direct hands-on experience with, but virtualization is here to stay. You will be a better DBA if you have a solid understanding of the technology and how it directly impacts your role as an enterprise-level DBA. I encourage you to join me in my sessions listed below.

Right-Sizing Your SQL Server Virtual Machines

Wednesday, November 5, 1:30-2:45PM in Room 6E (Level 300)

Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now?

The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.

Achieving Peak Performance from Your Virtual SQL Servers

Friday, November 7, 4:00-5:15PM in Room 618-620 (Level 200)

Your SQL Servers are probably virtualized by now, but are they running at their absolute peak performance? How can you tell? When properly configured and maintained, a virtualized SQL Server will be at least as fast as the system that it came from, if not better. If not properly configured, silent performance killers can wreck your virtualization experience. This session will give you tips and tricks to maximize performance while giving you talking points so you can convince your infrastructure engineers to design the virtualization stack your way. This session goes deep into the architecture and methodology for squeezing the best possible performance from your virtualized SQL Server, and includes valuable tips on topics such as host-level over-commitment, storage performance, In-memory OLTP, and more!

Also, the Friday evening after the Summit wraps up, I’m planning some sort of energetic adventure for us geeks! Last year fourteen of us went high-speed go-karting at the GoPro Motorplex just north of Charlotte. This year keep an eye on this blog for the official announcement for what we are up to and when / where to meet up! Here are a couple of photos from the fun we had last year. You are all invited to come with us, and it’s something I hope to make a tradition going forward!

gopro motorplex gopro karting crew

PASS Summit 2014 Logo_930x260

I am greatly looking forward to this conference, and cannot wait to see you there. If you are not able to make this one, make plans to attend next year. It’s the best thing you can do for your career as a SQL Server professional.

Jun 302014
 

2014_header_logoThe SQL PASS Summit 2014 community sessions were recently released. I’m very pleased and honored to announce that I will be presenting a 75-minute session entitled “Right Sizing Your Virtual Machine” at the Summit this November. It’s a topic that I spend many hours a week on in my professional duties with my company, and I am very excited about sharing the fundamentals of the topic and the methodology that I use to perform a right-sizing analysis on a SQL Server virtual machine. If you have a virtualized SQL Server anywhere in your environment – this topic will matter to you.

Abstract: Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM (Virtual Machine) is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the “right” amount of resources to allocate? What happens if the workload changes a month from now? Join this session and find out!

The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly “right-size” the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.

If you did not get selected for the Summit this year, don’t fret. Keep up the great work in the community and keep submitting. Refine your topics and speaking style at various events, like SQL Saturdays, PASS Virtual Chapter presentations, or SQL Server user group sessions. All of the experience adds up, and with the right presentation background, topic, and some luck, we’ll all be speaking there next year.

I really hope that you are able to attend the Summit this year – and every year after. I consider it the most professionally important conference of the year for any SQL Server professional. Attending the conference over the last three years has changed my career and my life in a number of fantastic ways, and it can do the same for you.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close