William Durkin is a DBA and SQL Server Solutions Architect for CloudDBA. He uses his decade of experience with SQL Server to help multinational corporations achieve their data management goals. Born in the UK and now based in Germany, William has worked as a Database Developer and DBA on projects ranging from single server installations, up to environments spanning 5 continents using a range of high availablity solutions. William is a regular speaker at conferences around the globe and is a chapter leader for a German PASS chapter.
How to Easily Tweak SQL Server to Improve Performance
- Stopnja 300
16. maj 2016 09:00
Default application settings are aimed at the average user. With SQL Server being installed hundreds of thousands, if not millions of times across the globe, this average is inevitably far from your specific use case. With that in mind, we must take a look at what settings are available inside SQL Server that you can change to allow SQL Server to perform better. We will discuss settings that can provide immediate improvements at the instance, database or object level. You will leave this session with an understanding of what settings are available to you and how to approach making changes to your environment that can cause great performance improvements, without having to change your applications.