[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL report services

Posted on 2013-06-14
6
Medium Priority
?
347 Views
Last Modified: 2013-06-20
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
Comment
Question by:atorex
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 13

Accepted Solution

by:
Jesus Rodriguez earned 1000 total points
ID: 39249274
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
 

Author Comment

by:atorex
ID: 39249896
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
 

Author Comment

by:atorex
ID: 39253136
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 13

Expert Comment

by:Jesus Rodriguez
ID: 39263395
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
 

Author Comment

by:atorex
ID: 39263434
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
 
LVL 13

Expert Comment

by:Jesus Rodriguez
ID: 39263452
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 Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question