�ݺ�ߣshows by User: DavidKlee2

�ݺ�ߣshows by User: DavidKlee2 / http://www.slideshare.net/images/logo.gif �ݺ�ߣshows by User: DavidKlee2 / Sun, 23 Jul 2017 18:25:49 GMT �ݺ�ߣShare feed for �ݺ�ߣshows by User: DavidKlee2 24 Hours of PASS, Summit Preview Session: Virtual SQL Server CPUs /slideshow/24-hours-of-pass-summit-preview-session-virtual-sql-server-cpus/78171035 pass24hopsummitpreview-klee-170723182549
One of the largest points of contention with virtual SQL Servers and the VM administrators is how to configure the CPUs. Experience says more CPUs are better for performance. VM admins say less is better. Third-party vendors say you need all of them (and it doesn’t matter how many your hosts have either). Can over-provisioning virtual machine CPUs speed things up, or does it slow things down? What is the right methodology to determine the correct number of virtual CPUs? How does this configuration align with the physical servers? From sampling and analyzing performance data, to “right-sizing’ your SQL Server virtual machine CPU count, to properly aligning the VM with the physical server NUMA topology, you will gain the understanding of how to properly manage and validate your virtual SQL Server vCPU configuration in this insightful session. Valuable tips and tricks will be shared that you can take back to your virtual SQL Servers and immediately apply to your own environments.]]>
One of the largest points of contention with virtual SQL Servers and the VM administrators is how to configure the CPUs. Experience says more CPUs are better for performance. VM admins say less is better. Third-party vendors say you need all of them (and it doesn’t matter how many your hosts have either). Can over-provisioning virtual machine CPUs speed things up, or does it slow things down? What is the right methodology to determine the correct number of virtual CPUs? How does this configuration align with the physical servers? From sampling and analyzing performance data, to “right-sizing’ your SQL Server virtual machine CPU count, to properly aligning the VM with the physical server NUMA topology, you will gain the understanding of how to properly manage and validate your virtual SQL Server vCPU configuration in this insightful session. Valuable tips and tricks will be shared that you can take back to your virtual SQL Servers and immediately apply to your own environments.]]> Sun, 23 Jul 2017 18:25:49 GMT /slideshow/24-hours-of-pass-summit-preview-session-virtual-sql-server-cpus/78171035 DavidKlee2@slideshare.net(DavidKlee2) 24 Hours of PASS, Summit Preview Session: Virtual SQL Server CPUs DavidKlee2 One of the largest points of contention with virtual SQL Servers and the VM administrators is how to configure the CPUs. Experience says more CPUs are better for performance. VM admins say less is better. Third-party vendors say you need all of them (and it doesn’t matter how many your hosts have either). Can over-provisioning virtual machine CPUs speed things up, or does it slow things down? What is the right methodology to determine the correct number of virtual CPUs? How does this configuration align with the physical servers? From sampling and analyzing performance data, to “right-sizing’ your SQL Server virtual machine CPU count, to properly aligning the VM with the physical server NUMA topology, you will gain the understanding of how to properly manage and validate your virtual SQL Server vCPU configuration in this insightful session. Valuable tips and tricks will be shared that you can take back to your virtual SQL Servers and immediately apply to your own environments. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/pass24hopsummitpreview-klee-170723182549-thumbnail.jpg?width=120&height=120&fit=bounds" /><br> One of the largest points of contention with virtual SQL Servers and the VM administrators is how to configure the CPUs. Experience says more CPUs are better for performance. VM admins say less is better. Third-party vendors say you need all of them (and it doesn’t matter how many your hosts have either). Can over-provisioning virtual machine CPUs speed things up, or does it slow things down? What is the right methodology to determine the correct number of virtual CPUs? How does this configuration align with the physical servers? From sampling and analyzing performance data, to “right-sizing’ your SQL Server virtual machine CPU count, to properly aligning the VM with the physical server NUMA topology, you will gain the understanding of how to properly manage and validate your virtual SQL Server vCPU configuration in this insightful session. Valuable tips and tricks will be shared that you can take back to your virtual SQL Servers and immediately apply to your own environments.

24 Hours of PASS, Summit Preview Session: Virtual SQL Server CPUs from David Klee

]]> 1449 7 https://cdn.slidesharecdn.com/ss_thumbnails/pass24hopsummitpreview-klee-170723182549-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Objective SQL Server Performance /slideshow/objective-sql-server-performance/66380125 objectivesqlserverperformance-160924213948
“It’s slow! FIX IT!” is not a fun way to walk into the office on a Monday morning. However, putting objective metrics to the subjectivity of ‘slow’ is as much a science as it is art. Performance engineering takes effort well before an issue arises. Collecting the right metrics, trending and comparing against an established baseline, and identifying bottlenecks are all part of the performance process. This interactive session will help the DBA fine-tune their performance tuning approach so that the foundation for long-term proactive performance review is in place. The DBA can then shift the job responsibilities from a reactive response to a more predictive and proactive role.]]>
“It’s slow! FIX IT!” is not a fun way to walk into the office on a Monday morning. However, putting objective metrics to the subjectivity of ‘slow’ is as much a science as it is art. Performance engineering takes effort well before an issue arises. Collecting the right metrics, trending and comparing against an established baseline, and identifying bottlenecks are all part of the performance process. This interactive session will help the DBA fine-tune their performance tuning approach so that the foundation for long-term proactive performance review is in place. The DBA can then shift the job responsibilities from a reactive response to a more predictive and proactive role.]]> Sat, 24 Sep 2016 21:39:47 GMT /slideshow/objective-sql-server-performance/66380125 DavidKlee2@slideshare.net(DavidKlee2) Objective SQL Server Performance DavidKlee2 “It’s slow! FIX IT!” is not a fun way to walk into the office on a Monday morning. However, putting objective metrics to the subjectivity of ‘slow’ is as much a science as it is art. Performance engineering takes effort well before an issue arises. Collecting the right metrics, trending and comparing against an established baseline, and identifying bottlenecks are all part of the performance process. This interactive session will help the DBA fine-tune their performance tuning approach so that the foundation for long-term proactive performance review is in place. The DBA can then shift the job responsibilities from a reactive response to a more predictive and proactive role. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/objectivesqlserverperformance-160924213948-thumbnail.jpg?width=120&height=120&fit=bounds" /><br> “It’s slow! FIX IT!” is not a fun way to walk into the office on a Monday morning. However, putting objective metrics to the subjectivity of ‘slow’ is as much a science as it is art. Performance engineering takes effort well before an issue arises. Collecting the right metrics, trending and comparing against an established baseline, and identifying bottlenecks are all part of the performance process. This interactive session will help the DBA fine-tune their performance tuning approach so that the foundation for long-term proactive performance review is in place. The DBA can then shift the job responsibilities from a reactive response to a more predictive and proactive role.

Objective SQL Server Performance from David Klee

]]> 216 2 https://cdn.slidesharecdn.com/ss_thumbnails/objectivesqlserverperformance-160924213948-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Virtual SQL Servers. Actual Performance. /slideshow/virtual-sql-servers-actual-performance/61920000 virtualactual-60m-160511192739
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.]]>
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.]]> Wed, 11 May 2016 19:27:38 GMT /slideshow/virtual-sql-servers-actual-performance/61920000 DavidKlee2@slideshare.net(DavidKlee2) Virtual SQL Servers. Actual Performance. DavidKlee2 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. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/virtualactual-60m-160511192739-thumbnail.jpg?width=120&height=120&fit=bounds" /><br> 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.

Virtual SQL Servers. Actual Performance. from David Klee

]]> 198 5 https://cdn.slidesharecdn.com/ss_thumbnails/virtualactual-60m-160511192739-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 https://cdn.slidesharecdn.com/profile-photo-DavidKlee2-48x48.jpg?cb=1523638100 www.heraflux.com https://cdn.slidesharecdn.com/ss_thumbnails/pass24hopsummitpreview-klee-170723182549-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/24-hours-of-pass-summit-preview-session-virtual-sql-server-cpus/78171035 24 Hours of PASS, Summ... https://cdn.slidesharecdn.com/ss_thumbnails/objectivesqlserverperformance-160924213948-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/objective-sql-server-performance/66380125 Objective SQL Server P... https://cdn.slidesharecdn.com/ss_thumbnails/virtualactual-60m-160511192739-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/virtual-sql-servers-actual-performance/61920000 Virtual SQL Servers. A...