Monitoring SQL  «Prev  Next»

Lesson 1

Monitoring SQL Server with SQL and SQL-EM

Monitoring SQL Server
As a SQL Server system administrator, you need to verify the health of your SQL Server and troubleshoot problems. SQL Server has multiple tools to aid you in these tasks. This module discusses how to use SQL and SQL-EM to monitor SQL Server.

Learning objectives

By the time you complete this module, you should be able to Monitor SQL Server connections
  1. Monitor SQL Server connections
  2. Use SQL-EM to montior connections
  3. Monitor SQL Server locks
  4. Use SQL-EM to monitor locks
  5. Monitor overall system performance
  6. Monitor SQL Server with database consistency checker
  7. Use dbcc buffer to monitor the data cache
  8. Use dbcc to monitor overall performance
  9. Monitor SQL Server with trace flags
  10. Monitor SQL Server with built-in functions
The next lesson will cover how to monitor connections.

SQLEM: Fast Clustering in SQL using the EM Algorithm (2000)

Clustering is one of the most important tasks performed in Data Mining applications. This paper presents an efficient SQL implementation of the EM algorithm to perform clustering in very large databases. Our version can effectively handle high dimensional data, a high number of clusters and more importantly, a very large number of data records. We present three strategies to implement EM in SQL: horizontal, vertical and a hybrid one. We expect this work to be useful for data mining programmers and users who want to cluster large data sets inside a relational DBMS.