No Need to restart on the Second named instance

If you see Page Life Expectancy is less than 300 seconds then you have to increase the physical memory or RAM , if physical RAM is low then physical IOs...

you are going to create ACTIVE\ACTIVE cluster installation of SQL Server,you have to define the separate resource for the second instance with a new IP

check the locks on the database,if resources or locks are using by queries and taking time to login then enable the ROW Versioning in SQL Server

Partition functions are those functions who partitioning the table data on the defined parameters,Partition Scheme use this function to partition the table data on the define ranges

yes 300 not 3000 seconds or 5 minutes is an avg page life

Performance would be same on different LUN if same group,how many HBA in a Server,it must be 2,you should go for Multi pathing to increase the performance,If you are using...

there is no any affect on the job owner password change on a job because job execute on the OS local or domain account which one we say Service Account...

select * from sys.dm_os_performance_counters

where counter_name like 'page life%'

First check the requirement of RAM with the help of this query,this will tell you about RAM required or not

If this value less...

First of all just check server required more RAM or not with the help of this query

select * from sys.dm_os_performance_counters

where counter_name like 'page life%'

1-Take Full Backup and then restore with norecovery on another instance or Server

2-Wait for the restore process of Step 1 till complete

3-Take application offline and then take Differential backup and...

In this scenerio of cluster and requirement Merge Replication can balance the load you will have 2 SQL Server resource IPs in the cluster then you will configure the NLB(MS...

you should define separately Qurum and MSDTC then you can define 1 Disk for all SQL Server operations now total drives needed

1-Qurum 512MB

1-MSDTC 512MB

1-SQL Server it will depend on the...

try it,it will work

create table abc(id int, name varchar(20),address varchar(250))

insert into abc

select 1,'a','z'

union

select 2,'b','y'

union

select 3,'c','x'

union

select 4,'d','w'

union

select 5,'e','v'

union

select 6,'f','u'

union

select 7,'g','t'

union

select 8,'f','s'

create clustered index idx_abc_name on abc(name,id)

select id,name,address from abc where name='a'...

In the Option TAB of Restore,check the Overwrite on the Exising Database or check the space is available for restore database in the drive you mentioned