SPA 2.0 (Server Performance Advisor)

[Guest 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?

[Guest 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?

>

>