Today Paul was speaking about Database Mirroring and Jonathan was talking about Failover Clustering – all in all a very intensive day J Module 6: Database Mirroring Split Brain is possible When you loose the witness, Database Mirroring goes into the asynchronous mode No automatic failover possible Witness should be also put in the same …
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 CPU Affinity Maks should not …
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 …
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.
