Component running slow


Attached query is running slow , approx 3.5 hours on one of our reporting server running:

SQL server 2005, with 10 GB of RAM, on win 32 bit 2003 with AWE enabled.

This would be the enterprise edition.

Database in question where query is being run is 180 GB data +150 GB indexes.

Therefore i am trying to figure indexes sitting out there if that worthy of that size, are they good enough to be so, as still the query runs very slow.

Please help for any suggestion on how should i go ahead with tuning this.


avatar image By SQLDB 60 asked Oct 05, 2015 at 02:54 PM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Oct 08, 2015 at 07:16 PM

Please go to Help > Check for Updates and make sure you anonymize your plan using the latest build of Plan Explorer (which allows us to see the query text as well). Also, please update statistics on all involved tables, since it seems that SQL Server estimated close to one million rows but returned less than 2000. Not that you can hope for a lot - with only 10 GB of RAM available on a 32-bit OS, there will almost always be significant battles for memory resources, shuffling 330 GB of data...

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

We are Moving!


Follow this question



asked: Oct 05, 2015 at 02:54 PM

Seen: 121 times

Last Updated: Oct 08, 2015 at 07:17 PM