Using linked connections you can collect system information on your Oracle server from SQL server.  Read more...

Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.  Read more...

A look at what's happening with the SQLServerCentral servers based on the public information exposed by SQL Monitor.  Read more...

This is the method that Geoff Albin has used for years to monitor the CPU on his SQL Servers.  Read more...

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.  Read more...

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.  Read more...

This SP will monitor T-Log space and sends mail to DBA if log space usage is above threshold value  Read more...

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

Report to keep you abreast of various details of an instance, including: general properties, uptime, drive space, db size allocation, growth stats, backups, jobs, unused indexes, & more...  Read more...

This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.  Read more...

This scripts helps to power you with the disk space monitoring for the Mount points. Hope this helps  Read more...

Track object definition or table schema changes in any database. Batteries required: you need to create a few things to make it run.  Read more...

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

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

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

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?   Read more...

Keeping track of the space used and free in your database files is something that all experienced DBAs need to do. And something many new DBAs forget. New author Jayakumar Krishnan brings us an easy technique to do this in SQL Server 2008 with Policy Based Management.  Read more...

This article describes a utility that allows you to identify what SQL statements are currently executing.  Read more...

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.   Read more...

Read more...