'Database Mirroring'에 해당되는 글 1건
- 2009.09.28 미러링::Error: 1479, Severity: 16, State: 1.
2009. 9. 28. 14:47
미러링::Error: 1479, Severity: 16, State: 1.
2009. 9. 28. 14:47 in Database Mirroring
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.
<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.
Prev
