Doesn't sound right.

Try and connect remotely from your PC (using Enterprise Manager) and see if it is still not responding (there may be an issue with MMC on the server).

It's...

What are your database growth settings?

You should create a dump device that points to the remote server, then backup to the dump device.

I'm not sure- windows admins don't seem to defragment drives on a regular basis (like they did in the past). The attitude I have heard from some was that they...

Are you talking about the ODBC driver on the Windows 2003 server? If so, I don't think you can.

In Windows 2000 and below you could change the MDAC version, but...

btw, I just have this scheduled each night as SQL Agent job.

I have the same problem with one of our SQL 2005 servers.

As a work around, I run:

declare @dt datetime

select @dt=getdate()-1

EXECUTE master.dbo.xp_delete_file 0,N'BackupLocation',N'BAK',@dt,1

this has worked perfectly for...

You can get tool (such as diskkeeper) that can defragment SQL files when they are in use.

I'm not sure why windows admins don't see the need to defrag drives anymore-especially...

I'm no Windows administrator, but I suppose you would need a fiber card for the server to talk to the SAN.

There is no specific configuration needed in SQL Server to...

Same goes for your transaction logs- you need them on a faster disk also.

I would run the best practices analyzer against the server- it will give you a wealth of...

If I were you, I would move the tempdb off RAID5 as a priority. Even if it's not the cause of your current performance issues- it will be in the...

Without more information, a couple of things I can think of to check:

make sure you have multiple tempdb data files (one for each processor) on a fast disk. The IO...

btw, the same method works for the data file as well as the log file.

This method saved me hours when I moved databases to the SAN:

http://sqlcat.com/msdnmirror/archive/2010/04/05/moving-the-transaction-log-file-of-the-mirror-database.aspx

Fantastic that mirroring doesn't need to be broken (if you are using it)...

Mirroring doesn't actually use the transaction log (from what I understand).

The transactions are applied to the principal and the mirror database. This is different from log shipping which actually...