|
Free Webcast Download and London City, February 27-March 01, 2013 Workshop
Registration Information Download Truly Level 400 SQL Server Performance Monitoring and Tuning Webcast 1 Part
1:
SQLWebcast1Part1of3.wmv(29.1MB), Part
2:
SQLWebcast1Part2of3.wmv(47.5MB) & Part
3:
SQLWebcast1Part3of3.wmv(37.4MB)
- FREE Download.
Webcast 1 released on November 21, 2009 (Box.net download
counters as of February 14, 2012: 36,079
downloads, sum of all 3 Parts).
Download Truly Level 400 SQL Server Performance Monitoring and Tuning Webcast 2 Part
1:
SQLWebcast2Part1of3.wmv(35.1MB), Part
2:
SQLWebcast2Part2of3.wmv(34.9MB) & Part
3:
SQLWebcast2Part3of3.wmv(30.6MB)
- FREE Download.
Webcast 2 released on January 20, 2010 (Box.net download
counters as of February 14, 2012: 23,953
downloads, sum of all 3 Parts).
Download Truly Level 400 SQL Server Performance Monitoring and Tuning
Webcast 3 Part
1:
SQLWebcast3Part1of3.wmv(103MB), Part
2:
SQLWebcast3Part2of3.wmv(116MB) & Part
3:
SQLWebcast3Part3of3.wmv(69.1MB)
- FREE Download.
Webcast 3 released on February 10, 2010 (Box.net download
counters as of February 14, 2012: 39,568
downloads, sum of all 3 Parts). Firewall might block downloads,
if you have issues downloading let us know, we will provide you with alternate download links.
Register for the upcoming 3 Day Level 400 Microsoft SQL Server 2012 and 2008 Performance Monitoring & Tuning Hands-on Workshop in Helsinki, Finland
during
February 27-March 01, 2013, click
here to register.
These are hands-on workshops with a maximum of 12 participants
and not lecture. For consulting engagements click
here.
Below is a short intro webcast,
different webcast but same topic, if you are not still convinced
to download the webcast, you can view the introduction to decide
for yourself if it is useful for you / worth downloading. More
info on Webcasts agenda available
here.
SQLBits organizers presented
Best Speaker Award
to Davide Mauri and R Meyyappan for their respective
sessions at SQLBits based on attendee's voting. R
Meyyappan presented level 400 session 'Performance Optimization with SQL
Server 2008' at SQLBits (www.sqlbits.com,
the largest SQL Server conference in Europe based on number of
participants). For R Meyyappan's
SQLBits V session recording click
here.
To download a copy of this video, right click and choose "Save
As" with this link:
http://go.microsoft.com/?linkid=9712350.
For additional recorded session by R
Meryyappan use this
link:
http://www.sqlbits.com/Speakers/R_Meyyappan.
Dharmesh
from
Bank of England,
United Kingdom,
www.bankofengland.co.uk:
Rating: In a scale of 1 to 5 please rate
each item below (1=Poor & 5=Excellent)
|
Overall I was satisfied with the
workshop |
5 |
|
Instructor maintained the focus of
the course |
5 |
|
Mix of theory and practice was
appropriate |
5 |
|
Instructor answered the questions
asked |
5 |
|
The training facility met the
requirement |
4 |
|
How confident are you with SQL Server performance tuning |
4 |
Additional comments:
The course was excellent. I have recommended it to my
colleagues.
To read some of our articles I wrote
click
here.
To receive example SQL
Scripts used in webcasts:
Sign up for Email Updates.
Please take a few minutes and pass on the webcast link to your friends and local
user community. Feedback from a Microsoft Employee: Your
webcast rocked. Your free webcast was very good and informative.
Some of the workshop feedback from United Kingdom
participants:
Andrew
from
UBS,
United Kingdom,
www.ubs.com:
Rating: In a scale of 1 to 5 please rate
each item below (1=Poor & 5=Excellent)
|
Overall I was satisfied with the
workshop |
5 |
|
Instructor maintained the focus of
the course |
5 |
|
Mix of theory and practice was
appropriate |
5 |
|
Instructor answered the questions
asked |
5 |
|
The training facility met the
requirement |
5 |
|
How confident are you with SQL Server performance tuning |
5 |
Additional comments:
The course was expertly delivered and backed up with
practical examples. At the end of the course I felt my
knowledge of SQL Server had been greatly enhanced and was
eager to share with my colleagues. I felt there was one
prerequisite missing from the course description, an open
mind since the course changed some of my core product
beliefs.
Simon from
Henderson Global Investors,
United Kingdom,
www.henderson.com:
Rating: In a scale of 1 to 5 please rate
each item below (1=Poor & 5=Excellent)
|
Overall I was satisfied with the
workshop |
5 |
|
Instructor maintained the focus of
the course |
5 |
|
Mix of theory and practice was
appropriate |
5 |
|
Instructor answered the questions
asked |
5 |
|
The training facility met the
requirement |
5 |
|
How confident are you with SQL Server performance tuning |
5 |
Additional comments:
An excellent course and instructor. Ramesh clearly knows his
subject matter with in-depth knowledge of, and insights
into, the inner workings of the query optimizer.
Tim from
T|SYS|
European Data Centre,
United Kingdom,
www.tsys.com:
Rating: In a scale of 1 to 5 please rate
each item below (1=Poor & 5=Excellent)
|
Overall I was satisfied with the
workshop |
5 |
|
Instructor maintained the focus of
the course |
5 |
|
Mix of theory and practice was
appropriate |
5 |
|
Instructor answered the questions
asked |
5 |
|
The training facility met the
requirement |
5 |
|
How confident are you with SQL Server performance tuning |
4 |
Additional comments:
Ramesh’s knowledge, expertise and ability to convey this via
practical examples was excellent. Course was excellent and
exceeded my expectations.
John from Chaucer
Syndicates LTD ,
United Kingdom,
www.chaucerplc.com:
Rating: In a scale of 1 to 5 please rate
each item below (1=Poor & 5=Excellent)
|
Overall I was satisfied with the
workshop |
4 |
|
Instructor maintained the focus of
the course |
5 |
|
Mix of theory and practice was
appropriate |
5 |
|
Instructor answered the questions
asked |
5 |
|
The training facility met the
requirement |
5 |
|
How confident are you with SQL Server performance tuning |
4 |
Additional comments:
Ramesh is one of the most knowledgeable people on the
subject, and attending his workshop is essential for Level
400 understanding of SQL Server.
Steven
from Aggreko PLC, United Kingdom,
www.aggreko.com:
Rating: In a scale of 1 to 5 please rate
each item below (1=Poor & 5=Excellent)
|
Overall I was satisfied with the
workshop |
4 |
|
Instructor maintained the focus of
the course |
4 |
|
Mix of theory and practice was
appropriate |
4 |
|
Instructor answered the questions
asked |
5 |
|
The training facility met the
requirement |
4 |
|
How confident are you with SQL Server performance tuning |
3 |
Additional comments:
I enjoyed the course and thought the content was very
interesting – there were some great ideas for quick wins and
some topics that I will have to investigate further.
There is no doubt that Ramesh knows his stuff and the
concepts were communicated well. The course is fast paced
and covers a lot of ground in 3 days.
For me there is one
thing that would have improved the course vastly and that
would have been if the scripts that were used had been
provided up front. This would have allowed me to follow the
content and focus 100% on what Ramesh was saying rather than
having to split my time between listening and taking notes.
In a class where there is so much in depth information being
discussed it is a little frustrating to miss out on some of
the discussion due to taking notes.
Peter from
Sanctuary Housing Association,
United Kingdom,
www.sanctuary-housing.co.uk:
Rating: In a scale of 1 to 5 please rate
each item below (1=Poor & 5=Excellent)
|
Overall I was satisfied with the
workshop |
5 |
|
Instructor maintained the focus of
the course |
5 |
|
Mix of theory and practice was
appropriate |
5 |
|
Instructor answered the questions
asked |
5 |
|
The training facility met the
requirement |
4 |
|
How confident are you with SQL Server performance tuning |
5 |
Additional comments:
I have attended many Microsoft courses over the years; each
time I have left feeling that the technical content wasn't
technical enough. With the course I have left feeling that I
have an in-depth understanding of SQL Server and empowered
to make improvements based on the excellent technical
content delivered through the course.
Kokho from
Altis
Partners (London) Ltd, United Kingdom ,
www.altispartners.com:
Rating: In a scale of 1 to 5 please rate
each item below (1=Poor & 5=Excellent)
|
Overall I was satisfied with the
workshop |
4 |
|
Instructor maintained the focus of
the course |
5 |
|
Mix of theory and practice was
appropriate |
5 |
|
Instructor answered the questions
asked |
5 |
|
The training facility met the
requirement |
4 |
|
How confident are you with SQL Server performance tuning |
4 |
Additional comments:
It does exactly ‘what it says on the tin’ with real world
examples and in depth knowledge and techniques on how to
trouble shoot, performance tuning and optimization of
queries and server. Perhaps we should be advised to watch
the sqlworkshop video before attending the course and some
brief notes eg the summary at the end of the session will be
useful. One of the best courses, if not probably the best
course, I had attended.
Simon from
Det Norske Veritas
AS, United Kingdom,
www.dnv.com:
Rating: In a scale of 1 to 5 please rate
each item below (1=Poor & 5=Excellent)
|
Overall I was satisfied with the
workshop |
5 |
|
Instructor maintained the focus of
the course |
5 |
|
Mix of theory and practice was
appropriate |
5 |
|
Instructor answered the questions
asked |
5 |
|
The training facility met the
requirement |
5 |
|
How confident are you with SQL Server performance tuning |
4 |
Additional comments:
Ramesh excelled. His knowledge, experience and competence is
second to none. The course was very well tutored and I would
recommend it to any SQL DBA.
Webcast Agenda:
Webcast 1: Explains Memory allocation
issues with sort. Demonstrates ways to identify sort spills
to tempdb. Provides query rewrite procedure to avoid sort
spills to tempdb. Demonstrates cases where 1 tempdb date
file per core might not be ideal for all implementations.
Webcast 2: Explains high CXPACKET waits are
NOT a direct result of delays associated with inefficiencies
of parallel processing. Provides example to scale queries
over many CPU cores without reducing MAXDOP settings.
Webcast 3: Recommends not using stored
procedure or other plan caching mechanism like using
sp_executesql and Prepared Statement using ADO.NET or OLEDB
based executions for memory allocating queries. Common
memory allocating queries are that perform Sort and do Hash
Match operations like Hash Join or Hash Aggregation or Hash
Union.
With examples provides ways to identify queries performing
Hash match operations that spill to tempdb. Using SQL
Profiler: Hash Warnings (Hash Recursion and Hash Bailout).
Using sys.dm_exec_query_memory_grants: Granted Memory, Used
Memory and Maximum Used memory. Explains how SLEEP_TASK wait
type is associated with Hash Warnings.
Explains with examples how sp_recompile can block and bring
an application to a standstill and recommends using DBCC
FREEPROCCACHE (plan_handle) instead.
Explains with examples how stored procedure or other plan
caching mechanism affects queries that sort (perform order
by). Explains how IO_COMPLETION wait type is associated with
Sort Warnings.
Demonstrates why rollbacks and database restore could wait
on IO_COMPLETION wait type and if needed how this wait can
be reduced.
Explains how parallel query performance is significantly
affected by a CPU intensive query executing on one of the
CPU cores. Explains the reason for the performance issue and
how to identify the issue with SLEEP_TASK wait type. With
example explains the reason for the observed query execution
time when the child thread executes on the CPU core where
the CPU intensive query executes and also when the
coordinator executes on the CPU core where the CPU intensive
query executes. Recommends ways to avoid this parallel sort
query performance issue and also demonstrates that only
certain queries will be affected by this and not all
parallel queries.
Explains sys.dm_os_waits_stats.signal_wait_time_ms does not
indicate system wide CPU pressure, just at a CPU core level.
Explains the prefetch mechanism and how it can affect query
performance. Provides ways to force prefecth. Demonstrates
cases where Avg. Disk Sec / read, the disk latency,
PAGEIOLATCH_SH, Avg. disk queue length is very high and the
query executes fast.
Explains why Plan Guides (Plan Freezing!) cannot help with
prefetch or in few other cases.
The Goal of these webcasts is to help reduce
Total Cost of Ownership (TCO), by efficiently
utilizing existing investment.
Hope you enjoy these webcasts. We are always
looking for ways to improve these webcasts, let me know if you
have some suggestions.
You can also read these articles I wrote:
Workspace Memory / Query Memory Tuning –
RESOURCE_SEMAPHORE / IO_COMPLETION / SLEEP_TASK Waits
Prefetch – Querying at the speed of SAN
Plan Caching and Query Memory - When not
to use stored procedure or other plan caching mechanism like
sp_executesql or prepared statement
Parallel Sort and Merge Join – Watch out
for unpredictability in performance
Parallel Query Memory - MAXDOP and query
memory distribution in spotlight
Flying with Plan Freezing – Mostly you
experience thrust or stay afloat, but rarely this add-on can be
a drag
Finding optimal number
of CPUs for a given CPU intensive workload
When to place tempdb
in RAM to improve ORDER BY performance
Join the action, become an expert:
Sign up for Email Updates.
Please take a few minutes and pass on the webcast link to your friends and local
user community. Feedback from a Microsoft Employee: Your
webcast rocked. Your free webcast was very good and informative.
R Meyyappan & Team @ SQLWorkshops.com
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
here.
|
