SPA 2.0 (Server Performance Advisor)

[TomK]

As a replacement to the oild PerfMon, SPA is a very good monitoring tool. I
am currently running SPA Data Collector scans daily on some servers which
send their data to a dedicated SPA Report server. Now I want to graduate to
using SQL so that I can ty out the SPA Trending feature.

The Help File item for Trending is fairly brief:
"To set up trending, right-click a data collector group, and then click
Properties. Under Report Trending Database, type the name of the SQL database
where you want to store the trend data, and then type the NetBIOS name of the
SQL server that hosts the database."

I set up SQL Express 2005 on the Report server and have done the above, but
I'm sure there must be something else I must do above and beyond just
creating an empty table in SQL Express that the SPA data is pointng to. No
data as of now is being sent to SQL Express. I of course did not create any
tables (just a new db) as I was hoping that the first batch of data sent to
SQL would create the db strucutre, but that did not happen. Does anyone know
what I must do to get that SPA data into SQL?

 

[Olivier MATROT]

RE: SPA 2.0 (Server Performance Advisor)

Hello,
Did you find a solution yourself on this issue ?
TIA.

Olivier MATROT.

"TomK" wrote:

> As a replacement to the oild PerfMon, SPA is a very good monitoring tool. I
> am currently running SPA Data Collector scans daily on some servers which
> send their data to a dedicated SPA Report server. Now I want to graduate to
> using SQL so that I can ty out the SPA Trending feature.
>
> The Help File item for Trending is fairly brief:
> "To set up trending, right-click a data collector group, and then click
> Properties. Under Report Trending Database, type the name of the SQL database
> where you want to store the trend data, and then type the NetBIOS name of the
> SQL server that hosts the database."
>
> I set up SQL Express 2005 on the Report server and have done the above, but
> I'm sure there must be something else I must do above and beyond just
> creating an empty table in SQL Express that the SPA data is pointng to. No
> data as of now is being sent to SQL Express. I of course did not create any
> tables (just a new db) as I was hoping that the first batch of data sent to
> SQL would create the db strucutre, but that did not happen. Does anyone know
> what I must do to get that SPA data into SQL?
>
>