|
| |
| |
|
|
|
Da Notes -
70-028 - M
Personal notes on the MCDBA tests. These notes are from the various resources I used to pass the MCDBA exams including the MCDBA sample exams from Transcender. |
Passing Score: 680, Questions: 52, Time: 90 Minutes
|
Da Notes Index
|
|
|
Memory Allocation
|
Dynamic Memory Allocation - Default setting
Fixed Memory Allocation - Specify min and max server memory
Use sp_configure or MMC to modify it
|
MMC
|
Shared console provides a convenient and consistent environment
for SQL Server and other snap-in administrative tools.
|
Monitoring and maintaining SQL Server
|
Tools :
Microsoft Event Viewer - NT event viewer
Performance Monitor - integrates Windows NT Performance Monitor
with SQL Server, providing up-to-the-minute activity and performance
statistics as well as a means to diagnose system problems
SQL Server Profiler : A SQL Server tool that captures a continuous record of server activity in real-time. SQL Server Profiler can monitor many different server events and event categories, filter these events with user-specified criteria, and output a trace to the screen, a file, or another SQL Server.
SQL Query Analyzer : Show Estimated Execution Plan
dbcc commands : The Transact-SQL programming language provides DBCC statements that act as the "database consistency checker" for SQL Server. These statements check the physical and logical consistency of a database. Many DBCC statements can fix detected problems.
sqlmaint.exe : The sqlmaint utility performs a specified set of maintenance operations on one or more databases. Use sqlmaint to run DBCC checks, back up a database and its transaction log, update statistics, and rebuild indexes. All database maintenance activities generate a report that can be sent to a designated text file, HTML file, or e-mail account.)
sp_who : Provides information about current SQL Server users and processes
sp_lock : Reports information about locks
sp_monitor : Displays statistics about SQL Server
sp_spaceused : Displays the number of rows, disk space reserved, and disk space used by a table in the current database
MMC : SQL Server -> Management -> Current Activity (Process Info, Locks)
MMC : SQL Server -> Management -> Replication Monitor -> Replication Alerts
MMC : SQL Server -> Management -> SQL Server Logs
|
|
|
|
|
