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 |
|
bluecjh
Starting Member
7 Posts |
 Posted - 2006-04-10 : 07:44:44
|
| I am running a large query against a testserver and am the only user, this queryoriginally ran at about four minutes but as the days goby is running slower. - half an hour yet the queryhas not materially changed.Given that i am the sole user of this serverwhat are the likely reasons (query performance aside)that the server is slowing up?many thanksChris |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-10 : 08:36:27
|
| At a guess: Statistics not updated, indexes not defragmented (if you've added, or deleted, lots of rows). If you are using Stored Procedures possibly the SProc needs re-compiling too.If the server runs continuously, and you are in a position to do so, stop-start SQL Server and see if that helps - if it does then you need some routine maintenance for Statistics / SProc recompile, etc. - as a More Professional Solution that "Lets just reboot and see what happens!!"The reboot won't help with the index rebuild/defragment issue, but if it helps it will point at the Stats/Recompile as being the issue.Kristen |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-10 : 08:38:08
|
| try any of the following, without knowing what the query is and considering you're the only user as you stated...reindexrecompile sprocsarchive data--------------------keeping it simple... |
|
|
|
|
|
|
Server seems to be slowing up