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.
aaron-macleodAsked:
Who is Participating?
 
aaron-macleodConnect With a Mentor Author 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
 
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
 
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
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.

All Courses

From novice to tech pro — start learning today.