Re: Performance dramatically improved after reboot of server
From: fn (f_n_a_c_e_r_removeunderlines_at_hotmail.com)
Date: 06/25/04
- Next message: Colin Basterfield: "DTS"
- Previous message: mike: "Performance dramatically improved after reboot of server"
- In reply to: mike: "Performance dramatically improved after reboot of server"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Jun 2004 18:37:00 -0600
Too many possibilities and not enough data. Did you look at SQL Server
processes before rebooting to see if there were any errant processes or
jobs running? Did you try "rebooting" SQL Server before rebooting the OS?
My guess is that the indexes did it. Drop them and run the task. If it
goes back to 14 hours, you'll know what you did. If not, hope that the
problem won't reappear.
FN
mike wrote:
> A task went from 4 hours to 14 hours immediately after an upgrade to
> our custom app. I was working on the cause when we decided to try a
> reboot on the server. The runtime went to 2.4 hours. I also added
> some indexes a day prior to the reboot....
>
> So my question is any real explaination for the change in runtime.
>
> Mike
- Next message: Colin Basterfield: "DTS"
- Previous message: mike: "Performance dramatically improved after reboot of server"
- In reply to: mike: "Performance dramatically improved after reboot of server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
