Solved

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

Posted on 2008-10-10
3
1,123 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

785 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