Home
Name Modified Size InfoDownloads / Week
LazyWrites.sql 2015-07-02 11.5 kB
readme.txt 2015-07-02 1.7 kB
PageLifeExpectancy.sql 2015-07-01 11.2 kB
CXPACKETWaitType.sql 2015-06-17 9.5 kB
Fragmentation.sql 2015-06-15 7.5 kB
ActivityReportWeekly.sql 2015-05-27 7.4 kB
ActivityReportDaily.sql 2015-05-27 7.3 kB
ActivityLogger.sql 2015-05-26 3.9 kB
Totals: 8 Items   60.0 kB 0
Disclaimer: No warranties of any kind.
Twitter: https://twitter.com/sqltune
Questions? Open a case at https://sqlxl.zendesk.com or use our Live Chat at www.sqlxl.com

Description: This project is a collection of SQL scripts that monitor your SQL server and collect vital performance statistics. Most of the scripts are self-contained and can be installed independently of each other. Some scripts work particularly well with each other and will be identified below. All scripts contain their own installation instructions in the .sql files.

Scripts:

Activity Logger - This script captures activity and resource consumption on your SQL server for all running queries. This script is **HIGHLY RECOMMENDED** as it collects information that is also very useful to the other scripts.

Daily Activity Report - This is a daily report to identify which queries are using the most resources on your server. Optimizing the queries identified by this report can reduce the overall load on your system and improve performance system-wide.

Weekly Activity Report - This is a weekly report to identify which queries are using the most resources on your server. Optimizing the queries identified by this report can reduce the overall load on your system and improve performance system-wide.

High Fragmentation Report - This report will scan and identifying what indices on your database need maintenance and make recommendations. Schedule this one to run periodically.

CXPACKET Wait Type Report - These queries could be using too many threads and are super-easy to tune.

Page Life Expectancy Report - Great way to determine if you are under memory pressure.

High Lazy Writes Report - Solid companion to Low Page Life Expectancy.



Source: readme.txt, updated 2015-07-02