I have a W2K3 server with SQL 2005 on it. Our financial database was moved
to this server from another, slower server, and immediately I had users
responding that their application would throw network errors. In addition we
have a custom, in-house application that will receive query timeout errors on
this system. I know it's not anything in the physical network or the
physical server because I've replaced all of that, including moving the disk
drives to another idential hardware platform and the problem persists.
Why am I posting in the Windows newsgroup instead of the SQL newsgroup?
Because when I was transferring the database files over to this new machine,
I noticed that the time remaining would be decrementing just fine, but then
all of a sudden jump to 1000 minutes, etc. So I fired up the task manager
and watched the network performance and it would just drop to a bare minimum
level for a couple of minutes, and then jump back up to normal. At the same
time it jumped, the time remaining on the file transfer would go back down to
where it should be.
With that in mind, I'm thinking it's something in Windows, not SQL. The
event log shows nothing at all that would be an issue. All the drivers have
been updated. I'm kind of at a loss as to where to even start looking. I
would welcome any suggestions.
|
Similar Threads
Linear Mode
