Sql server 2008 R2 memory is full and we are seeing this below error
continuously in the log file, even after every restart sql server goes in to recovery mode after that it will be fine and the memory will be full again in few hours, but database is operational
SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [D:\SQLDATA\fff\\cccc.ldf] in database [dd] (5). The OS file handle is 0x00000000000005C8. The offset of the latest long I/O is: 0x00000062bc6000
we are seeing this error for .ldf, .ndf. mdf,etc
just done dbcc checkdb, could not find any errors on database.
just noticed one table
and rebuild index, shrink jobs are failing, but backup jobs are ok! even i could not shrink the log files, which is pretty huge..
we cant find any events in the windows 2008 R2 Server
this a virtual server running on vmware
Appreciate your help on this.. Thanks