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.
| 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. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-06-26 : 10:47:31
|
| Solved by re-starting machine.Thank you |
|
|
|
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 |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-06-27 : 06:55:25
|
| Not sure how to check. |
|
|
|
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 timesJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
timeout