Term
| how many trace modules do you get in SQL Server? |
|
Definition
|
|
Term
| you should programmatically build all your traces with ______ and then execute after |
|
Definition
|
|
Term
| What captures events within a SQL Server instance |
|
Definition
|
|
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
|
|
Term
| if there is a security level of 16 or higher |
|
Definition
| these messages will be in the Windows Event Log. |
|
|
Term
|
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
|
|
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. |
|
|
