Solved

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

Posted on 2008-10-10
3
1,119 Views
Last Modified: 2012-06-22
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
Comment
Question by:beanbrown
  • 2
3 Comments
 

Author Comment

by:beanbrown
ID: 22690801
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
 
LVL 51

Accepted Solution

by:
Mark Wills earned 500 total points
ID: 23096825
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
 

Author Closing Comment

by:beanbrown
ID: 31505038
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now