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
Intro Monitoring SSMS
SQL Server Connections
Monitoring SQL Connections
Monitor Locked Resources
SQL EM Monitor Locks
Overall System Performance
Database Consistency Checker
Monitor Data Cache
Monitor Performance Using DBCC
Trace Flags
Built In Functions
SQL EM Conclusion
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
Each question is worth one point. Select the best answer for each question.
SQL Server Profiler - Quiz
SQL Server Profiler wizards and data
1.
Which of the following columns must be tracked so you can replay a trace?
Please select all the correct answers.
A.
SQL User Name
B.
Database ID
C.
Text
D.
Object ID
2.
Which of the following items is the Trace Wizard designed to help diagnose?
Please select all the correct answers.
A.
Find SQL Server errors
B.
Find Large table scans
C.
Trace down Deadlocks
D.
Profile the performance of a select statement
::::
3.
If you want to find out who is issuing the commands being traced, what column must be included in your trace?
Please select all the correct answers.
A.
NT User Name
B.
SQL Server User Name
C.
NT Domain Name
D.
Connection ID