July 30, 2008 at 3:19 am
All baseline tables in DEV and QA have same structure,index and data. These queries execute in DEV within 30 Secs but in QA they were running for 6 hours without returning a single record.
How to Increase the buffer pool
July 30, 2008 at 7:04 am
Why do you think it's related to the buffer pool?
You increase the buffer pool by increasing the amount of memory allocated to SQL server. The amount of memory specified by the min and max server memory is the buffer pool.
That said, is there blocking on QA? Are the execution plans the same? Are the statistics up to date? Are you sure there's no difference in indexes or data? If you look at sys.dm_exec_requests and look at the long running query, what do you see as the last wait type?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 30, 2008 at 7:46 am
Are the servers the same? Do they have the same amount of memory and the same size and number of processors? Like Gail already said, what do the execution plans look like? Also, what are the work loads like? Is there more locking & blocking going on in the QA environment? More users?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply