Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/16

Click to flip

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