I was asked a very interesting question by their DBA about log files. The question was – Is there ever need of multiple log files in SQL Server?
SQL SERVER – Msg 1842 – The File Size, Max Size Cannot be Greater Than 2147483647 in Units of a Page Size
Could not allocate space for an object because the ‘PRIMARY’ filegroup is full and The File Size, Max Size Cannot be Greater Than 2147483647
SQL SERVER – Top Reasons for Slow Performance
Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.
SQL SERVER – Find the Growth Size for All files in All Databases – Part 2
A few years ago, I had written a blog post Find the Growth Size for All files in All Databases. Today, we will post a small correction to it.
SQL SERVER – 5 Important Steps When Query Runs Slow Occasionally
This was a very interesting situation and at the end of we had found the culprit for the slow query and resolved it. Today we will discuss the experience.
SQL SERVER – SUSPENDED Sessions Waiting on PAGELATCH_UP and PAGELATCH_SH – Solution
Their server got tremendously slow with many sessions suspending in the status of SUSPENDED status and they were waiting on PAGELATCH_UP and PAGELATCH_SH.
SQL SERVER – 5 Performance Optimizations Must Do for TempDB
Great hardware, bad performance, and TempDB was the culprit. Here are 5 performance optimizations must do for TempDB, starting with pre-sizing it.