Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_server_dba
Posting Yak Master
167 Posts |
 Posted - 2012-05-24 : 21:14:21
|
| I am totally new to reporting services and trying to figure out how to create a report with the row count of a table at specific intervals of a day. So what i am trying to do is i have a table which is highly transactional(it has inserts, deletes) and wanted to find out the count of it for every 30 minutes and represent it on a report server with in a graph. How can i do that? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-25 : 10:25:38
|
| sounds like what you want is schedule a sql server agent job which populate a table with your required count value. Then you can create a report to show this value and add a subscription to make it render at required intervals automatically with latest count value from table------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sql_server_dba
Posting Yak Master
167 Posts |
Posted - 2012-05-25 : 11:51:41
|
| Can't we do this with out creating any table by directly running a query for every 30 minutes? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-25 : 15:35:46
|
quote:
Originally posted by sql_server_dba
Can't we do this with out creating any table by directly running a query for every 30 minutes?
why do you want to simply aggregate entire data each time? By having an intermediate table you'll only need to do aggregation for deltas (changes) since last run (ie last 30 minute period). Running it on the fly mean you aggregate entire data each time which would be bit of performance bottleneck with all thode high freq large DML operations (insert/update etc) happening in parallel.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Simple count in a report