Create Clustered index and check the result

Clustered Index seek must be there in the execution plan

check all IPs and port of all instances should be different and not default(for the security reason) , you can check these stuff in the SQL Server Configurations Tools

Instance Protocols

Client...

there is no any SQL Cluster,In the installation of SQL Server Cluster,it use the windows cluster,so you will create first Windows cluster and then install the SQL Server on Cluster...

Create new FG and create 1 File in it and then move all non-clustered indexes in this FG then your master file and file group size will be reduce also.

You...

For 100% surity then you have to test the backup file to restore on the test server

Avoid shrinking the database if possible as Gila mentioned and follow this dynamic management function

For Rebuild Indexes

==============

Select * from sys.dm_db_index_physical_stats(db_id('your database'),null,null,null,null)

where avg_fragmentation_in_percent > 30 and page_count > 1000

apply rebuild indexes...

Same version will be work for the logshipping and what are errors in replication

Why do you not come to the new version with these steps,if you want to come...

Own unlimited Log shipping process

http://aureus-salah.com/2011/05/10/sql-server-logshipping-issue/

If both cores access the same file at a time second core will be on wait,if you have multiple...

If Node 1 running max memory parameter setting is 32 GB and Node 2 max memory setting also 32 GB

If Node 2 down and second instance move on Node 1...

Use SQLCMD then create a batch script with SQLCMD and then schedule with Operating System Scheduler,SQLCMD is available with Express edition also

Usage of SQLCMD

http://msdn.microsoft.com/en-us/library/ms162773.aspx

select * from sys.dm_os_performance_counters

where counter_name like 'page life%'

Result of this query?

Are you using packages to take the Tlog Backups and how many drives not partition you have and how many cores of CPU you have in a machine

Its mean your IO system is busy and delays provide me result of this query

use [your database name]

Go

select DB_NAME(database_id) DB_NAME, di.file_id,df.name,io_stall_read_ms ,num_of_reads

,cast(io_stall_read_ms/(1.0+num_of_reads) as numeric(10,1)) as 'avg_read_stall_ms'

,io_stall_write_ms,num_of_writes

,cast(io_stall_write_ms/(1.0+num_of_writes) as numeric(10,1)) as...

another solution is Stop the Agent Service if jobs are not critical and you can restrict the SQL Agent service account to access the replace database