Few days ago I have noticed that there will be a change (again) in certification paths for next generation of SQL servers. So I would like to recommend some thoughts about this from Microsoft Certified Masters (MCM) of Brent Ozar PLF Company.
Michal Tinthofer is the face of the Woodler company which (as he does), is fully committed to complete support of Microsoft SQL Server products to its customers. He often acts as a database architect, performance tuner, administrator, SQL Server monitoring developer (Woodler SMT) and, last but not least, a trainer of people who are developing their skills in this area. His current "Quest" is to help admins and developers to quickly and accurately identify issues related to their work and SQL Server runtime.
Recently, we found an interesting pattern during exploring one of our SMT graphs while doing a health check of a SQL server. The following graph shows us the Load Factor attribute. The value came from system table sys.dm_os_schedulers, which the SMT tool
Read moreWe are pleased to announce SMT 1.14.0, one of the most significant SMT releases to date. This version introduces Custom Pages, a completely redesigned chart engine, advanced query recompilation analysis, Plan Guide management, monitoring controls directly
Read moreWhy an Index Seek can still process millions of rows, how redundant indexes affect write-heavy workloads, and why doubling cloud CPU capacity cannot compensate for slower storage.
Read more
