ToolBox

Compress Many-to-Many C# Utility

2008-03-24T20:38:00Z

https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=SQLSrvAnalysisSrvcs&ReleaseId=11950

This project creates a utility that enables you to easily implement the many-to-many compression technique discussed in the Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques best practices white paper. You can download this white paper from the SQL Server Best Practices web site at: http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx

Create a Processing Log Script Project

2008-03-24T20:35:00Z

https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=SQLSrvAnalysisSrvcs&ReleaseId=11950

This project contains a script that enables you to create a system-wide processing log file for monitoring / auditing purposes. It also contains a script that enables you to delete a system-wide processing file.

SQL Server Analysis Services Performance Monitoring and Visualization Methodology

2008-03-24T20:31:00Z

https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=SQLSrvAnalysisSrvcs&ReleaseId=11950

This methodology collects and processes SQL Server Analysis Services trace files by using SQL Server Integration Services and SQL Server stored procedures. It then utilizes SQL Server Reporting Services reports to visualize performance issues related to MDX queries and processing jobs. This methodology includes components to work with both SQL Server 2005 and SQL Server 2008 CTP6.

Powershell Scripts for SQL Server 2008 Analysis Services DMVs

2008-03-24T20:24:00Z

https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=SQLSrvAnalysisSrvcs&ReleaseId=11950

These sample scripts demonstrate how to use Powershell to query SQL Server 2008 Analysis Services DMV's. The four sample scripts enable you to cancel all queries running longer than a specified length of time, cancel a particular session/SPID/connection, retrieve the Analysis Services version, or return the results of any DMV query.

SQL DMVStats Toolkit

2008-02-21T16:48:00Z

http://www.codeplex.com/sqldmvstats

A SQL Server 2005 Dynamic Management View Performance Data Warehouse

Introduction

Microsoft SQL Server 2005 provides Dynamic Management Views (DMVs) to expose valuable information that you can use for performance analysis. DMVstats 1.0 is an application that can collect, analyze and report on SQL Server 2005 DMV performance data. DMVstats does not support Microsoft SQL Server 2000 and earlier versions.

Main Components

The three main components of DMVstats are:
• DMV data collection
• DMV data warehouse repository
• Analysis and reporting.
Data collection is managed by SQL Agent jobs. The DMVstats data warehouse is called DMVstatsDB. Analysis and reporting is provided by means of Reporting Services reports.

For more details, refer to the file attachment DMVStats.doc.

Tom Davidson & Sanjay Mishra
Microsoft SQL Server Customer Advisory Best Practices Team

SQL Server 2005 Partition Management Tool

2008-02-21T16:47:00Z

http://www.codeplex.com/sql2005partitionmgmt

Sliding Window technique is commonly used with partitioned tables to manage large data volumes. It allows efficient loading of new data and archival or removal of the old data. The challenges in a sliding window scenario is to create the staging table(s) correctly for efficient partition SWITCH operations. This utility provides a command line interface to:

1. Remove all the data from one partition by switching it out to a staging table. It creates the required staging table.
2. Create a staging table for loading data into a partition. The staging table can be created with or without indexes -- if created without indexes this utility provides a separate command to create appropriate indexes on the staging table, before SWITCHing it into the partitioned table.

The commands can be invoked from other scripts for end-to-end sliding window scenarios.

Scripts and Tools for Performance Tuning and Troubleshooting SQL Server 2005

2008-02-21T16:44:00Z

http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx

Sample scripts and stored procedures for managing and working with SQL Server 2005.

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.

SQL Server 2005 Best Practices Analyzer

2008-02-21T16:42:00Z

http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.