Performance Tuning of T-SQL Queries * Tento kurz je určen pro vývojáře a administrátory, kteří potřebují psát své T-SQL dotazy tak, aby byly provedeny co nejrychleji, případně se jen chtějí naučit optimalizační techniky dotazů na straně vývoje aplikací. Účastníci se naučí úspěšně monitorovat T-SQL dotazy a identifikovat náročné operace, pochopit exekuční plány, a správně používat indexy. Získají širší znalosti o tom, co se děje na pozadí, jako například analyzovat, zda je pomalost dotazu způsobe ...

• 17.02.2025 - 18.02.2025 Brno



• 12.12.2024 - 13.12.2024 Praha



• 12.12.2024 - 13.12.2024 Brno



• 21.01.2025 - 22.01.2025 Praha

In the Oracle Database 12c: Performance Management and Tuning course, lea> about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service. Audience Data Warehouse Administrator ...

This Oracle WebLogic Server 12c: Performance Tuning Workshop teaches you how to monitor the effects of a running Oracle WebLogic Server application on the overall system. Expert Oracle University instructors will teach you through interactive instruction, walking you through new concepts, while diving into real-world applications. Audience Administrator Java EE Developers Project Manager SOA Architect Support Engineer Syste ...

This Oracle WebLogic Server 12c: Performance Tuning Workshop teaches you how to monitor the effects of a running Oracle WebLogic Server application on the overall system. Expert Oracle University instructors will teach you through interactive instruction, walking you through new concepts, while diving into real-world applications. Audience Administrator Java EE Developers Project Manager SOA Architect Support Engineer Syste ...

This Oracle WebLogic Server 12c: Performance Tuning Workshop teaches you how to monitor the effects of a running Oracle WebLogic Server application on the overall system. Expert Oracle University instructors will teach you through interactive instruction, walking you through new concepts, while diving into real-world applications. Audience Administrator Java EE Developers Project Manager SOA Architect Support Engineer Syste ...

Performance tuning and capacity planning for Red Hat Enterprise Linux Red Hat Performance Tuning: Linux in Physical, Virtual, and Cloud (RH422) teaches senior Linux® system administrators the methodology of performance tuning. This course discusses system architecture with an emphasis on understanding its implications on system performance, performance adjustments, open source benchmarking utilities, networking performance, and tuning configurations for specific server use cases and workloads. ...

The Red Hat Enterprise Performance Tuning with exam (RH443) bundle is a combination of the following: Red Hat Performance Tuning: Linux in Physical, Virtual, and Cloud (RH442) Red Hat Certified Specialist in Performance Tuning Exam (EX442) ...

Study points for the exam To help you prepare, the exam objectives highlight the task areas you can expect to see covered in the exam. Red Hat reserves the right to add, modify, and remove exam objectives. Such changes will be made public in advance. Candidates should be able to perform the tasks listed below: Use utilities such as vmstat, iostat, mpstat, sar, gnome-system-monitor, top, powertop and others to analyze and report system and application behavior Configure systems to provide performance metrics using utilities such as Performance Co-Pilot (PCP) Use the Pluggable Authentication Modules (PAM) mechanism to implement restrictions on critical system resources Use - proc - sys, sysctl and - sys to examine and modify and set kernel run-time parameters Use utilities such as dmesg, dmidecode, x86info, sosreport etc. to profile system hardware configurations Analyze system and application behavior using tools such as ps, strace, top and Valgrind C * Experienced Linux system administrators responsible for maximizing resource utilization through performance tuning An RHCE interested in earning Red Hat Certified Architect (RHCA) Study points for the exam To help you prepare, the exam objectives highlight the task areas you can expect to see covered in the exam. Red Hat reserves the right to add, modify, and remove exam objectives. Such changes will be made public in advance. Candidates should be able to perform the tasks listed below: Use utilities such as vmstat, iostat, mpstat, sar, gnome-system-monitor, top, powertop and others to analyze and report system and application behavior Configure systems to provide performance metrics using utilities such as Performance Co-Pilot (PCP) Use the Pluggable Authentication Modules (PAM) mechanism to implement restrictions on critical system resources Use - proc - sys, sysctl and - sys to examine and modify and set kernel run-time parameters Use utilities such as dmesg, dmidecode, x86info, sosreport etc. to profile system hardware configurations Analyze system and application behavior using tools such as ps, strace, top and Valgrind Configure systems to run SystemTap scripts Alter process priorities of both new and existing processes Configure systems to support alternate page sizes for applications that use large amounts of memory Given multiple versions of applications that perform the same or similar tasks, choose which version of the application to run on a system based on its observed performance characteristics Configure disk subsystems for optimal performance using mechanisms such as swap partition placement, I - O scheduling algorithm selection, file system layout and others Configure kernel behavior by altering module parameters Calculate network buffer sizes based on known quantities such as bandwidth and round-trip time and set system buffer sizes based on those calculations Select and configure tuned profiles Manage system resource usage using control groups As with all Red Hat performance-based exams, configurations must persist after reboot without intervention. Scores and reporting Official scores for exams come exclusively from Red Hat Certification Central. Red Hat does not authorize examiners or training partners to report results to candidates directly. Scores on the exam are usually reported within 3 U.S. business days. Exam results are reported as section scores. Red Hat does not report performance on individual items, nor will it provide additional information upon request. Prerequisites Red Hat recommends that candidates ea> Red Hat Certified System Administrator (RHCSA) or Red Hat Certified Engineer (RHCE) before attempting this exam but neither is required. Exam candidates should: Be a Red Hat Certified System Administrator (RHCSA) or have comparable work experience and skills (RHCE would be eve ...

Performance tuning and capacity planning for Red Hat Enterprise Linux Red Hat Performance Tuning: Linux in Physical, Virtual, and Cloud (RH422) teaches senior Linux® system administrators the methodology of performance tuning. This course discusses system architecture with an emphasis on understanding its implications on system performance, performance adjustments, open source benchmarking utilities, networking performance, and tuning configurations for specific server u ...

The Red Hat Enterprise Performance Tuning with exam (RH443) bundle is a combination of the following: Red Hat Enterprise Performance Tuning (RH442) course Red Hat Certified Specialist in Performance Tuning Exam (EX442) ...