Róbert Kanász - blog venujúci sa programovaniu na platforme .NET
Prihlásiť
|
Registrovať
|
Pomoc
Domov
RSS
Atom
RSS komentáre
Aktualizácie emailom
Predplatiť
Vyhľadávať
Štítky
70-433
70-536
C#
MCTS
MS SQL Server
StopWatch
Navigácia
AspNet.sk
Vyvojari.sk
ITici.sk
Blogy
Archív
November 2011 (14)
October 2011 (7)
MCTS - Microsoft SQL Server 2008, Database Development - 70-433 - Objective List Part 7 (Gathering Performance Information)
Capture execution plans
Displaying Graphical Execution Plans (SQL Server Management Studio)
Displaying Execution Plans by Using SQL Server Profiler Event Classes
XML Showplans
SET SHOWPLAN_XML (Transact-SQL)
SET SHOWPLAN_ALL (Transact-SQL)
SET SHOWPLAN_TEXT (Transact-SQL)
SET STATISTICS XML (Transact-SQL)
SET STATISTICS PROFILE (Transact-SQL)
SET STATISTICS TIME (Transact-SQL)
SET STATISTICS IO (Transact-SQL)
Transact-SQL Statements That Produce Showplans
SHOWPLAN Permission and Transact-SQL Batches
Gather trace information by using the SQL Server Profiler
Introducing SQL Server Profiler
SQL Server Profiler Terminology
Using SQL Server Profiler
SQL Server Profiler Templates
Permissions Required to Run SQL Server Profiler
Saving Traces and Trace Templates
Modifying Trace Templates
Starting, Pausing, and Stopping Traces
Correlating a Trace with Windows Performance Log Data
Viewing and Analyzing Traces with SQL Server Profiler
Analyzing Deadlocks with SQL Server Profiler
Analyzing Queries with SHOWPLAN Results in SQL Server Profiler
Filtering Traces with SQL Server Profiler
Replaying Traces
Scenarios for Using SQL Server Profiler
SQL Server Profiler Reference
Starting SQL Server Profiler
Collect output from the Database Engine Tuning Advisor
Database Engine Tuning Advisor Features
Differences Between Database Engine Tuning Advisor and Index Tuning Wizard
Using Database Engine Tuning Advisor
Initializing Database Engine Tuning Advisor
Starting Database Engine Tuning Advisor
Determining Whether Events Can Be Tuned
Tuning a Database
Available Tuning Options
Choosing a Database Engine Tuning Advisor Report
Reducing the Production Server Tuning Load
Tuning Multiple Databases
Using an XML Input File for Tuning
Tuning Mode Precedence: When the dta Utility Overrides XML Tuning Input
Using Session Monitor to Evaluate Tuning Recommendations
How to: Create Workloads
How to: Tune a Database
How to: View Tuning Output
How to: Perform Exploratory Analysis
How to: Implement Tuning Recommendations
Collect information from system metadata
Dynamic Management Views and Functions
Change Data Capture Related Dynamic Management Views
Common Language Runtime Related Dynamic Management Views
Database Mirroring Related Dynamic Management Views
Database Related Dynamic Management Views
Execution Related Dynamic Management Views and Functions
Full-Text Search Related Dynamic Management Views
Index Related Dynamic Management Views and Functions
I/O Related Dynamic Management Views and Functions
Object Related Dynamic Management Views and Functions
Query Notifications Related Dynamic Management Views
Replication Related Dynamic Management Views
Resource Governor Dynamic Management Views
Service Broker Related Dynamic Management Views
SQL Server Extended Events Dynamic Management Views
SQL Server Operating System Related Dynamic Management Views
Transaction Related Dynamic Management Views and Functions
Security Related Dynamic Management Views
Publikované Wednesday, November 02, 2011 1:46 PM
kanasz.robert
Zaradené do:
MCTS
,
70-433
,
MS SQL Server
Komentáre
Bez komentárov