Should I run extented event script at production database? is there any restriction?

thanks

ok, thanks for reply... I learned today about traceflag no use, if using exented events in SQL 2008.

Pl. confirm...

Does Background process LOCK MONITOR to handle the deadlock and detect automatically...

Execute the following script in Query Editor to move the tempdb files into a new location:

-- Moving tempdb to a new location

-- Checkout current location and logical names...

Do you have separate physical disks or just logical drives on the same disk set or SAN attached LUNs, etc?

if just different logical drive on the same disk set,...

Ceating many subplan instead of configure any one of the HA method between primary & secondary server.

you need to answer as blow question

what is your server h/w configuration?

how many disk array controller?

what is disk configuration for RAID 0, 5, or 10?

ok, SQL agent side mirror logs jobs running every 3 minites, I understod the next time intervel history logs display those were 0KB, 0 milliseconds, so everything restored at mirror...

No, there is sql trace running for capture error results. I thought application side might be issue? pl. check error page here.

This data and execute statement working fine in SSMS.

whenever call application side working fine at first time, calling next time error throwing like "'Arithmetic overflow error converting numeric... "

Insert statement...

DDL statements...

exec ChangeTable 'SIL_TRAN_H','Tran_Code|Ref_No|Modify_By|Modify_Dt','1003|2012083014645|37100666|17 Sep 2012 12:25:45'

exec ChangeTable 'SIL_TRAN_H','Tran_Code|Ref_No|Modify_By|Modify_Dt','1004|2012083014645|37100666|17 Sep 2012 12:25:45'

exec ChangeTable 'SIL_TRAN_H','Tran_Code|Ref_No|Modify_By|Modify_Dt','1005|2012083014645|37100666|17 Sep 2012 12:25:45'

exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|1|4DA-TE-304A/B/C'

exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|2|30 Aug 2012-14645'

exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|3|JGDTA'

exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|4|FCC/PRU'

exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|5|553'

please find the attached sample data for header and detail table

What does the mirroring status tell you on each occasion for the principal and mirror?

Every occasion for the principal & mirror server status is sychcronized mode.

I assume that DB Mirror environment is configured such a way that it utilizes synchronous mirroring without automatic failover and no wittness.

If the Mirrorred instance doesnt not receive any responses...

Yes, currently default mirroring time out values.

query result

mirroring_connection_timeout = 10

Thanks

one final clarifications, still I am not getting conclusion about LPIM setting.

1.SQL SERVER 2008 on top of Windows 2008 enterprise edition both x86 and x64

2.SQL SERVER 2008 R2 on...