Cena tečaja * 149,00 €
Obseg v dneh 1
Število ur 9

Razpisani termini

Prijava na tečaj

Vam zgoraj razpisani termini ne ustrezajo? Prijavite se na seznam interesentov in obvestili vas bomo o naslednjem terminu.
Prijavite se na seznam interesentov

* Cena je brez DDV

Pre-Conference: Optimizing Performance Through Storage and Index Tuning SQL2017-2

Storage can be one of the biggest bottlenecks when it comes to database performance. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, you will learn to look at storage from the perspective of both the database and storage layers. You will learn about LUNs, HBAs, the fabric, as well as the storage configuration. After going over the components you will dig into some advanced storage configurations. This includes RAID groups, multi-pathing software, and proper redundant storage network design.

Once we've tuned the storage array, you will learn to tune SQL Server in order to minimize the IO workload. You will learn how to review the workload of the server using the native tools as well as some additional tools so that you can understand what part of your databases need to be tuned.

You will gain understanding of the Columnstore index feature and how it can be used to improve performance within your data warehouse platforms, including how to use it in a data warehouse which requires trickle loads.

You will learn about scale out options which are available with Microsoft SQL Server both within the database, by using table partitioning to spread the workload to multiple disks, as well as AlwaysOn Availability Groups and how they can be used to scale a database out across multiple servers.

Denny Cherry

Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2012, including the MCM and MVP.

Blog: http://workingondata.wordpress.com
Twitter: @mrdenny

  • Early-bird registration until 31st of October: 119,00 €/person
  • Regular registration after 31st of October: 149,00 €/person

    Duration: 9:00 - 17:00

Prijava na tečaj