Actually TCP/IP is always faster for us and when we switch from Named Pipes to TCP/IP it usually solves the performance issue.

Check if SQL Server Service Account has "Lock Pages in Memory" rights on the server.

I am not sure if you can find corrupted catalog throught the SQL query, but if there is any corrupted full text catalog you will get errors in Application Log.

This blog has information you are looking for: http://blogs.msdn.com/b/sqlblog/archive/2006/10/06/msdtc-and-sql-server-on-a-cluster.aspx

You shouldn't delete default trace files. SQL Server overwrites oldest file when required, so you shouldn't worry that your disk will fill out with old trace files. If you monitor...

Check if your SQL Server has maximum connections number set. Possibly it reached this number and then when some sessions closed it returned to normal.

Also, if default trace for that...

You can setup replication as one of the options. Set filter on tables to limit rows that will be replicated. I don't think this is the easiest way, but could...

I just set this today for one of our databases:

1) Backup transaction log before indexes optimization

2) Move database to the bulk-logged recovery mode

3) Reorganize indexes

4) Move database back to full...

This will work if you use table variable instead of temp table:

EXEC sp_executesql @statment = N' DECLARE @t1 TABLE

(

ID int

)

insert @t1

select 1

select * from @t1'

You can probably get a little bit advantage for database "A" if you create indexes on this database with SORT_IN_TEMPDB Option (http://msdn.microsoft.com/en-us/library/ms188281.aspx).

You can use SQL Server Profiler -> Deadlock graph Event. It will give you information about objects and statments.

If both of your SQL Servers use default port you will need to open these ports between two servers. I mean that you don't have to open any specific ports...

If alerts used to notify - you can increase "Delay between responses" option using alert's property.

No need to rename the groups as SQL Server will use groups SID.

You can try to set up alias on client computer using cliconfg.exe utility. Use old server name and new IP address. This may work without DNS changes.