Increase the RAM gradually,First check the requirement of the instance with this script

select * from sys.dm_os_performance_counters

where counter_name like 'page life%'

If this value is less than 3000 then you should increase...

yes offcourse,I didnt mentioned that is the only solution

Try to achieve Index Seek because Index seek is better than index scan

and Included columns are best choice because in the Tree of index ,it gets the whole information from...

What does parallelism have to do with this in any way?

What query hinting would you do when removing a function call and getting indexing setup properly?

Why would you recommend to...

have you done routine maintenance of the database ?

Its good there is no any IO

For Disk Delays

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

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 'avg_write_stall_ms'

,io_stall_read_ms + io_stall_write_ms as io_stalls

,num_of_reads + num_of_writes as total_io

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

Its depend on job description of your designation in your organization

Jr.DBA will cover 1st Level Support

Sr.DBA will cover 2nd and 3rd Level Support

In some cases 3 Level support provide...

Active/Active means in term of microsoft multiple instances on mutiple nodes and it follow round robin algorithm for fail over,there is no any Load Balancing like Oracle RAC

Active/Passive means,fail over...

Create Active/Active cluster installation of SQL Server,its mean multiple instances on more than 1 node and then create merge replcation between these instances and then use network load balancing NLB...

If you have multiple processors then use

MAXDOP query hint option in the end of the query

how to apply query hint then visit on this link

http://aureus-salah.com/2011/02/25/sql-server-query-hints/

New Installation is a better option

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

manual log shipping

For Disk Delays

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

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 'avg_write_stall_ms'

,io_stall_read_ms + io_stall_write_ms as io_stalls

,num_of_reads + num_of_writes as total_io

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

First find the bottleneck then apply changes