Just open your ssis packages on BIDS version 2008 R2
X64 mentioned in the result of string
SQL Server Setup check the OS bit Version automatically in the end of the left pane of setup you can check it X64,x86 and IA64
SELECT ST.TEXT,SP.SPID,WAITTIME,LASTWAITTYPE,CPU,PHYSICAL_IO,STATUS,HOSTNAME,PROGRAM_NAME,CMD,LOGINAME FROM SYS.SYSPROCESSES SP
For Security reason you will not use the default port and use 1 port for 1 instance,you can change with the help of SQL Server Configuration Tools
It depends on the Data also,in the past the data was low and in the present data is high ,that might be an issue of time taking
execute this query when it hangs
Select st.text,sp.* from sys.sysprocesses sp
cross apply sys.dm_exec_sql_text(sp.sql_handle) st
order by sp.cpu desc
1 for 32-bit installation of Softwares
2 for 64-bit installation of Softwares
You must enable AWE in 32-bit version with lock pages other wise extension will not occur in memory
Becuase when SQL Server need more RAM then it cant ,Page life will be suffer and physical IOs increase ,your SQL Server Service account must have...
For Disk Delays
select DB_NAME(database_id) DB_NAME, di.file_id,df.name,io_stall_read_ms ,num_of_reads...
What does it mean by Data forever? ,if you mean like there is no end of the query or transaction then that must be a dead lock victim of that process
Certificates can be used to help secure connections, in database mirroring, to sign packages and other objects, or to encrypt data or connections
check and update the storage controller driver
SQL Server 2005 or Later is schema based ,its engine is design to take advantage of new hardware like HARD-NUMA, like multiple Cores etc and SQL...
increase the column length
Separate names with a comma.