SQL Server performance basics
February 19, 2014
Monitoring is recommended in dynamic environments. When it comes to SQL Server – users, DBAs, and the system itself are performing events constantly – changing data and database structure, user privileges, etc. SQL Server can manage automatically all these requests, but its self-tuning doesn’t provide best results, and additional monitoring and manual tuning can provide better performance
Read more »
SQL Server Activity Monitor
February 14, 2014
Monitoring system and SQL Server databases shows the metrics that indicate server performance. Efficient monitoring provides enough information to diagnose problems, blocks, bottlenecks, and to fix them
Read more »
Top 10 articles on the SQL Server transaction log
February 13, 2014Understanding Logging and Recovery in SQL Server
In “Understanding Logging and Recovery in SQL Server”, Paul S. Randal has given a complete overview of the transaction log. In four sections he explains: what is logging, what is recovery, how the transaction log works, and which recovery models are available. This article can be used as a starting point in understanding fundamentals of the transaction log and the logging process Read more »
10 most important SQL Server transaction log myths
February 12, 2014
Myth: SQL transaction log truncation will make it smaller
Read more »
