Server Performance and Activity Monitoring How-to Topics

Celem monitorowania baz danych jest oceny, w jaki sposób działa na serwerze.Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track performance trends.Microsoft SQL Server and the Microsoft Windows operating system provide utilities that let you view the current condition of the database and to track performance as conditions change.

W poniższej sekcji zawiera tematy opisują sposób korzystania z SQL Server i narzędzia do monitorowania wydajności systemu Windows i działania. Zawiera ona następujące tematy:

W tej sekcji

Do monitorowania zadań za pomocą narzędzi systemu Windows

• How to: Start Performance Monitor (Windows NT)

• How to: Start System Monitor (Windows)

• How to: View the Windows Application Log (Windows)

Do tworzenia alertów bazy danych programu SQL Server za pomocą narzędzi systemu Windows

• How to: Set Up a SQL Server Database Alert (Windows)

• How to: Set Up a SQL Server Database Alert (Windows NT)

Aby wykonywać zadania monitorowania przy użyciu programu SQL Server Management Studio

• How to: View the SQL Server Error Log (SQL Server Management Studio)

• How to: Open Activity Monitor (SQL Server Management Studio)

Aby przeprowadzić monitorowania zadań z śledzenia SQL przy użyciu języka Transact-SQL procedur przechowywanych

• How to: Create a Trace (Transact-SQL)

• How to: Set a Trace Filter (Transact-SQL)

• How to: Modify an Existing Trace (Transact-SQL)

• How to: View a Saved Trace (Transact-SQL)

• How to: View Filter Information (Transact-SQL)

• How to: Delete a Trace (Transact-SQL)

Do tworzenia i modyfikowania ślady przy użyciu programu SQL Server Profiler

• How to: Create a Trace (SQL Server Profiler)

• How to: Set Global Trace Options (SQL Server Profiler)

• How to: Specify Events and Data Columns for a Trace File (SQL Server Profiler)

• How to: Create a Transact-SQL Script for Running a Trace (SQL Server Profiler)

• How to: Save Trace Results to a File (SQL Server Profiler)

• How to: Set a Maximum File Size for a Trace File (SQL Server Profiler)

• How to: Save Trace Results to a Table (SQL Server Profiler)

• How to: Set a Maximum Table Size for a Trace Table (SQL Server Profiler)

• How to: Filter Events in a Trace (SQL Server Profiler)

• How to: View Filter Information (SQL Server Profiler)

• How to: Modify a Filter (SQL Server Profiler)

• How to: Filter Events Based on the Event Start Time (SQL Server Profiler)

• How to: Filter Events Based on the Event End Time (SQL Server Profiler)

• How to: Filter Server Process IDs (SPIDs) in a Trace (SQL Server Profiler)

• How to: Organize Columns Displayed in a Trace (SQL Server Profiler)

Aby rozpocząć, wstrzymać lub zatrzymać ślady przy użyciu programu SQL Server Profiler

• How to: Start a Trace Automatically after Connecting to a Server (SQL Server Profiler)

• How to: Pause a Trace (SQL Server Profiler)

• How to: Stop a Trace (SQL Server Profiler)

• How to: Run a Trace After It Has Been Paused or Stopped (SQL Server Profiler)

Aby otworzyć ślady i skonfigurować sposób wyświetlania ślady przy użyciu programu SQL Server Profiler

• How to: Open a Trace File (SQL Server Profiler)

• How to: Open a Trace Table (SQL Server Profiler)

• How to: Clear a Trace Window (SQL Server Profiler)

• How to: Close a Trace Window (SQL Server Profiler)

• How to: Set Trace Definition Defaults (SQL Server Profiler)

• How to: Set Trace Display Defaults (SQL Server Profiler)

Aby powtórzyć ślady przy użyciu programu SQL Server Profiler

• How to: Replay a Trace File (SQL Server Profiler)

• How to: Replay a Trace Table (SQL Server Profiler)

• How to: Replay a Single Event at a Time (SQL Server Profiler)

• How to: Replay to a Breakpoint (SQL Server Profiler)

• How to: Replay to a Cursor (SQL Server Profiler)

• How to: Replay a Transact-SQL Script (SQL Server Profiler)

Tworzenie, modyfikowanie i korzystania z szablonów śledzenia przy użyciu programu SQL Server Profiler

• How to: Create a Trace Template (SQL Server Profiler)

• How to: Modify a Trace Template (SQL Server Profiler)

• How to: Derive a Template from a Running Trace (SQL Server Profiler)

• How to: Derive a Template from a Trace File or Trace Table (SQL Server Profiler)

• How to: Export a Trace Template (SQL Server Profiler)

• How to: Import a Trace Template (SQL Server Profiler)

Aby użyć programu SQL Server Profiler służy do zbierania i monitorowania wydajności serwera śledzenia

• How to: Find a Value or Data Column While Tracing (SQL Server Profiler)

• How to: Save Deadlock Graphs (SQL Server Profiler)

• How to: Save Showplan XML Events Separately (SQL Server Profiler)

• How to: Save Showplan XML Statistics Profile Events Separately (SQL Server Profiler)

• How to: Extract a Script from a Trace (SQL Server Profiler)

• How to: Correlate a Trace with Windows Performance Log Data (SQL Server Profiler)