Monitoring

Article

In SQL Server, replication is a widely adopted technology for the purpose of real-time data replication between SQL servers. It serves the purpose of keeping data consistent between multiple end points. So the last thing we want to hear from clients is that data is no longer in synch, and as DBA, we don't want to be the last person to realize replication is out of order or broken. Here are some steps you can take to monitor SQL Server replication.

2011-10-26

3,444 reads

Preventing Problems in SQL Server

by Additional Articles

SimpleTalk

Monitoring

Article

It is never a good idea to let your users be the ones to tell you of database server outages. It is far better to be able to spot potential problems by being alerted for the most relevant conditions on your servers at the best threshold. This will take time and patience, but the reward will be an alerting system which allows you to deal more effectively with issues before they involve system down-time.

2011-09-01

3,959 reads

Tracking processes

by hgutsche

SQLServerCentral.com

Monitoring

Script

This script quick tip for those who will accurately monitor sessions on SQL Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2011-08-16 (first published: 2011-08-02)

1,668 reads

Discuss

Using SQL Server to collect information from your Oracle server

by Rudy Panigas

SQLServerCentral.com

Monitoring

Article

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(11)

You rated this post out of 5. Change rating

2011-06-06

3,469 reads

Discuss

How to centralize your SQL Server Event Logs

by Geoff Albin

SQLServerCentral.com

Monitoring

Article

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(49)

You rated this post out of 5. Change rating

2014-05-02 (first published: 2010-11-08)

14,107 reads

Discuss

Under the ORM Hood: Revealing the SQL

by Additional Articles

SimpleTalk

Monitoring

Article

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.

2010-11-05

3,304 reads