Alex Rosa & SQL Server & Microsoft Azure

DECLARE dba AS human … SET dba = family + rdbms + friends + career + day_by_day + certifications + theory + real_life_experience

Max Worker Threads – Lower and Upper Bounds – The Correct Formula

Last week I was discussing with some friends, how SQL Server works with threads: Max Worker Threads – Lower and Upper bounds, Thread Pooling, SQLOS Scheduling, Parallelism, Resource Governor – CPU limits, Call Stack, Thread Starvation, Dedicated/System and User Threads…so, all the topics related to Threads. If you don’t know exactly how Process and Threads… Read more

PerfMon – Where are the process counters?

Almost everybody knows how to use Windows Performance Monitor, or just PerfMon, but there are some tips & tricks that many people don’t know and they should know, because can have a negative impact in your data collection and analysis. One of them is how to save the output file: Binary (BLG) or Comma Separated… Read more