Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Monitoring Rss

Search for any content tagged monitoring

<< Newer    Items 41 to 60 of 152    Older >>
 

SQL Overview VI - Monitoring Process Locks

In the sixth part of his series on monitoring your SQL Server, David Bird looks at process locks.  Read more...
By David Bird 2011/07/22 (first published: 2010/03/31) | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 15,113 reads

SQL Overview SSIS Package III - Full Package

Continuing on with his series on reporting for your SQL Server, David Bird brings together the series with the full package used for building the report.s  Read more...
By David Bird 2011/07/15 (first published: 2008/01/22) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 20,528 reads

Monitor SQL Server Replication Jobs

The Replication infrastructure in SQL Server is implemented using SQL Server Agent to execute the various components involved in the form of a job (e.g. LogReader agent job, Distribution agent job, Merge agent job) SQL Server jobs execute a binary executable file which is basically C++ code.  Read more...
By Additional Articles 2011/07/11 | Source: SQL Server Performance | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 2,740 reads

SQL Overview SSIS Package II - Retrieving SQL Error Log

In Part II of his series on monitoring SQL Servers, David Bird takes a look at importing data from your error logs.  Read more...
By David Bird 2011/07/08 (first published: 2008/01/14) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 17,414 reads

SQL Overview Part 1

Monitoring your SQL Server instances and figuring out what's going on is important to keep an eye on your environment. David Bird brings us a new series that looks at how you might start setting this up with Integration Services.   Read more...
By David Bird 2011/07/01 (first published: 2008/01/07) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 26,164 reads

Using SQL Server to collect information from your Oracle server

Using linked connections you can collect system information on your Oracle server from SQL server.  Read more...
By Rudy Panigas 2011/06/06 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 3,361 reads

What's Happening Here?

A look at what's happening with the SQLServerCentral servers based on the public information exposed by SQL Monitor.  Read more...
By Steve Jones 2010/12/09 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,708 reads

How to Monitor for High CPU utilization in SQL Server

This is the method that Geoff Albin has used for years to monitor the CPU on his SQL Servers.  Read more...
By Geoff Albin 2012/10/19 (first published: 2010/11/17) | Source: SQLServerCentral.com | Category: cpu
Rating: |  Discuss |   Briefcase | 24,703 reads

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.  Read more...
By Geoff Albin 2014/05/02 (first published: 2010/11/08) | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 11,689 reads

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.  Read more...
By Additional Articles 2010/11/05 | Source: SimpleTalk | Category: monitoring
Rating:  Rate this |   Briefcase | 2,756 reads

Using the UPTIME Utility to Monitor Servers

Learn how to use a free utility to quickly monitor the uptime of your SQL Server instances.  Read more...
By Richard Pless, Shawn Calderon 2010/06/23 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 7,972 reads

Default trace - A Beginner's Guide

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...
By Adam Haines 2010/06/11 (first published: 2008/11/11) | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 39,249 reads

Light Weight Monitoring using Extended Events

Extended events provide DBAs with a new lightweight tool to monitor SQL Server performance.  Read more...
By Additional Articles 2010/04/19 | Source: SQL Server Performance | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,246 reads

SQL Overview VI - Monitoring Process Locks

In the sixth part of his series on monitoring your SQL Server, David Bird looks at process locks.  Read more...
By David Bird 2011/07/22 (first published: 2010/03/31) | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 15,113 reads

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.  Read more...
By David Bird 2011/07/29 (first published: 2010/03/24) | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 16,688 reads

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?   Read more...
By Additional Articles 2010/03/08 | Source: Other | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 4,358 reads

Using SQL Server 2008 PBM to Monitor Free Space

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...
Rating: |  Discuss |   Briefcase | 7,604 reads

What SQL Statements Are Currently Executing?

This article describes a utility that allows you to identify what SQL statements are currently executing.  Read more...
By Ian Stirk 2009/12/11 (first published: 2008/10/28) | Source: SQLServerCentral.com | Category: dmv
Rating: |  Discuss |   Briefcase | 47,815 reads

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.   Read more...
By Additional Articles 2009/10/23 | Source: MSSQLTips.com | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 4,453 reads

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.  Read more...
By Sivakumar Mahalingam 2009/09/07 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 6,713 reads
<< Newer    Items 41 to 60 of 152    Older >>