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 |
|
snaso
Starting Member
21 Posts |
 Posted - 2007-07-10 : 05:31:46
|
| Hello to everybody.I have a big problem with a database server (SQL Server 2000 SP 4) on which I have som DB used by some applications.The operating system is windows server 2003.Now, everithing was running well until the system administrator hase performed a system backup on the server machine. Then he has restored back sql server and now the response time has grown tragically (a complex query with a lot of left join which run in about 10 seconds, now runs in about 6 minutes!)I've checked log files size, space on DB, execution plan of the query, everithing seams ok... Then I've tried to run a maintenance plan to rebuild indexes, but when i try to start i manually, it fails.Do you have any suggestion for solving my problem??Thank you very much in advance.S.-snaso. |
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-10 : 07:15:28
|
| what kind of error do you get when you try to rebuild your indexes?Need an SQLDB consultant?check www.veeningsengineering.nl |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-10 : 07:53:09
|
| If you have a problem rebuilding the indexes then try updating the statistics in the meantime.Was SQL Server restored back to the original machine (if so: Why?!!), or a new machine?Kristen |
|
|
|
snaso
Starting Member
21 Posts |
Posted - 2007-07-10 : 08:12:49
|
| Thank you all for your feedbaks!The error from the maintenance plan was unspecified. I've been able to manually rebuild statistics of each table, but it didn't solve my problem.I've not tried to update stats... I will try.About restore: the server has been backupped in order to have a snapshot in case of big problems to the hardware (I think it's been a ghost). The sql server has been shut down during the backup procedure, then it's been settled back up running.I hope now I've been more clear (sorry for my bad english :)Thank you again,S.-snaso. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-10 : 09:35:57
|
| "I've not tried to update stats... I will try."well, as you have said:"I've been able to manually rebuild statistics of each table"then there is no need, you have already done that.Looks like you made a trial restore to the original machine - as a test of a disaster.So the machine is the same, and theoretically all the data, and database structure, should be the same.So it is unlikely that the hardware is tuned differently - but you may want to check that!Only other thing that I can think of is physical fragmentation of the database files. You could try defragmenting them - I suggest CONTIG.EXE from Sysinternals.Make sure you have a good backup first!Kristen |
|
|
|
|
|
|
|
|
help: performance drop