Alex Rosa & SQL Server & Microsoft Azure

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

Installing SQL Server 2008 + Windows Server 2012 = Cluster Service Verification FAILED

Last week I was working with Marcelo Fernandes (SQL Server MVP) and he asked for help to try to find a solution for the issue below. You can get more details and screen shoots visiting Marcelo’s blog post.   Problem During SQL Server 2008 or 2008 R2 over a Windows Server 2012 the Cluster Service… Read more

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