Shared Flashcard Set

Details

DBA, Chapter 12
Monitoring the SQL Server
18
Computer Science
Undergraduate 4
03/21/2011

Additional Computer Science Flashcards

 


 

Cards

Term
how many trace modules do you get in SQL Server?
Definition
9
Term
you should programmatically build all your traces with ______ and then execute after
Definition
code
Term
What captures events within a SQL Server instance
Definition
SQL Trace
Term
Profiler lets you load both _______ and ______
Definition
trace logs and Perf Mon logs (you need the start time)
Term
what type of file is the error log
Definition
text file
Term
if there is a security level of 16 or higher
Definition
these messages will be in the Windows Event Log.
Term
slide 31
Definition
Term
what are the three items that you define within a trace
Definition
events, data columns, and filters
Term
what events are commonly used to establish a performance baseline?
Definition
RPC:Completed and SQL:BatchCompleted
Term
what are the items that you can capture data for with System Monitor?
Definition
objects, counters, and counter instances
Term
what types of data does system monitor capture?
Definition
numeric data for performance counters that are defined for hardware or software components
Term
what are the three counters that, by themselves, indicate a system problem
Definition
System:Processor Queue Length
Network Interface:Output Queue Length
Physical Disk:Avg. Disk Queue Length
Term
error and informational messages related to your server can be found in...
Definition
1. Windows Event Logs
2. SQL Server error logs
3. SQL Server Agent logs
4. Database Mail Logs
Term
where is the error log found?
Definition
MSSQL10.instance\MSSQL\LOG\errorlog
Term
what are the most common errors you encounter?
Definition
running out of space
Term
what errors do you see if your disk goes off-line underneath a database?
Definition
SQL begins logging device activation errors
Term
what errors do you see if your disk goes off-line underneath a database?
Definition
SQL begins logging device activation errors
Term
what errors do you see if there is a fault in either the memory or processor?
Definition
you see STOP errors. If there is a memory error when the computer is booting, you see a POST error.
Supporting users have an ad free experience!