I do have the indexes scripted so I can recreate them. But it appears that things are now running fine, after running DBCC FREEPROCCACHE. Not sure if its...

FYI - It's reporting services 2005.

I'm well aware how forums work, I always appreciate any information I receive here. Just hoping someone has experience with this issue.

Thanks!

:smooooth:

bump - please ....

Just another followup,

The issue I'm investigating it a lot of network IO wait time. This query executes 25,000+ times per day and at seemingly 1 MB per execution we're...

Jeff,

Thanks for mentioning Partitioning. I've never actually implemented it before. I'm now doing some research and reading. Here is my plan; just testing now....:-)

I have data...

Thanks for all the feedback. I think I have a good strategy in place, we have nightly full backup to local disk and then 30 days of backups (file...

Thanks for all the feedback. I think I have a good strategy in place, we have nightly full backup to local disk and then 30 days of backups (file...

Maybe this will help someone else....

I found this quote on Ola Hallengren's site (http://ola.hallengren.com/frequently-asked-questions.html) discussing running T-SQL job steps;

"The stored procedures must be executed in a CmdExec job...

Here's a bit more information,

The two sp's are vendor supplied. They have given me the 2 procs and when they run in Management Studio they run exactly as expected....

Sorry for the lack of info. The issue being that there are two very long stored procedures involving hundreds of tables. I think my issue is more of...

Thanks Jeff - It's Standard Edition. I'll add the clustered index tomorrow on EventTime and look into indexed views.

Once I have something to report I'll update the...

Yes the oldest data is rolled off using the column EventTime. Thanks!

Thanks for the replies. There isn't a natural primary key on the table - no column is really unique now. To add one I would have to create...

Attached is the execution plan;

Another issue is that no the old session variables are not aged off. The table has 10,000,000 + rows.