SQL Solution center round-up – January 15th, 2014 – SQL code formatting and SQL Server memory performance metrics

In the last two weeks, SQL Solution center articles were focused on SQL code formatting and SQL Server performance memory metrics

In How to format SQL like a pro – formatting to implicit Microsoft standards and guidance, we followed MSDN, SQL Server 2012 Books Online documentation, and the Adventure Works 2012 SQL Server database formatting recommendations and showed how to implement these standards using SQL Server Management Studio and Visual Studio add-in ApexSQL Refactor

We started a SQL Server performance metrics series that covered memory related metrics

The first part presents Memory pages/sec and Memory page faults/sec – two of several most important memory performance metrics. We explained what page faults are, what information these metrics show, showed the normal values for these metrics, and what problems the values outside the normal range can indicate

In the next part, we continued with presenting important memory metrics and presented three more memory metrics that affect SQL Server performance – Available memory bytes, Total server memory, and Target server memory. We provided their definitions, recommended values, and queries for obtaining Total server memory and Target server memory from the sys.dm_os_performance_counters system view

The third sequel – SQL Server Buffer Manager metrics and memory counters presents Page reads/sec, Page writes/sec, Pages Input/sec, and Pages output/sec, and shows how they can be used to troubleshoot SQL Server performance problems and memory overload

January 15, 2014