WORKSHOPS

"I hear and I forget, I see and I remember, I do and I understand." (Confucius)

Our Workshops are Hands-on Training Sessions for two Reasons:

1. Each performance tuning technique explained can be simultaneously viewed on the server. What is taught is 100% applicable to the 'real world of SQL Server'.

2. The attendee gets the opportunity to apply what s/he has learned firsthand and hence gains greater confidence in using the same techniques back at work. Questions that may arise while working with a newly learned technique can be answered instantly.

Upcoming Workshops

To gain an impression on how our workshops are conducted, watch our free Hands-on Online Videos!

Note that the Workshops can be also arranged at your company's premises. If there are 3 or more SQL Server DBAs, developers or architects who require training, this option might be more convenient and less expensive for you. If you consider organizing an Onsite Workshop, contact us and kindly inform about the following: 1. How many people need to be trained 2. Your location 3. The SQL Server topics you would like us to cover (if different from our standard agendas).

Advanced SQL Server Performance Monitoring & Tuning

 

SQL Server Administration & Tuning for SAP

        TARGET GROUP

Database Administrators, Developers and Database Architects.      

Database Administrators, Basis Consultants and  SAP Integration Partners.

        GOAL OF THE WORKSHOP

The course addresses CPU, Memory, Disk, Query, Locking, In-Memory OLTP and Clustered ColumnStore Indexes monitoring and tuning techniques for optimal performance and to maximize the utilization of existing hardware. Best practice guidelines for configuration and maintenance are covered. After attending this workshop, attendees should be able to identify and tune performance issues.

       
 

To provide the technical knowledge to install, secure, configure, administer, maintain, monitor, tune and troubleshoot SQL Server used in SAP installations. To provide insight for Database High Availability planning and guidelines on using SQL Server 2014, 2012 and 2008 features. This hands-on workshop uses both SQL Server and SAP tools.

           PREREQUISITE

Basic SQL Server: Knowledge about Cluster, Heap and Non-cluster indexes, Database Engine Tuning Advisor and SQL Profiler.  

Basic knowledge of SAP.

         AGENDA

SQL Server Workshop Agenda

 

SAP/ SQL Workshop Agenda

Workshop Feedback by Previous Participants

 Subscribe to our Newsletter