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.
