SQL Server Administration and Tuning for SAP Customers Hands-on Workshop
3 Day Level 300 SQL Server Administration &
Tuning for SAP Customers Hands-on Workshop.
Database Administrators, Basis Consultants and SAP
Goal of the Workshop:
To provide technical knowledge to Install, Secure,
Configure, Administer, Maintain, Monitor, Tune and Troubleshoot
SQL Server used in SAP installations. Provides insight for
Database High Availability planning and provides guidelines on
using new SQL Serve 2012 and SQL Server 2008 features. This
hands-on workshop uses both SQL Server and SAP tools.
Basic knowledge of SAP.
R Meyyappan with more than 15 years of
SQL Server expertise including working in the past as a Program
Manager for SAP/SQL Server integration in the SQL Server
Development Team at Microsoft Corporation. He is specialized in
SQL Server Performance Monitoring, Tuning & Troubleshooting and
SQL Server Administration and Tuning for SAP installations.
Charges: 10,000 Euro for 3 day on-site delivery (including T&E
excluding VAT) for up to 10 participants.
For this onsite workshop, customer has to provide
classroom, hardware, software and system setup.
Maximum Attendees per workshop:
AGENDA (Agenda can be customized based on
customer requirements and can be extended to 5 days with
additional content and more hands-on when necessary):
SAP / SQL Server Architecture: SID & Tempdb Database, Data & Log Files, Auto Growth,
Proportional Fill, Multiple Instances, Tables & Indexes,
Statistics, Fragmentation. SAP Sessions & Connections, Schema,
Statement Execution in SQL Server. SQL Server Configuration
Parameters, Auto Create, Update, Asynchronous Statistics.
File Reorganization, Index Reorganization, Statistics
Update, Database Consistency Check, ErrorLog, Service Packs,
Cumulative Updates, SQL Server Versions, Moving Data/Log File,
Expanding Data/Log Files, System Copy, Shrinking Data/Log Files.
Disaster Recovery & High Availability Planning: Master, Msdb, SID , Backup & Restore, Point in Time,
Log Mark, Backup Compression, DBA Planning Calendar, Log
Shipping, Database Mirroring, Database Snapshots.
Performance Monitoring and Tuning: Requests & DBA Cockpit Database Processes, Wait Stats.
CPU, Disk & Memory. Query Tuning and Locking. Bitmap filtering,
Latency, Throughput, Read Ahead, Partition Alignment, Instant
File Initialization, SQLIO, Maximum & Minimum Memory, Data Cache
Hit Ratio, Hash & Sort Warning, Lock Pages in Memory. DBA
Cockpit, SQL Statements, ST05, SQL Profiler, Analyzing Execution
Plan, Plan Caching, Identifying Non Optimal Plans, Query
Tuning, Missing Indexes, Index & Column Statistics, Hints, Plan
Guides, Extended Events. Locking, Blocking, Escalation,
Database Compression: Concepts, Tools, Compression scenarios for SAP
Customers upgrading from SQL Server 2005 and 2008 to SQL Server 2012
New features for SAP Customers in SQL Server 2012 & SQL Server
2008: Transparent Data Encryption, SQL Server Audit, Change
Data Capture, Change Tracking, Resource Governor, Policy-Based
Management, Data Collection, SQL Server Utilit.
Feedback from NNIT A/S, Denmark
on our November 08-12, 2010 onsite workshop:
Sune: Ramesh did a very good job - I'm
certain that everyone that attended the course found it
beneficial. It was also very relevant, to see the live
examples and doing the hands-on in both SAP and 'SQL-Server
Peter: Have recommended this workshop to management
for the rest of the department. Keep it Up …
Tine: Very useful to get learning’s from
both the SAP side and MSSQL side. A lot of good tools were
Anders: I think the course was
very good and you are a good instructor. You got some very
illustrative examples of the different things you were teaching.
Torben : Very good workshop in the
possibilities of SAP running on mssql. Good focus on
sqlfunctions and the compare to SAP transactions.
Thomas: Over all I was very happy about the
workshop as I got much more out of it as I expected.
Ramesh's consulting customers include Austria:
Allgemeines Krankenhaus Linz, BMD Systemhaus,
Bundesrechenzentrum, bwin, C07 IT Operations, CMC Markets,
derStandard, ERGO Insurance Service, Fabasoft Austria,
Greentube, IAEA (UN), Interwetten, INTERSPORT, Kapsch, Linz
AG, Mayr-Melnhof Karton, NÖM, ÖBB, OMV, Österreichische
Post, RACON West Software, Raiffeisen Bankengruppe,
Raiffeisen Informatik, S.Spitz, Salzburg AG, Siemens, TIWAG,
UC4, Vinzenz Gruppe, Wiener Zeitung, Wirtschaftskammer
Österreich; Bulgaria: MobilTel;
Czech Republic: Česká pojišťovna, ČSOB Bank, GTS
Novera, Telefónica O2, Vodafone; Denmark:
Danfoss, Egmont, NNIT; Finland: Cap Gemini,
Kemira, Pohjola; Germany: JAM Software, SAP
AG; Netherlands: De Nederlandsche Bank;
Norway: Acta, Aker Solutions, Det Norske
Veritas(DNV), Komplett; Russia: Mediatel;
Serbia: Tarkett; Slovakia:
Adastra Corporation, VÚB Banka; Slovenia:
Bankart, Iskratel, KDD, Krka, Mobitel, Pošta Slovenije,
Sava, SRC.SI; South Africa: De Beers,
Kumba, Sasol; Spain: CIE Automotive, Gas
Natural, ITP; Sweden: Sony Ericsson;
Switzerland: F. Hoffmann-La Roche, Philip
Morris International; UAE: Dubai Customs.
For past consulting engagement feedbacks click