Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL service

Posted on 2011-02-22
5
Medium Priority
?
216 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
[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
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 41

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
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 …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

722 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