August 10, 2023 at 6:00 am
Event 824 from event viewer.
Recommendation: Complete a full database consistency check (DBCC CHECKDB).
Completed DBCC against system dbs with no issues.
Is this error benign in nature - means can be ignored?
Or needs further troubleshooting ?
August 10, 2023 at 2:29 pm
No, it's a real error. However, the good/bad news is, you're dealing with tempdb. You can just drop and recreate it (with a reboot). Here's documentation on dealing with this.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 21, 2023 at 9:19 am
Thanks for thr response @Grant.
When we run the DBCC Checkdb against the system databases it runs clean. Is a reboot to recreate the tempdb still recommended ?
August 21, 2023 at 9:43 am
You running on VMWare at all? And if so are there any snapshots running at the times the errors are reported or is the bloom filter driver enabled via VMWare?
There is an issue with this and advise is to disable bloom.
August 21, 2023 at 12:28 pm
Might want to listen to what @Ant-Green is saying on this one.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 23, 2023 at 4:22 am
Hello @Grant & Ant- Green,
There are no snapshots occuring at the time the errors were reported..
Should we still try disabling bloom and see if it fixes the issue ? Thanks
August 23, 2023 at 8:08 am
I would yeah, you never know what your infra team are doing behind the scenes.
August 23, 2023 at 8:34 am
You running on VMWare at all? And if so are there any snapshots running at the times the errors are reported or is the bloom filter driver enabled via VMWare?
There is an issue with this and advise is to disable bloom.
you mean the Balloon Driver? https://docs.vmware.com/en/VMware-vSphere/7.0/com.vmware.vsphere.resmgmt.doc/GUID-5B45CEFA-6CC6-49F4-A3C7-776AAA22C2A2.html
August 23, 2023 at 9:13 am
@frederico, sorry I pressed report instead of reply, my sincerest apologies.
They specifically call it the "bloom" filter in the article, unsure if they renamed balloon to bloom at some point but yeah that's what the article says
https://kb.vmware.com/s/article/88201
I remember working a case for this exact thing as CSS back around August time last year so this one always sticks in my head.
August 23, 2023 at 9:47 am
@frederico, sorry I pressed report instead of reply, my sincerest apologies.
They specifically call it the "bloom" filter in the article, unsure if they renamed balloon to bloom at some point but yeah that's what the article says
https://kb.vmware.com/s/article/88201
I remember working a case for this exact thing as CSS back around August time last year so this one always sticks in my head.
different one then - was just querying as the baloon driver should also be disabled for all SQL Server VM's
Wasn't aware of that bloom driver (we don't use it explicitly on our shop even though we are heavy users of vmware) as our backups are mostly done at SAN level.
August 23, 2023 at 11:54 am
Fixed the accidental spam.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply