Thomas LaRock is a Head Geek at SolarWinds and a Microsoft® Certified Master, Microsoft Data Platform MVP, VMware® vExpert, and former Microsoft Certified Trainer. He has over 20 years’ experience in the IT industry as a programmer, developer, analyst, and database administrator. LaRock has spent much of his career focused on data and database administration, which led to his being chosen as a Technical Evangelist for Confio Software in 2010, where his research and experience helped to create the initial versions of the software now known as SolarWinds® Database Performance Analyzer. LaRock has served on the board of directors for the Professional Association for SQL Server® (PASS), and is an avid blogger, author, and technical reviewer for numerous books about SQL Server management. He now focuses on working with customers to help resolve problems and answer questions regarding database performance tuning and virtualization for SQL Server, Oracle®, MySQL®, SAP®, and DB2®. He’s made it his mission to give IT and data professionals longer weekends.


author:

Database

SQL Server Consolidation, Part 3


I wrote a couple of posts previously on SQL Server consolidation. The first post tried to give insight on some of the problems and associated motivating factors that most companies have for consolidation efforts. The second post was an attempt to cover some of the decision factors …


author:

Database

SQL Server Consolidation, Part 2


Consider for a moment that you have a deck attached to your house. It is one story above ground level and is growing weaker with each passing year. The former homeowner painted (!) the deck, making your options for upkeep quite limited. And what …


author:

Database

SQL Server Consolidation, Part 1


I am seeing more than a handful of articles these days regarding SQL Server virtualization and/or consolidation. Lots of companies are coming forward to provide you tools that will take the pain out of such efforts. They promise tools that will help manage your …


author:

Database

Performance Counters for Database Mirroring


We have customers using database mirroring, so I wanted to take some time to write a quick post regarding database mirroring and performance monitoring. Microsoft has published an article titled “Database Mirroring Best Practices and Performance Considerations.” In that article, they mention how the …


author:

Database

Performance Tuning and Time Invested


I never cared for the phrase “wasted time” when it comes to something like performance tuning. Sure, we all feel that way, especially when we spend hours on something only to find we were heading down the wrong rabbit hole from the start. Instead …



author:

Database

SQL Server CXPacket Wait Type


When are CXPACKET waits a problem? Note: This article, by Thomas LaRock, was posted 8/19/2013 and supercedes the previous version. This update has been made in response to comments made on the original article text. The SQL Server CXPACKET wait type is a result of parallel query execution …



author:

Database

SQL Server ASYNC Network IO Wait Type


THIS ARTICLE HAS BEEN RECENTLY UPDATED AND CONTAINS NEW, TECHNICAL INFORMATION Note: For SQL2000 this wait is called NETWORKIO. The ASYNC_NETWORK_IO wait indicates that one of two scenarios are happening. The first scenario is that the session (i.e., SPID) is waiting for the client …