Keep It Simple and Fast refers to my focus during development of applications. In my opinion, applications should be very simple to use and do not have dozens of options. Every application should perform very fast, even in high transactions volume or high multi user environments.

Monday, April 4, 2011

As described in my previous blogpost I started a series in which I will explain how you can make a dashboard in SQL Reporting Services to analyze your SQL Server Profiler trace files. In this blogpost I will explain what you need to install and configure to use this dashboard.

What do you need to install:

SQL Server 2008 R2 database engine. This database server is used to import all trace files into a database.

SQL Server Reporting Services. (2008 R2). This reporting server is used to host the dashboard.

SQL Server Business Intelligence Development Studio. With BIDS you can modify the dashboard and deploy the reports to the reporting server.

What else do you need:

Use the default trace file template of SQL Profiler to trace your application. Be aware to use the correct filter for the trace, so you got only these queries you want to analyze. For instance you can filter on hostname, spid or applicationname.

Script to create database and table in which all trace files are imported.

Import script to import the SQL Profiler trace files (.TRC)

The SSRS reports of the dashboard to analyze the trace files.

First we will start to create a new PerformanceAnalyze database and import table: TraceFileImport

No comments:

About Me

My name is André van de Graaf, I'm working for Exact Software in the Research team as Principal Research Engineering. I'm located in Delft, The Netherlands. In my work i have a strong focus on performance of applications. Beside performance I want to keep everything as simple as possible. What is the perfect balance between performance and functionality?