As a DBA/developer, you probably face a scenario where you need to trace your SQL Server for various reasons. This blog digs directly into how to read the trace (*.trc) file after you capture the required data. This blog would not demonstrate how to capture a trace on SQL Server. It is assumed that readers … Continue reading Read your SQL trace files from SSMS using Transact-SQL
Category: SQL Performance
TempDB growing: Chronicles of a DBA
As a DBA, you would be faced with situations where databases would begin to grow exponentially causing issues like low disk space. One of the most common databases that is famous for growing is the almighty [TempDB]. TempDB is well known over the decades for being the major culprit for grow and filling up the … Continue reading TempDB growing: Chronicles of a DBA