Did you restrict the SQL Server or not with Max Memory parameter if not then it can use more memory , 100 GB RAM is too high, what is the...

Make a resource pool with the help of Resource Governor for the specific user and then login with it and then update the statistics

Q4 - disk dependancies -...

Backup file and Restore path is Same ?

otherwise check Activity Monitor on SSMS and query with sys.sysprocesses to check the wait resource at the time of Restore

There are multiple disk use to make a single partition or drive with the help of RAID levels,Cluster is use for High Availability if 1 node fail then second node...

I didnt use this Whatsup Gold Network Management Tool but it have a application monitoring module,I can say if you disabled the service this tool check the service after some...

Raid 10 is better than Raid 5

Raid 10 is specially use for Tempdb,Log Files and Indexes Files,If you have enough space on these disk then go to RAID 10 other...

yes you can install but one is default instance and other must be named instance

Latest APR 29,2011 Cummulative Update 7 for SQL Server 2008 R2 is available now

http://support.microsoft.com/kb/2507770

you can install multiple clients of different version

Madness.

Repairing master (even a copied master) is unlikely to work. Most of master are system objects (all of master should be) and if there's something wrong severe enough to prevent...

Can you connect on the same Server with SSMS ?

SQL Server 2008 or SQL Server 2008 R2,client and server both are ?

If client is SQL Server 2008 and Server is...

Which Version of OS and SQL Server you are using and Total Memory and allocated memory for SQL Server

Have you applied update Service Packs and Cummulative Updates,if not then apply...

SELECT ST.TEXT,SP.* FROM SYS.SYSPROCESSES SP

CROSS APPLY SYS.DM_EXEC_SQL_TEXT(SP.SQL_HANDLE) ST

WHERE SPID > 55

ORDER BY SP.CPU DESC

this query provide you information about the bottleneck

you should use local server to remote server login mapping in linked server properties as shown in the figure