Extended events in sql server 2008

Explain Extended events in sql server 2008

Extended Events are the enhanced event handling system in SQL Server. It is an architecture that is highly scalable, highly configurable. It allows the DBAs for collecting the required information, could it be little or much, for problem identification or problem trouble shooting.

Data collection which can output to an Event Tracing for Windows target is one of the key features of Extended Events. This allows the correlating data with the data collected from the corresponding operating system with the help of Event Tracing for Windows. Even the wait events could be correlated with the kernel EWT data. This process is done within a single view for isolating the waits for a specific reason.

The events are handled by an engine which is a services and objects collection which allows defining, process and managing event sessions, event data and event sessions respectively.
Explain SQL Server 2008 backup compression - Sql server 2008
A compression backup is smaller than uncompressed backup. The backup speed significantly increases because it needs less disk space and I/O operations..........
Explain Filestream storage of sql server 2008 - Sql server 2008
The complexity of application development and reduces the managing unstructured data cost...........
Sparse Columns of sql server 2008
A column with an optimized storage for null values is known as sparse column. Sparse columns reduce the storage space needs for null values..........
Post your comment