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. …
Today’s day was Jonathan Kehayias days, and it was pretty impressive. Jonathan covered the following 3 modules, and he can speak really continuously and forever J IO – Storage Area Networks IO – Installation and Testing SQLOS I’ve already read few whitepapers in the past about SANs and also watched the MCM Readiness videos about …
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.
