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

SQL service

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
aaron-macleod
Asked:
aaron-macleod
1 Solution
 
tigin44Commented:

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
 
SharathData EngineerCommented:
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
 
aaron-macleodAuthor Commented:
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
 
Rajesh_mjCommented:
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
 
aaron-macleodAuthor Commented:
Not necessarily the solution but worked for me
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

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