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...

Thanks for reply

I do have a question though.

Server OS’s are x64, and even though I have set the value for LPIM with the service account, I have never seen a...

TotalServerMemoryMB - 3270.125000

For the Lock page memory enable

---------------------------------

Lock Pages in Memory is a setting that can be set on 64-bit operating systems that essentially tell Windows not to swap out...

Thanks for your valuable reply. I hope, i am going to correct path for fixing memory related issues.

As per memory overivew result in production server as below

PhysicalMemoryGB - 8.00

BufferPoolCommittedMemoryGB...

Thank you for replay

Yes, I have enabled Lock page Memory in Local policy setting.

Now Performance Tap showing 4.55 GB after SQL services restarted on yesterday..

Sqlservr.exe using 103 MB for current...

Thanks for your replay...

Mr. Jeff comments is good method stoping IIS services instead of using single user mode in database side.

I have done migration activity last weekend and application aslo...