SQL Server 2005 Script 大集


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

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

http://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.

Skip to main content