RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Tables Queries
SQL Server Profiler
«Prev
Next»
Configuration Monitoring
Importing/Exporting Data
Insert Data Load Statement
Select into Statement
Bulk Insert Statement
SQL Bulk Copy Program
Data Transformation Services
DTS Package Designer
Scheduling Running Package
DTS Wizard
Running DTS Wizard
Load Export Conclusion
Monitoring SQL-EM
Monitoring SQL Connections
Monitor Locked Resources
SQL-EM Monitor Locks
Overall System Performance
Monitor Data Cache
Monitor Performance using DBCC
Monitoring Databases
Monitor Database Size
Use SSMS monitor DB Size
Monitor Databases using DBCC
Monitor Consistency Individual Tables
Miscellaneous DB Monitoring via Dbcc
Monitor Transaction Log
Maintaining Database Statistics
View Statistical Information
Run sqlmaint.exe
Database Maintenance Plan wizard
SQL-Em Conclusion
SQL-Server Profiler
SQL Server Profiler - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following are components of SQL Server Profiler?
Please select all the correct answers.
A.
trace
B.
event
C.
profile
D.
filter
2.
When you define a trace, you can define which of the following items?
Please select all the correct answers.
A.
The schedule of when to run a trace
B.
The trace name
C.
The information to track
D.
Error generation for the trace
::::
3.
Which of the following can you do with a running trace?
Please select all the correct answers.
A.
pause
B.
rerun
C.
stop
D.
end
4.
Which event classes are useful to trace whenever you are having any kind of performance problems?
Please select all the correct answers.
A.
TSQL
B.
SQL Operators
C.
Errors and Warnings
D.
Transactions
E.
Stored Procedures
F.
Duration
G.
Event Class
H.
Object ID
I.
Integer Data
J.
Start Time