• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

SQL report services

Need help tracking an issue with a report that uses MS report services, this report ran ok last week and this week just hangs there with no results.
any ideas how I can track this down, the database it queries is running a live retail system and transactions are being received and we see no issues with any other functionality or database  performance as well as other reports are running with no issues.
This is an important inventory report and I need to get it fixed but am not having any success.

regards,
0
atorex
Asked:
atorex
  • 3
  • 3
1 Solution
 
Jesus RodriguezIT ManagerCommented:
Try to run the query that populated the report outside and check if returns any values. If return values then check the Connection that the report do with the database and the timeout that took for the execution.
0
 
atorexAuthor Commented:
Thanks for the reply, I will get it executed directly on the database, however I dont think connection is an issue several other reports run with no issues.
0
 
atorexAuthor Commented:
I have restored a backup of the database in the lab and I have found something that is causing me some concerns, we have a script we use to re-index all of the databases we have including a much larger database. This script used to take about 2 to 3 hours to run, I executed this script in the lab and it is still running increasing the LDF size by 127 GB (I may have a larger issue here than the report)?
attached is the script, any ideas where I can start looking, I'm lost in this one!!
rebuild-indexes.sql
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
Jesus RodriguezIT ManagerCommented:
Let me suggest you something. Why don't you rebuild the indexes only on the database/Tables that you really needed and also separated as a maintenance plan for each database and not all at once?.

As long as I can see on the script they rebuild the index on every database/table except from the Sql Default Databases
0
 
atorexAuthor Commented:
true, but the issue I'm having right now is exactly what you are suggesting, I'm running just one primary key index on one table only, that process has taken over 24 hours, several weeks back it took less than 20 minutes.

regards,
0
 
Jesus RodriguezIT ManagerCommented:
Did you try to restart the server or the service (SQL Agent) ?, also check the logs of the database to see the size
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now