Wednesday, September 9, 2015

Changes to SQL Server 2014 AlwaysOn Availability Groups

›
AlwaysOn Availability Groups provide high availability for multiple databases, and they can make use of multiple secondary replicas. Each s...
1 comment:
Thursday, December 26, 2013

SQL Server – Performance Top Queries by Total CPU Time

›
select top 10 rank() over(order by total_worker_time desc,sql_handle,statement_start_offset) as row_no ,       (rank() over(order by total...

List current SQL Server tempdb statements

›
SELECT ssu.session_id, (ssu.internal_objects_alloc_page_count + sess_alloc) as allocated, (ssu.internal_objects_dealloc_page_count + sess_...

How to check for SQL ghost records

›
Use the sys.dm_db_index_physical_stats view and check the ghost_record_count column. The Ghost record count  is the row count in the index...

Calculate the Size of Index

›
SELECT ix.[name] AS IndexName, SUM(ps.[used_page_count]) * 8 AS IndexSize_KB FROM sys.dm_db_partition_stats AS ps JOIN sys.indexes AS ix ON...
Friday, September 20, 2013

SQLOS's memory manager and SQL Server's Buffer Pool

›
SQLOS's memory manager consists of several components such as memory nodes, memory clerks, memory caches, and memory objects. Fig 1. d...

Optimising System Memory for SQL Server

›
Virtual Memory and Memory Management On the x86 family of processors, all processes are provided with 4Gb of virtual memory. By default, ...

SQL SERVER Architecture – Terminology

›
The major components of SQL Server are: Relational Engine Storage Engine SQL OS Now we will discuss and understand each one of the...

SQL Server 2014: A Closer Look

›
Microsoft SQL Server 2014 was announced by Quentin Clark during the Microsoft TechEd 2013 keynote. Designed and developed with our cloud-...
1 comment:

What is the difference between Checkpoint and Lazy Writer

›
Row Checkpoint Lazy writer 1 Checkpoint is used by sql engine to keep database recovery ti...