2009. 9. 28. 14:47

미러링::Error: 1479, Severity: 16, State: 1.

SQL SERVER 2005 이상


미러서버의 네티워크 사용량 증라고 미러링이 재개되지 못하는 경우. 

 

Database mirroring sessions may stop intermittently in SQL Server 2005

http://support.microsoft.com/default.aspx?scid=kb;en-us;959006&sd=rss&spid=2855

 

select is_send_flow_controlled column , * from sys.dm_db_mirroring_connections dynamic management

is_send_flow_controlled column  컬럼이 1 이면 네트워크 사용량이 많은거다.

 

(미러서버)

 

<Date><Time> spid16s Error: 1479, Severity: 16, State: 1.
<Date><Time> spid16s The mirroring connection to "<EndPoint>" has timed out for database "MSS" after 120 seconds without a response. Check the service and network connections.
<Date><Time> spid16s Database mirroring is inactive for database 'MSS'. This is an informational message only. No user action is required.
<Date><Time> spid16s Restart packet created for dbid 5.
<Date><Time> spid22s Restart packet processing for dbid 5.
<Date><Time> spid22s SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
<Date><Time> spid22s SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
<Date><Time> spid22s SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
<Date><Time> spid22s Starting up database '<Database name>'.
<Date><Time> spid22s Bypassing recovery for database '<Database name>' because it is marked as a mirror database, which cannot be recovered. This is an informational message only. No user action is required.