Today I presented a fun session for the SQL PASS Performance Virtual Chapter’s “Summer Performance Palooza 2014” entitled “Infrastructure Tuning for SQL Server”.
Abstract: Mention SQL Server performance to any DBA, and the impulse is to dive headfirst into the database and queries. However, if the infrastructure underneath the data is your performance bottleneck, the time spent tuning at the database layer is usually in vain. Server hardware, operating system parameters, storage, interconnects, and networking will all be discussed in depth in terms that DBAs can relate to. Practical architecture guidelines and troubleshooting techniques will be presented so you can analyze your environments and see if your performance bottlenecks are where you think they are.
The slides for today’s session are available for you to download here, and the recording – as well as all of the other session recordings – will be available at performance.sqlpass.org within the next week. Thank you all for attending, and I look forward to the next time!