Solved

SQL service

Posted on 2011-02-22
5
209 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
Comment Utility

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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Not necessarily the solution but worked for me
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

763 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

6 Experts available now in Live!

Get 1:1 Help Now