Great tool for Windows 2003: Server Performance Advisor (SPA)

re: Great tool for Windows 2003: Server Performance Advisor (SPA)

Brian — Wed, 14 Nov 2012 18:30:30 GMT

Hello I know this is an old utility but I really need to run it on my Server 2003 box and it doesn't appear to be working at all. I went through the install (logged in as domain admin) and there were no errors, however, when I open the spa.exe it gives an error about configuration.xml missing. I took a stab and extracted the .cab file I found in the \data directory and at least now the utility runs. But if I try to add/repair any data collector groups, I get "Load Failed." I've tried several uninstalls/reinstalls to no avail. Please help!

Brian

re: Great tool for Windows 2003: Server Performance Advisor (SPA)

shailyphilines — Wed, 02 Jun 2010 11:55:40 GMT

The Server Performance Advisor (SPA) is capable of much more than tracking LDAP activity and it is certainly worth spending more time exploring the feature set.is a simple but robust tool that helps administrators diagnose the root causes of performance problems in a Microsoft Windows Server 2003 deployment

<a href="http://www.cheapspadays.com">cheap spa days</a>

re: Great tool for Windows 2003: Server Performance Advisor (SPA)

Rob — Fri, 12 Mar 2010 13:16:32 GMT

Hi, i get several events:

Event Type: Warning

Event Source: PLA

Event Category: Manager

Event ID: 1006

Date: 11-3-2010

Time: 9:11:32

User: N/A

Computer: SPNLAPP00133

Description:

UI Control

Origin: System Overview

Error: 0x80070057

Rules evaluation failed at '-348886050785,441 * 100' has an invalid token.

Parameter name: d:\PerfLogs\reports\Report\System Overview\Current\P00133_201003110909\report.xml - Rules evaluation failed at '-348886050785,441 * 100' has an invalid token.

Parameter name: d:\PerfLogs\reports\Report\System Overview\Current\P00133_201003110909\report.xml

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

and when i make the report i only get the

incomplete_report.xml file.

do you have a solution?

Interacting with Data Collector Sets via Powershell

Brad Rutkowski's Blog — Thu, 19 Feb 2009 00:30:19 GMT

Background: In an earlier post I talked about some new features for Windows 2008 and Vista.  One

re: Great tool for Windows 2003: Server Performance Advisor (SPA)

AP — Tue, 17 Feb 2009 18:55:40 GMT

Hi all,

As stated in the help file I think you def need SQL 2000 or the MSDE.

Struggled with SQL 2005 until reverting to SQL 2000 install and the SPA DB was then created first time!

re: Great tool for Windows 2003: Server Performance Advisor (SPA)

Brian — Fri, 10 Oct 2008 17:29:02 GMT

Hello Brad,

Thanks for your help. Would you recommend that I use the counters in SPA as a baseline for setting up the counters in performance monitor (Based on each server role, of course.)? If not, do you know of a resource that list recommended counters for different servers roles?

Thank You,

Sincerely,

Brian

re: Great tool for Windows 2003: Server Performance Advisor (SPA)

BooRadely — Thu, 09 Oct 2008 01:04:29 GMT

Hi Brian. I think for true trending purposes perfmon is still the correct choice (Or MOM :)). SPA is good for trending against a small number of systems but lrage number might be a bit cumbersome.

re: Great tool for Windows 2003: Server Performance Advisor (SPA)

Brian — Thu, 02 Oct 2008 20:52:14 GMT

Hello Brad,

Thanks for the info. My question is does

this "replace" perfomance monitor as far as setting a baseline for server system performance and day-forward monitoring of server performance? I was trying to set up performance counters for specific server roles such as file, print, domain controller, email, database(DOn't think DB is possiblebased on some previos questions) and web server when I came across this utiliy. Should I still go ahead and configure performance logging or is

Server Performance Advisor a turn-key solution? Any help, suggestions and advice would be greatly appreciated.

re: Great tool for Windows 2003: Server Performance Advisor (SPA)

Tom — Tue, 09 Sep 2008 17:41:24 GMT

Hi Nev.

You must be in the same boat as me.

There is no useful information I can find on setting up SQL to work with SPA, least of all in the SPA CHM. So as far as I'm concerned SPA Trending will have to wait until someone with the proper know-how posts some documentation, but in the meantime I am having fun with SPA basic.

re: Great tool for Windows 2003: Server Performance Advisor (SPA)

Nev — Tue, 02 Sep 2008 17:12:19 GMT

Tom - I can see your posts all over the web asking for help on this issue. Any luck? I too can't seem to get this working. The chm file is useless since it doesn't give any detailed instructions. Unless you can do that for us here Brad?

Thanks.