Am running BO XI 3.1 on SQL 2008 (Express version) on a Windows 7 VM.
THe report is taking 45 mins to load approx.
Are there any fine tuning capabilities inside or outside BO (settings etc) I could tweak to speed it up a bit.
Note its only running on SQL Express as thats all I have to try at the moment. Been told that as its on a VM it doesnt really make any difference.
When you say it’s on SQL Server 2008, is that the BO install or the target reporting database?
If it’s the reporting database that’s virtual then there are several factors including, but not limited to, the following:
Amount of available memory
Number of rows being searched through
Indexing
Join types (both in terms of outer/inner and join expression and data types - inner joins on indexed integer columns work best)
Nested selects - you may want to look at replanning your database design if you have a lot of nested selects
Post the SQL in here and also have a look at the Explain Plan in SSMS
Extract the SQL from the report (either by tracing or ‘show SQL query’).
Paste it into query analyser.
Check the execution time.
If it`s 45 minutes, either the SQL statement structure or the DB setup (either logical level - indexes etc or physical - hardware\software) is at issue.