Solved

Query timeout on SQL server suddenly appearing

Posted on 2011-09-08
6
471 Views
Last Modified: 2012-05-12
I have an installation with two Dbs which should be identical in structure on the same SQL Server running two different companies. One of these is significantly larger than the other.

On the smaller of the two timeout errers have started to appear on queries which return results instantly to the users of the  other Db which has about 4 times the number of rows in each table.

Something is wrong but I don't know where to begin. I have tried copying the query to a file and running the tuning advisor but it comes up with Error Unable to open input file on the Consuming Workload section.

Any ideas?
0
Comment
Question by:grwallace
  • 3
  • 2
6 Comments
 
LVL 7

Expert Comment

by:celazkon
ID: 36501687
Don't forget to create an index on the tables involved in the timing-out query. This will greatly enhance performance of the sql query
0
 

Accepted Solution

by:
grwallace earned 0 total points
ID: 36501728
An index already exists for the query - I a concerned that there is data corruption or something of that nature
0
 

Author Closing Comment

by:grwallace
ID: 36527877
No relevant answers
Grad C as nothing satisfactory
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 39

Expert Comment

by:lcohan
ID: 36505682
indexes and statistics are not self maintained so sometimes you need to do a rebuild index and see SQL BOL for that or simply run:

update statistics table_name;
exec sp_recompile table_name;

to refresh stats and flush out of cache all old plans tied to the table_name.
0
 

Author Comment

by:grwallace
ID: 36506121
I had to raise a call to Microsoft to fix this one at a cost of £199. It is now solved with their help.The problem was due to due to a process locking out my query. Unfortunately there were no comments which were helpful of pointed me in that direction from Experts Exchange
0
 
LVL 39

Expert Comment

by:lcohan
ID: 36506196
that was costly and for the future keep in mind - SQL Activity Monitor and SP_WHO2  or SP_WHO stored proicedures can reveal that at no cost to you.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql query 107 66
sql help 8 55
SSIS package is taking too long time to load when i open. Is there any configuration to stop this validations? 3 32
migrate a SQL 2008 to 2016, 2 30
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

825 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