This is Good tool, and most important thing...It is cmd based which makes things much easier you know, that going through GUI and wait till that page with intensive graphic tools gets loaded. BTW my report.xml file was under C:\perflogs\Report\File\Current\
What are the possibility of using this tool remotely, you know I can't keep this installing on every server.
I am having trouble getting the trending to work. It never sends anthing to the SQL server
Preetamz, dont see a way to use this remotely as the dlls need to run locally on the system. Since it is an MSI package you can deploy it remotely using many difernet methods like GPO and SMS.
Jason, installing SPA install a CHM file which has detailed information on how to setup trending correctly. Check that out.
Has anyone installed this on a TS server? When I look at the reports the data is missing?
Sounds like its not compiling the data. I'd look in the directory where the data resides for the reprot.xml file if its not there its not compiling.
Easises tthing to do first is to run: "spacmd compile *" and see if anything is generated.
The chm file is not very detailed at all. How is the DB supposed to be setup in terms of the tables? Is there something being assumed here or has something failed during the install process for me?
Yep sounds like the install didnt land Michael. If it did you would see the SPA info in SQL.
Performance Analysis of Logs (PAL) tool Project Description: Ever have a performance problem, but don't
Did anyone ever get trending to work. I have setup up report trending as instructed in the chm file however the sql db is never populated...
Any events in eventvwr.msc that are SPA related, they migth give you some clues. We got it working interally for sure.
I have used SPA to analyse a couple of servers and it was excellent. Now I want to role it out to a few more and configure it with different roles. However I have tried to setup a data/report configuration and I cannot get the report server to pick up the files. I have created a transfer share, set the role and the generate setting but no joy. Any ideas would be appreciated.
Hi John the only thing I can think of is that the SPA jobs run under the system account of each machine, you need to create a group that includes all these machines and give that group read/write/modify perms on the reporting server. Or run the SPA scheduled jobs under an account which has rights to write to the reporting server.
I've got the tool setup and running nicely, and now want to graduate from storing reports locally on the few servers I'm piloting, to sending all data to a dedicated Report Server running SQL Express 2005.
If everything is set up properly (SPA server roles, designating the correct SQL Server name, databse, and account the Data Collector jobs will run under, etc.) is it enough to just designate the database name and SQL server name and expect that SPA and SQL on the Report server will create the tables first time the Transfer data is fetched from a remote SPA Data server?
I have zilch experience with SQL but did quickly figure out how to enable TCP and Named Pipes. I do see in Event Viewer that the SPA Data Server is successfully logging on to SQL Express each time I manually start a collection job, but the data never leaves the Transfer folder on the SPA Data Server.
I created a new database in SQL Express and ensured that is the db name the job is supposed to send its data to. I am wondering if SPA is expected to create the tables in that database with the first upload of data, or if I'm supposed to do more than just create an empty database?
Tom, check the SPA CHM file, that has the exact steps you need to get the SQL trending working.
