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 downtime is not possible Even …
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 3 of the SQLskills training …
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 perfmon.exe I/O Backup activity is …
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 Default Trace Logs everytime when …
Nothing to say about today, Jonathan did really a great job describing Extended Events and Baselining/Benchmarking to us, and his boss – Paul – did a quick really great overview of Resource Governor. I’ve done a lot in these areas in the past, so that was a more easy one to me than yesterday J. …
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
