Solved

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

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

895 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

21 Experts available now in Live!

Get 1:1 Help Now