Page 168 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes (c) Error Logs
(d) Current activity window (SQL Server Enterprise Manager)
(e) System Monitor
(f) SQL Profiler

Answers: Self Assessment

1. False 2. False

3. True 4. True
5. True 6. Response time
7. Throughput 8. SQL Profiler

9. System Monitor 10. Task Manager
11. DBCC Statements

11.10 Further Readings

Books C.J. Date, Introduction to Database Systems, Pearson Education.
Elmasri Navrate, Fundamentals of Database Systems, Pearson Education.
Peter Rob & Carlos Coronel, Database Systems Design, Implementation and
Management, 7th Edition.
Raghurama Krishnan, Johannes Gehrke, Database Management Systems, Tata
McGraw Hill, 3rd Edition.
Silberschatz, Korth, Database System Concepts, McGraw Hill, 5th Edition.

Online links www.sql-tutorial.net/

www.w3schools.com/sql/
www.sqlservertutorials.com/

162 LOVELY PROFESSIONAL UNIVERSITY