December 15, 2014 at 3:27 am
Hi,
I am currently auditing all databases on SQL Server 2008 R2 for specific events ( database accounts related activity) . I get alot of events generated for tempdb. I am monitoring the following events 47, 102, 103, 104, 105, 108, 109, 110, 111, 113, 117, 130, 170, 171, 173, 176 is what I am monitoring.
Do I need to monitor tempdb or is it alright to exclude the tempdb?
Thanks in advance.
December 15, 2014 at 3:36 am
Hi,
From what i can find on the internet, I think it is ok to Skip tempdb from the Audit.
Still i would prefer that you take advise from some of the more senior members here. 🙂
Regards
Shafat Husain
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 15, 2014 at 4:29 am
It really depends on what you are attempting to collect in this information you're gathering. I've always set up monitoring on a server-by-server basis, not on a database-by-database basis. If you're attempting to gather performance metrics, errors, etc., yes, you should also be monitoring tempdb. If you're going after specific data behaviors within databases, then, no, I'd say tempdb is a waste of time.
Where did you get that list of specific events to monitor?
"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
December 15, 2014 at 7:15 am
Thanks for your replies. I am basically trying to log database admins and users related activity. The list of events were provided to me by our logging solution support to monitor for the same purpose. Is there anything wrong with the event list?
December 15, 2014 at 7:28 am
pottapitot (12/15/2014)
Thanks for your replies. I am basically trying to log database admins and users related activity. The list of events were provided to me by our logging solution support to monitor for the same purpose. Is there anything wrong with the event list?
No, not saying that. And I don't know if there's anything wrong with the list or not. I don't have the event numbers memorized such that I could comment on them without looking up each one. I'm just curious how you came up with that specific list.
"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
December 15, 2014 at 9:05 am
Sorry my bad 🙂
We have 50-70 DBs of multiple applications on the single server. So I guess I can ignore the tempdb and generate events for these 50-70 DBs for DBA and DB user activity.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply