SSIS 2008 R2 performance and Windows Server 2008 R2 with a clustered SQL instance is slower than when connecting to a non-clustered instance?
I am testing different configurations for loading data from a remote SQL server using SSIS. In a clustered situation SSIS seems slower to speak to the local clustered SQL instance when compared to a non clustered local SQL instance. It looks like any scenario where SSIS speaks to a clustered SQL instance; the communication occurs [...]

Answer Question   |  May 22, 2011  9:22 AM
Business Information Warehouse, SQL Server, SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring, SSIS, Windows Server 2008 R2

Performance benchmarks for SQL Server 2008 R2
Have performance benchmarks for SQL Server 2008 R2 been published somewhere?

Answer Question   |  May 7, 2010  8:25 PM
SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring

Performance and Resource Consuming Monitors SQL Server 2008 R2
Are there any specific GUI tools available to monitor the performance and resource consuming process? At present we are using third party tool to do so (Spot light)?

Answer Question   |  January 28, 2011  9:55 PM
SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring

Conducting a performancee baseline comparison
I was reading this 2-part article on performance baselines. I would like to know how someone actually performs the comparison between the performance on the system with the baseline? How do you use SQL Server Profiler and PerfMon to do the comparison?

Answer Question   |  April 8, 2010  3:43 PM
SQL Server Performance Monitoring, SQL Server Profiler

Moving Distribution database from an instance to antother does increase performance ?
The Publisher database is in use by nearly 300 users with a trafic of about 340trans/sec. After adding replicas with a [strong]push[/strong] subscription (transaction replication with queue mngmt) to 1 subscriber (15 users) the CPU need on the server moved from 25% to about 55% and I can see some collisions between users (through application) and the [...]

Answer Question   |  March 15, 2010  10:49 AM
distrib.exe, Performance/Tuning, SQL Server 2005, SQL Server Performance Monitoring, transaction replication

SQL SERVER 2005 Performance Monitoring
Hello, is there a free software tool to monitor sql server 2005 similar to Quest FogLight? Quest FogLight is just too expensive for my budget. I am an independent consultant and I want to be able to monitor my client’s sql server.

Answer Question   |  January 6, 2012  6:40 PM
SQL Server 2005, SQL Server performance, SQL Server Performance Monitoring, SQL Server performance tuning