Most RecentMost ViewedMost LikesConnection Pooling for the SQL Server DBA First published on MSDN on Oct 08, 2013 There are a handful of questions that DBAs get in the wild that aren’t necessarily under the jurisdiction of the typical DBA. Monitoring SQL Server 2012 AlwaysOn Availability Groups Worker Thread Consumption First published on MSDN on Jul 15, 2013 In most cases, people utilize SQL Server features and capabilities in a common and typical usage pattern. Forced Parameterization Can Lead to Poor Performance First published on MSDN on Sep 03, 2013 Something that is a relatively common performance eye opener is when you have a large ad hoc workload, and you’re getting a huge gap in the lack of plan reuse. SQL Server Resource Governor Monitoring reports First published on MSDN on Jun 20, 2013 Resource Governor is an extremely cool and powerful feature that, when implemented, can manage the consumption of CPU and memory resources.
