Thomas LaRock

Thomas LaRock

www.thomaslarock.com

Thomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as Head Geek at SolarWinds, Thomas also holds a MS degree in Mathematics from Washington State University. Thomas serves on the Board of Directors for the Professional Association for SQL Server (PASS), is a SQL Server MCM, and a SQL Server MVP. Thomas blogs at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).

More from Thomas LaRock

Why DPA Uses SQL Server Trace Flag 2861 and Zero Cost Plans

About zero cost plans in SQL Server OK, first thing first, what is a “zero cost plan” in SQL Server?  I did some digging around and found the following links, which I would encourage you to read before continuing with this post: http://msdn.microsoft.com/en-us/library/ms181055.aspx http://support.microsoft.com/kb/325607 If you’ve done this background reading, you should now be aware […]

Read More

Collecting and Alerting on Deadlocks for SQL Server

SolarWinds DPA can collect a count of the number of deadlocks to be displayed as a resource graph. For Ignite versions prior to 8.2, you can update two files in order to start collecting the number of deadlocks. Enabling DPA to Collect Deadlock Information The code below takes advantage of the system_health extended event session […]

Read More