select from sysprocesses sounds more better.

The average disk queue length shoud not be more than 6 in your case.

Before issuing kill command, you have to verify whether the spid is active or inactive,

you can check it by running dbcc inputbuffer that will return a rowset if the spid...

Sounds like "BUILIN\Administrators" was removed from SQL Server logins.

You have to either add it back or grant 'NT AUTHORITY\SYSTEM' to acces SQL Server with 'sa' privilege.

Have yo restarted SQL Server after running those SPs?

Agreed to Mike. We use LiteSpeed 2005 in DEV/QA/Test systems and the backup performance and compression are excellent. IMCEDA, now is QUEST software claims Microsoft and other large customers are...

Since you have big money, I suggest to get SAN storage for your system. EMC, HP and IBM are the major players. You can get it from DELL too.

if  substring(convert(varchar(20), getdate(), 120), 12, 2) < 14

    @due_date = getdate()

else

    @due_date = dateadd(dd, 1, getdate()

Even tought you have alreay checked the logs, I would suggest you go through hardware check completely.

Go to TOOLS --> External Tools to add.

Do you want to monitor SQL Server failover?

Instead of using the mapping, you can use UNC path like \\servername\sharename\..... in your xp commands.

Mike,

Here there are.

http://support.microsoft.com/default.aspx?scid=kb;en-us;274750

http://support.microsoft.com/default.aspx?scid=kb;en-us;811891

Some of queries do not work well when they run  in parallel. Another option is to add query hint (option(MAXDOP 1) to force the query to run without parallel execution....

Your SQL server is configured to use multiple processor to handle to queries, Turn it off from EM --> Processor --> Parallelism --> Use one processor.