SQL Server 2005 Script 大集

  • Article

在下列網址中有許多的 Script 示範如何使用 DMV 來查詢 SQL Server 2005 的狀態。

若是要做效能調校的朋友可以參考其中的語法。

https://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/tempdb/default.mspx?mfr=true

 

Buffer Cache

Sample scripts and stored procedures for managing and monitoring the SQL Server buffer cache.

•
CPU and Optimization

Sample scripts and stored procedures for optimizing CPU performance in SQL Server.

•
Indexes and Indexing

Sample scripts and stored procedures for working with SQL Server indexes.

•
Input/Output

Sample scripts and stored procedures for managing and monitoring input and output in SQL Server.

•
Performance (General)

Sample scripts and stored procedures for managing and monitoring general performance issue in SQL Server.

•
Procedure Cache

Sample scripts and stored procedures for managing the SQL Server procedure cache.

 

•
SQL Text

Sample scripts and stored procedures for working with SQL text.

•
SQLOS

Sample scripts and stored procedures for working with the new SQL Server Operating System Layer.

•
Tempdb

Sample scripts and stored procedures for working with the tempdb system database.

•
Transactions and Logging

Sample scripts for working with SQL Server transactions and locks.

•
Waitstats

Sample scripts and stored procedures for working with SQL Server waitstats.

 

Enjoy.