Multiple Server Query Execution in SQL Server 2008

SQL Server 2008 SSMS introduces a new feature, Multiple Server Query Execution, in Query Editor. This feature intends to increase the productivity of running same query against multiple servers at once. Some of useage include: ·         Configure group of servers or server farm ·         Generate report or document from multiple servers ·         Analyze result from multiple servers ·         or Run…

9

Performance Data Collector for SQL Server 2008 – Revealed

I’ve been getting many requests on what is this new Performance Data Collector  tool and how does it work. First off, Performance Data Collector is simply a component as one of the tools in Management Studio (SSMS) involved in performance troubleshooting. These tools include the new Data Collector, System Collection Sets, the Management Data Warehouse, and…

3

November CTP News: Workaround fix for query execution issue

SQL Server 2008 November CTP (CTP5) has a known issue that any query execution hangs indefinitely. Fortunately, there is a quick and simple workaround to fix the issue. Cause & Problem: User changes the default setup directory to a custom one during the initial setup. Query Editor hangs indefinitely when user execute any query, even a simple…

2