May 8, 2022 at 2:39 pm
Hello!!
I have a McAfee ePO setup where we use SQL for database.
I noticed few monitors/say tables are not displaying properly in dashboards. .
When I went through the sql logs I found below errors.
Could these errors be a reason for not seeing the tables getting populated ?
2022-03-21 02:00:26.35 spid16s SQL Server has encountered 808 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\TempDB\tempdb_df4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000C30. The offset of the latest long I/O is: 0x00000215ce0000
2022-03-21 02:00:26.35 spid16s SQL Server has encountered 807 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\TempDB\tempdb_df5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000C34. The offset of the latest long I/O is: 0x00000215c60000
2022-03-21 02:00:26.35 spid16s SQL Server has encountered 805 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\TempDB\tempdb_df3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x00000215c20000
2022-03-21 02:00:26.35 spid16s SQL Server has encountered 811 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\TempDB\tempdb_df6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000C14. The offset of the latest long I/O is: 0x00000215bb0000
2022-03-21 02:00:26.35 spid16s SQL Server has encountered 815 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\TempDB\tempdb_df2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000C08. The offset of the latest long I/O is: 0x00000215c10000
2022-03-21 02:00:26.35 spid16s SQL Server has encountered 806 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\TempDB\tempdb_df7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000C3C. The offset of the latest long I/O is: 0x00000215c80000
2022-03-21 02:00:26.35 spid16s SQL Server has encountered 809 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\TempDB\tempdev.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000B90. The offset of the latest long I/O is: 0x00000215eb0000
2022-03-21 02:00:26.35 spid16s SQL Server has encountered 808 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\TempDB\tempdb_df8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000C40. The offset of the latest long I/O is: 0x00000215c90000
2022-03-21 02:00:26.35 spid16s SQL Server has encountered 14 occurrence(s) of I/O requests taking longer than 15 seconds to co
May 9, 2022 at 1:19 pm
It could be timing out. Contact your McAfee ePO vendor.
An sich it shouldn't be a cause for the empty dashboards.
May 12, 2022 at 5:06 pm
Why do you have McAfee scanning your database files??? Those should be excluded.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 13, 2022 at 1:32 am
Absolutely correct. McAfee could end up damaging your db files, esp. log files.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply