Server Management Tips for SQL Server

added by kalyanms1
1/6/2013 1:35:55 PM

0 Kicks, 93 Views

Administrating the Server resources such as memory, processes and storage and low level resources such as locks, latches and queues are crucial as these are consumed by transactions. This post outlines some tips on managing server level and database level resources and also explains monitoring user sessions and their activity as well as concurrency structures such latches and locks.