ThomasStringer

7 Topics

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.
SQLPFE
Mar 21, 2024 Place Core Infrastructure and Security Blog
4.8KViews
1like
3Comments
Connection 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.
SQLPFE
Aug 27, 2021 Place Core Infrastructure and Security Blog
32KViews
3likes
1Comment
Inadvertently Promoting a Local Transaction to a Distributed Transaction
First published on MSDN on Nov 08, 2013 I recently dealt with a customer issue where they were troubleshooting MSDTC, and upon hearing the explanation of exactly what they were doing, I was a bit surprised that a distributed transaction was being used.
SQLPFE
Apr 28, 2020 Place Core Infrastructure and Security Blog
1.7KViews
0likes
0Comments
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.
SQLPFE
Apr 28, 2020 Place Core Infrastructure and Security Blog
8.2KViews
1like
0Comments
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.
SQLPFE
Apr 28, 2020 Place Core Infrastructure and Security Blog
5.1KViews
2likes
0Comments
Compare SQL Failover Cluster Instance SQL and OS Node Versions using PowerShell
First published on MSDN on Apr 29, 2013 It is a common check to see if all of the nodes in a cluster are equally patched.
SQLPFE
Apr 28, 2020 Place Core Infrastructure and Security Blog
2.2KViews
0likes
0Comments
Get the Active Power Plan of Multiple Servers with PowerShell
First published on MSDN on Apr 11, 2013 It is a widely known and discussed performance hit when you don’t have an optimal power plan set on your database servers.
SQLPFE
Apr 28, 2020 Place Core Infrastructure and Security Blog
3.9KViews
0likes
0Comments