• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1144
  • Last Modified:

Data Collector sets will not save to Sql 2008 Performance Data Warehouse

I have setup the Sql 2008 Data Collection, and there are 3 default collection sets, yet when I try to setup the data collectors on a remote server (log perf counters to sql), I get:

WHen attempting to start the Data Collector Set the
following system error occured:

Call to SQLAllocConnect failed with %1.

My goal is to collect performance statistics from all my Windows 2008 machines in the PDW of the sql 2008 server.

Thanks,
Eric
0
beanbrown
Asked:
beanbrown
  • 2
1 Solution
 
beanbrownAuthor Commented:
The Data Collector set on the sql 2008 machine works fine.  It seems like much of the work will need to be done using sql stored procedures (guiless), which is no problem, so, I'm not sure that simply pointing the perf counter at sql is the best way.  Regardless, it seems like there should be a way to use the PDW for 2008 machines that do not have sql 2008 on them.
0
 
Mark WillsTopic AdvisorCommented:
You would think that to be a reasonable request, but, do not think it is possible... for a start SQL Server Integration Services is required to manage collections, and fairly sure it is expecting local database connections for those new tables in MSDB.

having said that there is a hot fix available : http://support.microsoft.com/kb/906859

Have you seen : http://sqlblogcasts.com/blogs/thepremiers/archive/2008/06/20/sql-server-2008-performance-studio.aspx

0
 
beanbrownAuthor Commented:
Ok, I feared that might be the case, although I was hopeful and posted here.  Thank you for the links above, they are quite useful!
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now