Getting SAN Admins Good Metrics to Set Up LUNs, Which Maximize SQL Server Performance
Houston (Vocus) November 3, 2010
Brett Hawton, Product Architect for SQL Server Solutions at Idera.
PASS Summit 2010
The Washington State Trade and Convention Center in Seattle.
Brett Hawton is the architect for SQL Server products at Idera. Brett has worked with the internals of SQL Server since SQL Server 6.0 and has designed and developed methods, techniques and products that help improve performance on hundreds of thousands of SQL Servers worldwide.
“Getting SAN Admins Good Metrics to Set Up LUNs, Which Maximize SQL Server Performance” 3:00 PM on Wednesday, November 10th, 2010.
There is an ocean of divide between the metrics SAN administrators require in order to set up LUNs on their SANs and the information DBAs typically have at their disposal. Many of the performance books and online articles try to equate OS counters directly to IO/sec; however, as Brett will demonstrate, certain statistical and mathematical formulae need to be used in order to get this right. This session describes exactly what to gather. Then using sampling statistical techniques as well as Fourier transform equations in Excel, Brett will show how to convert the gathered metrics into average and peak loads understandable in SAN parlance, which will tell the SAN administrator exactly what to plan for. Finally, Brett will demonstrate how to measure seemingly under-performing SANs in order to derive the precise amount by which they are underperforming.
Idera provides tools for Microsoft SQL Server, SharePoint and PowerShell management and administration. Our products provide solutions for performance monitoring, backup and recovery, security and auditing and PowerShell scripting. Headquartered in Houston, Texas, Idera is a Microsoft Gold Partner and has over 7,000 customers worldwide. To learn more, please contact Idera at +1-713.523.4433 or visit http://www.idera.com.
Idera is a division of BBS Technologies, Inc. Idera, SharePoint productivity toolbox, SharePoint page profiler and PowerShell Plus are trademarks or registered trademarks of BBS Technologies, Inc. or its subsidiaries in the United States and other jurisdictions. All other company and product names may be trademarks or registered trademarks of their respective companies.