Solved

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

Posted on 2008-10-10
3
1,130 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
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.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

630 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