SQL MCM Training – Day 9

Today Jonathan was talking the whole day about Consolidation and Virtualization. There were again a lot of new concepts, and new things to learn. Module 4: Consolidation Event Notifications for Monitoring Deadlocks, Locking/Blocking Scenarios Multiple Instances for TempDb bottleneck Soft-NUMA should be used to bound multiple instances to dedicated CPUs ...

Read more

SQL MCM Training – Day 8

Today Paul talked the whole day about HA DR Strategies and Backup/Restore operations. I’ve already known a lot about Backup/Restores, but Paul showed some cool things that were even new to me J. Here are my study notes for the 3 modules of today: Module 1: HA DR Strategies Zero ...

Read more

MCM Training – Day 6 & 7

My whole weekend was dedicated to MCM studying, and I’ve reviewed a lot of stuff that we have learned through the last week, and I was also able to read a lot of additional whitepapers and blog posts, that Paul, Kimberly, and Jonathan have referred to us. Today morning week ...

Read more

SQL MCM Training – Day 5

Today I’ve not taken too much notes, because the whole afternoon was about the Management Data Warehouse and Multi-Instance Management. But before that Paul and Jonathan have spoken a lot about troubleshooting with DMVs. Module 12: DMVs – Part 2 sys.dm_io_virtual_file_stats Spikes can’t be seen from this DMV, only through ...

Read more

SQL MCM Training – Day 4

Today Jonathan has presented on analyzing trace data, and Kimberly has spoken on troubleshooting Plan Cache Issues and Index Consolidation. It’s really awesome when you listen to Kimberly, because she is speaking so fast, and delivers such a great quality of content – really awesome!!! Module 10: Analyzing Trace Data ...

Read more

Copyright © 2018 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Data Protection · Go to Top