If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So, if you are SQL Developer and your query run slow, you would prefer to have query execution statistics so that you can figure out what causing the query to run slow. To get the query execution statistics, […]
Top Function – Performance Gain
Read more
Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were a developer. During the session, I discussed TOP function, and I throw a question to the audience – “Not using Top function especially when you can use it – Can it cause performance problem or […]
Out of memory error because of the very low virtual address space – Error 701 – Trace Flag 8075
Read more
If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of memory (OOM) error because of low “Available Virtual Memory”. Recently, I assigned more than 820GB memory to one of the SQL Server instances. The instance was dealing with a significant reporting workload. After a couple […]
After migrating SQL Server from 2005 to higher version, the waits type PAGELATCH_UP increased
Read more
Recently, I experienced an interesting issue where I found SQL Server wait type PageLatch_UP went up drastically after migration. Let’s walk through to understand the problem and its solution. Problem After migrating SQL Server 2005 instances to higher versions – SQL 2008/SQL 2008 R2/SQL 2012/SQL 2014 and SQL 2016, I found the most of (not all) […]