Good Morning John,
Thanks for the quick reply :-) I think the report is showing no current data because the alter table, insert into or updates are being blocked when the data first comes into my system. When the data comes in, it goes to the main database which is mirrored. It then gets replicated to another server where it is transferred to the data source for my reports. All of the records are time stamped and the report will show a record from each of my gateways with its associated value. I can see that the gateways are sending the data every minute and replication is working fine so I thought the best place to start was blocking as recently the amount of data we are managing has grown quite a bit sys.dm_os_waiting_tasks
sounds like a great place to look for some info after the fact, which is exactly what I was looking for. I'm also going to look into Adam Machanic's sp_who_is_active
today when I get a chance :-)
Thanks for your help, I really appreciate it :-) I'll post an update when I get a chance in case anyone else is having a similar issue.