1-Check this SP_WHO2 for Processes which those are going to hang as on runnable state or suspended

2-Query

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

cross apply sys.dm_exec_sql_text(sp.sql_handle) st

order by sp.cpu desc

TOTAL CPU physical and...

Do you have any history purge job and did the last full backup done successfully

Regards,

Syed Jahanzaib Bin Hassan

MCTS|MCITP|OCA|OCP|OCE|SCJP|IBMCDBA

My Blog

http://www.aureus-salah.com

Check SQL Server service account is enable or not which one you are giving at the time of sql server installation,if this account is disabled then you cant install sql...

Start with clustere installation,it will require new IP and cluster name nothing else DTC and Qurum should be same as Old one

Accessible as

CLUSTER IP\NAMED INSTANCE

CLUSTER NAME\NAMED INSTANCE

Remotely Access

CLUSTER IP\NAMED INSTANCE,PORT

CLUSTER...

you have required 1 DTC and 1 Qurum in Active\Passive,Microsoft is not providing till any load balancing solution in cluster which one you are saying ACTIVE\ACTIVE,NLB Server is there for...

Best practice for the SAN Partitions are

DATA 1

INDEX

LOG

MSSQL

DTC

QURUM

you can increase the partition as

DATA 1

DATA 2

INDEX 1

INDEX 2

LOG 1

LOG 2

BACKUP

MSSQL(For SQL binaries)

DTC

QURUM

DTC and Qurum should be seperate group

Regards,

Syed Jahanzaib...

Transactional and snapshot Replication is best for your scenerio but mirror cant be use because you cant query to the secondary node if primary node is mirroring , 1 node...

Transactional Replication is best for your senerio

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

Public Role is just a gateway for the Server and database level after you assign the public role then you assigns other role also

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP |...

1-Table should have a Clustered Index

2-Non-clustered Index should be SORT_IN_TEMPDB = ON

3-create non-clustered with this column also pt03_annomese

CREATE NONCLUSTERED INDEX IX_SalesOrderDetail_filtered

ON VIPT_TAB_003 (PT03_R_ABI, PT03_NUM_EFF,pt03_annomese)

Include (PT03_KEY_RAP,

PT03_KEY_AN,

PT03_SKEY,

PT03_NDG,

PT03_R_CSER,

...

I will continue with PATRICK FIEDLER code

--create table #tmp(temp varchar(50)) --this table is your permanent table you remove this line

create table #tbtemp (orderid int identity(1,1), temp varchar(50))

--insert into #tmp...

Use [database name]

go

add this in the begining of the code and then check

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

Its depend on Execution Plan create by the optimizer which index will be use,It depends which query you are passing to the optimzer just create the query and then check...

you can create indexes script by the help of Generating Scripts

Right click on the desire database and then click TASK then click Generate Scripts,Select all tables then generate only indexes...

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

cross apply sys.dm_exec_sql_text(sp.sql_handle)

check this query to find out the problem

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA