“SET NOCOUNT ON” vs “SET NOCOUNT OFF”

“SET NOCOUNT ON” vs “SET NOCOUNT OFF”

Here I would like to give a performance benefit at very small/basic level. Continue reading

Advertisements

Basic Performance Investigation

When we have to go through a performance issue, the first thing that we have to do is gathering all the information as possible from the user that is reporting the issue. Many times, the source of the problem is on the user environment and we have to ensure that the problem is a real performance problem before starting the investigation. In order to gather information, we need to ask to the user as many question as we can build approaching meaningful information (like error messages, actions performed, etc) about the issue and if needed, we can ask the user to share their desktop to understand at all the user problem.

  Continue reading

Lock pages in memory – SQL Server

This security setting determines which accounts can use a process to keep data in physical memory, which prevents the system from paging the data to virtual memory on disk. Exercising this privilege could significantly affect system performance by decreasing the amount of available random access memory (RAM). Continue reading