How to centralize your SQL Server Event Logs

Learn how you can centralize the Event log data for your servers using a process that Geoff Albin has been using for over 10 years.

Under the ORM Hood: Revealing the SQL

Your application code may look neat and clean, and you are using a sound Object-relational Mapper, but when you put the pedal to the metal, you're not getting the performance. The time has come to lift the hood and see what SQL is being generated by the ORM, and what part of your code is causing the bottlenecks. The effect can be spectacular.

Using the UPTIME Utility to Monitor Servers

Learn how to use a free utility to quickly monitor the uptime of your SQL Server instances.

Light Weight Monitoring using Extended Events

Extended events provide DBAs with a new lightweight tool to monitor SQL Server performance.

SQL Overview VI - Monitoring Process Locks

In the sixth part of his series on monitoring your SQL Server, David Bird looks at process locks.

SQL Overview V - Monitoring Long Running Jobs

Continuing with his series on monitoring your SQL Servers, David Bird now looks a a way to fin those long running, active jobs.

Database Activity Monitoring Part 1 - An Introduction

We are inundated with new technologies and products designed to help make our organisations safe from hackers and other malcontents. One technology that has gained ground over the past few years is database activity monitoring. It makes sense to protect valuable databases, and by adding an intelligent monitor capable of sniffing out threats an additional level of protection can be gained.

But what is database activity monitoring and why should you care?

SQL Server Monitoring Scripts with the DMVs

If you do not have a third party monitoring tool in place, the only way is to constantly monitor SQL Server. To do this without being overly intrusive, we need to rely on the SQL Server DMVs.

SQL Server Information

Checking the Job Status on Multiple Servers

Keeping track of the jobs you have running across all your servers can be a challenge these days with fewer and fewer employees. New author Sivakumar Mahalingam brings us an article that shows one way to accomplish this task.