SQL Server can obtain a very high level of performance with relatively little configuration tuning. You can obtain high levels of performance by using good application and database design, and not by extensive configuration tuning. See the "References" section of this article for information about how to troubleshoot various SQL Server performance issues.
When you address a performance problem, the degree of improvement that is available from configuration tuning is typically modest unless you do not currently have the system properly configured.
In SQL Server version 2000 and later, SQL Server uses automatic configuration tuning and it is extremely rare that configuration settings (especially advanced settings)
need any changes. Generally, do not make a SQL Server configuration change without overwhelming reason and not without careful methodical testing to verify
the need for the configuration change.
You must establish a baseline before the configuration change so that you can measure the benefit after the change.
An alert signifies when a given condition has been reached.
The SQL Server processes in which data pages that have been modified are flushed to disk.
Determines the order in which unicode data is sorted.
Component Object Model is a model for APIs used to access data.
A TSQL extension that allows you to have summary rows intermixed with detail rows.
A person or application that has logged onto SQL Server.
Data transformation service (DTS)
A SQL Server component that allows you to transfer data between multiple data sources.
Database consistency checker - a set of utilities for verify a database and performing various system administrator
When two connections each hold locks on resources that the other connection wants.
The number of rows in which a column has a given value.
A calculated column. SQL Server allows you to define derived columns as part of the table definition.
A memory page in which data has been changed.
The OS file that SQL Server writes errors and messages to.
A significant occurrence.
A group of events.
A group of events.
The windows NT logging mechanism.
Extended stored procedures
SQL Server stored procedures that access external DLLs.
SQL Server allocation unit. An extent is 8 data pages.
Limits what is viewed.
A condition that occurs when data is not stored consecutively.
Each time you click a glossary term, you'll see a window like this one displaying the term and its definition. To see the
entire glossary, click “Show All Terms.”
When the data used by an application is on the swap file.
Hetrogeneous data sources
Data that is stored by a different RDBMS.
A range of values within an index.
Homogeneous data sources
Data that is stored by the same RDBMS.
An automatically incrementing column.
Index Tuning Wizard
A wizard that helps you develop the correct indexes .for a table.
A SQL Server agent set of tasks.
A light weight object that does not need to be locked.
The lowest level of an index.
Least recently used (LRU)
The in memory data page that has gone the longest time without being accessed.
OLE-DB connection to external data sources.
A SQL Server mechanism use to ensure transaction isolation levels.
Mail Application Programming Interface - An interface that Microsoft uses to send and read mail.
In a multi server SQL Server Agent environment, a master server is the server that stores the SQL Server Agent
Management Information Bulletin - A SNMP component that describes the information that can be monitored.
A set of Microsoft ActiveX interfaces and data models that are used to define database schema and data transformations as
specified by the Microsoft Data Warehousing Framework.
Most recently used (MRU)
The in memory data page that was the last data page to be accessed.
The system database that is used to store SQL Server Agent information and DTS information.
A COM API that allows you to access data sources.
A person that gets notified when an alert occurs.
A set of DTS commands used to transform data.
A standard mail interface.
The amount of memory that SQL Server reserves for storing stored procedures.
A repository for application and system configuration information.
Remote procedure calls(RPC)
A means of communicating between two SQL Servers.
A function that returns a single value.
Single user mode
A database that is configured to allow only one user to access it.
Simple Network Management Protocol- a protocol for monitoring and managing network components.soft paging Removing data from
the page cache.
Removing data from the page cache.
SQL Server's interface to your e-mail system.
SQL Server Agent
A SQL Sever component that allows you to schedule jobs, define alerts, and define operators.
An API that allows you to access SQL Server's Data Management Objects.
Track the data distribution.
System catalog table
A system wide table, stored in the master database, that tracks system resources.
System stored procedure
A procedure stored in the master database which begins with sp_ that is used to perform system functions.
In a multi server SQL Server Agent environment, this is a server that a job will run against.
One of the steps in a job.
The information that SQL Server profiler gathers.
A SQL Server dbcc option that changes the behavior of SQL Server.
A SQL Server wizard that helps you set up a trace.
Code that is executed in response to a database event, or in response to a SQL statement issued against a table.
Describes the steps need top be done to complete a task.