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.
By the time you complete this module, you should be able to Monitor SQL Server connections
Monitor SQL Server connections
Use SQL-EM to montior connections
Monitor SQL Server locks
Use SQL-EM to monitor locks
Monitor overall system performance
Monitor SQL Server with database consistency checker
Use dbcc buffer to monitor the data cache
Use dbcc to monitor overall performance
Monitor SQL Server with trace flags
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.