Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

LivingForSqlServer

I am Ramkumar, 34 years old Consultant, trainer, blogger and speaker at SQL Server user group in India. I have more than 10 years of experience as a developer and SQL Server DBA. I love reading, teaching and blogging about SQL Server internals and performance tuning. My Facebook page: https://www.facebook.com/LivingForSqlServer

SQL Server Myth on Clustered Index page allocation or B-Tree formation

Here is another SQL Server myth which I realised while understanding anatomy of index pages.

For a long time I thought data and Index pages will be allocated once We create a table.

Its a myth. but the reality is

1. Once you create a table and if a table… Read more

1 comments, 1,391 reads

Posted in LivingForSqlServer on 11 July 2011

My Favourite SQL Server Myths and Realities

It has been more than two months since I blogged. I have been blogging in my Organization internal blogging site on Management topics for last couple of months (just a side effect of my new project lead position).
In parallel, I have started giving session on Performance tuning and Storage internals for my Organization…
Read more

10 comments, 1,777 reads

Posted in LivingForSqlServer on 28 June 2011

Why knowledge of internals is required for DBA? here is a valid reason

I got a report from development team that section of BizTalk communicating with SQL Server to update status
is frequently failing as deadlock victim.

As I couldn't see any useful details in errorlog, enabled trace flags 1204,1205, 3605 and -1 and captured
few deadlock cases in errorlog.

but there was… Read more

0 comments, 722 reads

Posted in LivingForSqlServer on 24 February 2011

Evaluating Performance of View and Stored procedure

I got a chance to evaluate performance of both views and stored procedure for high level decision making.

As all of Us knows that purpose/scope of views and stored procs are different, I have done this quick POC only to prove execution time of both views and stored procedures are same.

seem still lots of people… Read more

0 comments, 3,097 reads

Posted in LivingForSqlServer on 13 February 2011

Examining PFS, GAM and SGAM pages

Anyone who can interpret data and index pages will surely think about interpreting PFS, GAM and SGAM pages. I am no exception.

I thought of giving a try in a lazy weekend with little experience on examining data and index pages.

Agenda of this exercise is, to create a simple… Read more

1 comments, 2,634 reads

Posted in LivingForSqlServer on 13 February 2011

SQL Server Storage Internals Part 6 – How to read Clustered and Non Clustered Index Pages

In this article we are going to see how index pages are organized with data pages and how to read different levels and types of indexes with simple example

To start with, let’s create a simple table in test database named LearningInternals.

CREATE TABLE tExample6(

intEmployeeId int IDENTITY(1001 Read more

7 comments, 3,273 reads

Posted in LivingForSqlServer on 29 December 2010

SQL Server Storage Internals Part 5 - Properties of Clustered and Non Clustered Index pages

In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise , newbies need to understand concepts on Index architecture before moving on to see what is there inside index pages.

So, before going see internals of Clustered and NonClustered index pages, lets quickly recap some… Read more

11 comments, 3,618 reads

Posted in LivingForSqlServer on 27 December 2010

SQL Server Storage Internals Part 4 - How to read a Heap page

I like to share 4 updates before moving on to this section:

1. I 've updated my profile to know more about me and purpose of this blog.
2. I 've republished this part with some updates after getting comments from Seniors. 
    You may notice that I 've removed detailed explaination of… Read more

15 comments, 3,767 reads

Posted in LivingForSqlServer on 21 December 2010

SQL Server Storage Internals Part 3 - Architecture of Heaps

 In this article I have explained below topics
1. key points on HEAP tables.
2. What happens when a table is created.
3. How to list IAM, data pages allocated to a heap table.

As all data, index and system pages stores data in hexadecimal format, knowledge of Hexadecimal to decimal conversion… Read more

9 comments, 2,667 reads

Posted in LivingForSqlServer on 19 December 2010

SQL Server Storage Internals Part 2 - Partitions and Allocation Units

 

Before moving on to see anatomy of different types of pages, lets spend some time to understand

The relationship among sys.objects, sys.partitions, sys.allocation_units and sys.system_internals_allocation_units system views.

 

Case 1 (simple table with record size less than 8000 bytes and no… Read more

7 comments, 4,231 reads

Posted in LivingForSqlServer on 16 December 2010

SQL Server Storage Internals Part 1 - Basics

 While learning query tuning topics, I got a chance to understand anatomy of data page and different types and levels of Index pages.

This learning helped me to understand concepts better and to give better performance tuning solutions later.

This is my attempt to share my learning with beginners… Read more

5 comments, 2,646 reads

Posted in LivingForSqlServer on 13 December 2010

What happens when a query is submitted?

I know, We cant cover life span of query in short.  here is my another try to list some high level information to those who are new to SQL Server community.

1. SQL Server Network Interface (SNI) a protocol layer on Client establish connection to Server SNI using Network protocol such as… Read more

15 comments, 2,272 reads

Posted in LivingForSqlServer on 5 December 2010

Newer posts