No issue at all

Enable AWE 6GB if edition support and add your SQL Server Service account in lock pages memory rights

Database Engine Tuning Advisor and its not available in Express Editions and its a part of SQL Server Management Studio also

No, these both servers can work for as a witness server only and no failover clustering supports available on these editions

Which Installation option have you clicked on the setup of SQL SERVER 2008 R2 ?

have you defined qurum drive in cluster ?

MSDTC and Qurum drive must be define before installation...

Asalam-O-Elaikum Abrar,

Use DTA for queries optimizations and check the Display execution plan and include execution plan this will help you to optimize the queries

For Queries

=========

sys.sysprocesses

sys.dm_exec_sql_text()

For Disk Contention

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

sys.dm_io_virtual_file_stats()

For CPU Contention

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

select ...

OS Version ?

Storage brand and Version ?

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=518d870c-fa3e-4f6a-97f5-acaf31de6dce&displaylang=en

http://communities.vmware.com/thread/250699

paste the error log file and clustered validation file

Your PAGE LIFE EXPECTANCY value is too low,its not lower than 3000,you should have to increase the RAM

1-How much Physical and Logical Processors ?

2-Total Drives not Partitions ?

3-Tempdb location ?

4-SQL...

check with IP Addresses

Check EVENT DATA

http://msdn.microsoft.com/en-us/library/ms173781(v=SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms187909(v=SQL.90).aspx

Check DDL trigger

http://msdn.microsoft.com/en-us/library/ms190989(v=SQL.90).aspx

SP1 CTP version is available

Check coreinfo software a very small application available on

http://www.sysinternals.com

then paste the output of this sofware this will be helpful for hardware Numa also and select distinct memory_node_id from sys.dm_os_memory_clerks

Check...

check the SQL Server Service account rights on SQL Server or OS level too

check cpu usage per query this will be helpfull to optimize the query as well and utilization of the CPU and RAM also

select st.text,sp.* from sys.sysprocesses sp

cross apply sys.dm_exec_sql_text(sp.sql_handle) st

order...