August 5, 2010 at 3:22 pm
Hello,
I have an ASP.NET application that uses an Sql Server 2008 database.
When a 5 minutes report is running the other queries coming from other pages of the application from different sessions are very much slowed down 'til geting timeout error. I mention that the stored procedure that is running behind the report is using data from a lot of tables (around 10 tables) and the amount of data is big, around thousands of records and ofcourse the paralel queries are inserting/updating/selecting data from the main table which is used in the report.
Can you give me a solution for this problem or at least an explanation why is this happenning.
The queries that insert or update may use transactions.
Thanks.
August 5, 2010 at 3:34 pm
You should consider READ_COMMITTED_SNAPSHOT isolation level as well as moving your reports to a different server that gets replicated to.
If you want additional help, please post your queries as well as DDL for the tables. We'll need to look into indexes. But I'd start with the isolation level change and/or replication as that's pretty standard in 2005/2008 for reports.
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
Ramblings of a DBA (My SQL Server Blog)[/url]
Subscribe to my blog
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply