Solved

SQL service

Posted on 2011-02-22
5
210 Views
Last Modified: 2012-05-11
Can anyone tell me where the settings might be to fix a timeout error on my database for a small query and what setting would start to make my database run really slow.
0
Comment
Question by:aaron-macleod
5 Comments
 
LVL 26

Expert Comment

by:tigin44
ID: 34958568

query timeout can be effected by the "query wait (s)" setting of the sql sever... to set it to endless value run the script below.

sp_configure 'show advanced options', 1
reconfigure

sp_configure 'query wait (s)', -1
reconfigure

sp_configure 'show advanced options', 0
reconfigure

By the way... the performance of the sql server can be effected by many parameteres. CPU, RAM, disk subsystem, other running processes, sql server settings.. Each should be examined and evaluated...


0
 
LVL 40

Expert Comment

by:Sharath
ID: 34958572
Are you getting timeout error while executing a query in SSMS? Are you referring any remote queries (linked servers queries)? If you are referring remote query timeout, check here after connecting to a server in SSMS.
1) Right click on Server
2) Properties -> Connections
3) Change Remote query timeout to 0 (no timeout)
0
 

Accepted Solution

by:
aaron-macleod earned 0 total points
ID: 34958614
Ok i have runt task->Shrink

it doesn't seem to have change the size much but a 1m53s now returns instantly like it should have.

can some one explain what this acctually does to the Database.
0
 
LVL 6

Expert Comment

by:Rajesh_mj
ID: 34958966
Please try using a simple query and see if there is any problem. If the problem is with current query, then we need to check index and statistics things.
0
 

Author Closing Comment

by:aaron-macleod
ID: 35005104
Not necessarily the solution but worked for me
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

816 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now