SQL Server also has separate logs for the SQL Server Agent, as well as other components of the data platform, such as SQL Server Analysis Services. In each case, SQL Server keeps seven rolling log ...

When looking at storage performance problems, looking at the performance of the disks for a single SQL Server instance (physical or virtual) may not tell the entire story.

Microsoft has recently released a powerful new DMV specifically to help with memory issues, sys.dm_os_out_of_memory_events. It is currently available in Azure SQL Database and Azure SQL Man­aged ...