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

Query timeout on SQL server suddenly appearing

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
grwallace
Asked:
grwallace
  • 3
  • 2
1 Solution
 
celazkonCommented:
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
 
grwallaceAuthor Commented:
An index already exists for the query - I a concerned that there is data corruption or something of that nature
0
 
grwallaceAuthor Commented:
No relevant answers
Grad C as nothing satisfactory
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
lcohanDatabase AnalystCommented:
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
 
grwallaceAuthor Commented:
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
 
lcohanDatabase AnalystCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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