Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 timeout

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2012-06-26 : 06:19:53
I am trying to findout why even a simple select query takes a very long time to return data in the machine.
There are the same number of records as before and the select queries used to run fast before but not now.
Any thoughtst please?
Thanks

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-06-26 : 06:39:57
Have a look at the query plans.
Could be poor statistics/indexes or just reached a threshold where the optimiser has decided to use a different query plan.
Also look to see if there is a rogue process that is using up the disk io or cpu and stopping everything else from working.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2012-06-26 : 10:47:31
Solved by re-starting machine.
Thank you
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-06-27 : 01:53:08
It is worth checking your memory configurations , now that you've rstarted the server.
Is the correct memory allocated to the SQL Server? are there other programs utilising memory , causing a constraint.


Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2012-06-27 : 06:55:25
Not sure how to check.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-06-28 : 01:47:37
In SQL Server - on a query window - use sp_configure (assuming you have the permissions) . There will be details about the Max and Min Memory set for the SQL Server. How does this relate to the overall memory available on the server?
As well as memory check IO response times

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -