Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Environment: Windows 8.1, SQL Server 2008 R2 Express database, SQL Server 2008 R2 BIDS Database: Performance counter data collected on client servers. The particular values involved in this question are % Processor Time and Batch Request/sec.

I did not start this report from scratch. I am actually just modifying one Allen White provided from his TechEd 2010 session that you can find here. I am using the same table structure with a few modifications to column names and such for my liking, pretty much the same other than that. I also added some filter/parameters into the report because I have multiple servers in this database.

I take the RDL file and import it into my SSRS project. Modify the procedures and column names to match my setup. I noted the format of the graph to be a simple line graph: enter image description here

The border for each series is set to a solid line style with 2pt line width, no shadow. I don't see why I don't get a pretty line versus this. Is there some format setting I am missing? It has been sometime since I have tried setting up graphs in BIDS. enter image description here

share|improve this question
Could it be that your data is pants? That or your bottom axis is too scrunched. If you do a top N (something in the tens) for your query sources, does that make it look less bad? – billinkc Nov 17 '13 at 2:42

Always enjoy getting help from this site... Thanks to @billinkc.

I had the thought in the back of my mind that maybe the graph had to much data to display but guess it never clicked.

I modified the graph's Category Groups to be an expression for grouping by the hour not just the full date value: =Hour(Fields!CapturedTime.Value)

That allowed the graph to be prettified into this: enter image description here

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.