sql server reporting services: Trouble with Reporting Services on Performance Monitor data -- sql server reporting services

Trouble with Reporting Services on Performance Monitor data

Peter Ordal
11/16/2004 1:59:14 PM

sql server reporting services: Hi,

I'm having a lot of trouble using Reporting Services to handle data from the
Performance Monitor on Windows Server 2003. This stems from the way
Performance Monitor logs timestamp information. It puts its CounterDateTime
information into a character field, and appends a weird ASCII character onto
each entry.

I've managed to get the ASCII character off during the SELECT using a LEFT
operation, but now I cannot format the date time information correctly on my
graph. The x-axis of my CPU performance graph has datetime info that looks
like:

2004-11-10 13:56:32.332

I want something more eye pleasing, such as "11-10 8pm". The problem is that
the format codes that usually work (in the properties pane under x-axis) do
nothing - e.g. if I put in "MMM dd" I will literally get a series of labels
that read "MMM dd" (no substitution). Again I think this is because the
information is stored as character data, although I can't be positive. The
exact same procedure worked fine on the Orders table in the Northwind
database.

RE: Trouble with Reporting Services on Performance Monitor data

Peter Ordal
11/17/2004 9:11:01 AM

Got a tip from a friend and figured it out. I just used CAST(expression AS
datetime). It's "supposed" to be an implicit cast (see the chart at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_tsqlcon_6lyk.asp) but I guess it just needed a little force.

Cheers,
Peter

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.