Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
16 Cards in this Set
- Front
- Back
|
what are the 12 profiler event categories
|
1. cursors
2. error and warning 3. locks 4. misc. 5. objects 6. scans 7. sessions 8. sql operators 9. stored procedures 10. transactions 11. tsql events 12. user-configurable |
|
|
what are some profiler events that are relavent for security monitoring?
|
1. misc: login failed
2. misc: service control 3. objects: object:deleted 4. sql operators: delete |
|
|
what does the object event category monitor?
|
when such an object as a databse, table, index, view or stored proc is open created, deleted or used
|
|
|
what are the 3 transaction events
|
1. DTCTransaction
2. SQLTransaction 3. TransactionLog |
|
|
what are the 4 SQL Operator events
|
1. delete
2. insert 3. select 4. update |
|
|
what are the 3 session events
|
1. connect
2. disconnect 3. existing connection |
|
|
what are the 2 scan events
|
1. scan:started
2. scan:stopped |
|
|
what are the 9 misc events
|
1. Attention
2. Auto-Update Stats 3. Exec Prepared SQL 4. Execution Plan 5. Login Failed 6. Prepared SQL 7. Server Memory Change 8. Service Control 9. Unprepared SQL |
|
|
what are the 9 Error and Warning events
|
1. ErrorLog
2. EventLog 3. Exception 4. Exectuion Warning 5. Hash Warning 6. Missing Column Statistics 7. Missing Join Predicate 8. OLEDB Errors 9. Sort Warning |
|
|
what are the 7 cursor events
|
1. CursorClose
2. CursorExecute 3. CursorImplicitConversion 4. CursorOpen 5. CursorPrepare 6. CursorRecompile 7. CursorUnprepare |
|
|
What are the 5 default events when you start a new trace?
|
1. Connect
2. Disconnect 3. ExistingConnection 4. RPC:completed 5. SQL:BatchCompleted |
|
|
Describe user configurable events
|
5 user defined events to track user defined events. custom events are set with xp_trace_generate_event
|
|
|
What are the 6 TSQL Events
|
1. RPC:completed
2. RPC:starting 3. RPC:BatchCompleted 4. RPC:BatchStarting 5. stmtCompleted 6. stmtStarting |
|
|
what are the 4 object events
|
1. Object:closed
2. Object:created 3. Object:deleted 4. Object:opened |
|
|
What are the 7 lock events
|
1. Lock:Acquired
2. Lock:cancel 3. Lock:deadlock 4. Lock:deadlock chain 5. Lock:escalation 6. Lock:released 7. Lock:timeout |
|
|
What are the 10 stored procedure events
|
1. SP:CacheHit
2. SP:CacheInsert 3. SP:CacheMiss 4. SP:CacheRemove 5. SP:Completed 6. SP:ExecContextHit 7. SP:Recompile 8. SP:Starting 9. SP:stmtCompleted 10. SP:stmtStarting |
