Hi,

I am getting below Logs on SQL Server 2012 DB that uses for the SCOM 2012 R2 

Please suggest what is solution for this issue and what are the other logs that can help me to troubleshoot any issue related to SQL Read/Write/Performance and many more. i am very new for SQL please share the details step by step..

Also is any friendly viewer available to read SQL Logs ?

Date,Source,Severity,Message
07/08/2015 21:57:00,spid11s,Unknown,last target outstanding: 1600<c/> avgWriteLatency 2063
07/08/2015 21:57:00,spid11s,Unknown,average throughput:   0.04 MB/sec<c/> I/O saturation: 18613<c/> context switches 30220
07/08/2015 21:57:00,spid11s,Unknown,FlushCache: cleaned up 3174 bufs with 1844 writes in 571822 ms (avoided 1741 new dirty bufs) for db 11:0
07/08/2015 15:45:53,spid11s,Unknown,last target outstanding: 2<c/> avgWriteLatency 56
07/08/2015 15:45:53,spid11s,Unknown,average throughput:   0.20 MB/sec<c/> I/O saturation: 4432<c/> context switches 4913
07/08/2015 15:45:53,spid11s,Unknown,FlushCache: cleaned up 2992 bufs with 1376 writes in 116475 ms (avoided 493 new dirty bufs) for db 11:0
07/08/2015 15:42:09,spid11s,Unknown,last target outstanding: 96<c/> avgWriteLatency 42
07/08/2015 15:42:09,spid11s,Unknown,average throughput:   1.12 MB/sec<c/> I/O saturation: 10083<c/> context switches 15162
07/08/2015 15:42:09,spid11s,Unknown,FlushCache: cleaned up 14893 bufs with 8195 writes in 103713 ms (avoided 4244 new dirty bufs) for db 10:0
07/08/2015 15:12:07,spid11s,Unknown,last target outstanding: 42<c/> avgWriteLatency 13
07/08/2015 15:12:07,spid11s,Unknown,average throughput:   0.62 MB/sec<c/> I/O saturation: 10548<c/> context switches 14436
07/08/2015 15:12:07,spid11s,Unknown,FlushCache: cleaned up 12639 bufs with 7260 writes in 158412 ms (avoided 8179 new dirty bufs) for db 10:0
07/08/2015 14:37:26,spid11s,Unknown,last target outstanding: 104<c/> avgWriteLatency 59
07/08/2015 14:37:26,spid11s,Unknown,average throughput:   0.22 MB/sec<c/> I/O saturation: 11335<c/> context switches 13337
07/08/2015 14:37:26,spid11s,Unknown,FlushCache: cleaned up 6911 bufs with 5402 writes in 247906 ms (avoided 3999 new dirty bufs) for db 10:0
07/08/2015 14:16:47,spid243,Unknown,Process ID 57 was killed by hostname AWISCDB<c/> host process ID 2548.
07/08/2015 12:18:44,spid11s,Unknown,last target outstanding: 10<c/> avgWriteLatency 43
07/08/2015 12:18:44,spid11s,Unknown,average throughput:   0.32 MB/sec<c/> I/O saturation: 12612<c/> context switches 16744
07/08/2015 12:18:44,spid11s,Unknown,FlushCache: cleaned up 11250 bufs with 5497 writes in 271146 ms (avoided 7040 new dirty bufs) for db 10:0
07/08/2015 11:38:54,spid11s,Unknown,last target outstanding: 112<c/> avgWriteLatency 53
07/08/2015 11:38:54,spid11s,Unknown,average throughput:   0.57 MB/sec<c/> I/O saturation: 10544<c/> context switches 14765
07/08/2015 11:38:54,spid11s,Unknown,FlushCache: cleaned up 11602 bufs with 6881 writes in 157842 ms (avoided 3790 new dirty bufs) for db 10:0
07/08/2015 11:31:57,spid11s,Unknown,last target outstanding: 140<c/> avgWriteLatency 36
07/08/2015 11:31:57,spid11s,Unknown,average throughput:   0.32 MB/sec<c/> I/O saturation: 13167<c/> context switches 17560
07/08/2015 11:31:57,spid11s,Unknown,FlushCache: cleaned up 13017 bufs with 6402 writes in 320620 ms (avoided 4596 new dirty bufs) for db 10:0
07/08/2015 00:18:21,spid11s,Unknown,last target outstanding: 4<c/> avgWriteLatency 8
07/08/2015 00:18:21,spid11s,Unknown,average throughput:   0.14 MB/sec<c/> I/O saturation: 10051<c/> context switches 16201
07/08/2015 00:18:21,spid11s,Unknown,FlushCache: cleaned up 4618 bufs with 3171 writes in 258097 ms (avoided 5390 new dirty bufs) for db 10:0
07/08/2015 00:07:11,spid51,Unknown,AppDomain 2 (OperationsManager.dbo[runtime].1) created.

Please see:

http://blogs.msdn.com/b/psssql/archive/2012/06/01/how-it-works-when-is-the-flushcache-message-added-to-sql-server-error-log.aspx

This is a warning message your IO is not keeping up and you should look at your disk IO.

• Proposed as answer by Shanky_621MVP, Moderator 1 hour 57 minutes ago

thanks Tom,

Can you pleaes refer some link that help me to troubleshoot the SQL 2012 DB Performance issue and any friendly log viewer for the sql logs...

I wanted to know more about the SQL Logs and Troubleshooting steps required..