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

Archives: December 2012

SQLOS Basics - Chennai User Group Meet - Presentation File Download

Chennai SQL Server User Group (CSSUG) meet is happening tomorrow (15-Dec-2012) in Microsoft Training Centre, Chennai.

You can download presenation and demo scripts here
http://www.sqlservercentral.com/blogs-admin/blogs/livingforsqlserver/CSSUG_SQLOS_Basics_15Dec2012/SQLOS_CSSUG_Meet_15Dec2012.zip

Tomorrow,  I am going take 2 hour session on SQLOS Basics (Skill level 200-300).

Topics to be covered:

SQL Server Architecture
SQLOS  - Basics
SQLOS – Responsibilities
CPU
   … Read more

0 comments, 807 reads

Posted in LivingForSqlServer on 14 December 2012

46756e2057697468205061756c2052616e64616c

49206a75737420747765657465642062656c6f7720656d6f74696f6e616c206d65737361676520746f205061756c2052616e64616c20696e204865782e202020

224a4d5057465a50565142564d53424f45424d22202020

54686f7567687420686520776f756c642067657420746865206d65737361676520616e64207265706c79206d6520696e203135206d696e757465732e202020

4775657373206865207761732076657279206275737920617420746861742074696d652e2048652067617665207570206166746572203220636c75657320616e642032

20617474656d7074732e202020

4861707079207468617420492073706f696c6564206869732076616c7561626c652035206d696e75746573203a2d29202020

4465616c20686572652069732068652068617320746f2066696e642074686520616e73776572206f6620686973206f776e206f7220656c7365

2068652068617320746f202020

6368616e676520686973206f70696e696f6e20616e6420737570706f727420746865206e656564206f6620646f63756d656e74696e67

20616e61746f6d6f79206f6620742d6c6f67202020

7265636f7264732e202020

497420746f6f6b206d6f7265207468616e20313020686f757273206a75737420746f20756e6465727374616e64

206c6974746c6520626974206f662073696d706c6520494e53455354202020

6c6f67207265636f72642e20202020

687474703a2f2f7777772e73716c73657276657263656e7472616c2e636f6d2f626c6f67732f6c6976696e67666f7273716c7365727665722f3230313

22f31312f32372f74696d652d706173732d776974682d7472616e73616374696f6e2d6c6f672d706172742d352d696e736572742f202020

5468696e6b2069747320696d706f737369626c6520746f20646f63756d656e7420616e61746f6d79206f6620616c6c207479706573206f66

20742d6c6f67207265636f7264732e202020

4275742069742063616e20626520646f6e6520746f20736f6d6520657874656e642e202020

496620796f75206172652072656164696e6720746869732c20646f6e7420666f7267657420746f20636f6d6d656e7420796f7572206e616d6520696e

204865782e1f1f

706c6561736520646f6e27742074616b65207468697320736572696f75736c792e204a75737420612066756e20617474656d70742e202020

  Read more

2 comments, 702 reads

Posted in LivingForSqlServer on 7 December 2012

Next Chennai SQL Server UG Meet Is Scheduled

Chennai SQL Server user group meet is scheduled for Dec'2013.

Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30 AM to 01:00 PM
Date: 15th December 2012 (Saturday)

Register here: http://sql-articles.com/cssug/december-2012-ug-meeting-scheduled/

Chennai friends, register yourself to get your seats confirmed.

  Read more

1 comments, 530 reads

Posted in LivingForSqlServer on 5 December 2012

LivingForSQLServer celebrates 2nd year anniversary today

It's been 2 years since I wrote my first blog post on SQLServerCentral ("What happens when a query is submitted").

No need to say how nervous I was while posting my first blog on worlds largest SQL Server community.

Remembering that day I was checking user visits once in two minutes for the… Read more

0 comments, 578 reads

Posted in LivingForSqlServer on 5 December 2012

SQLOS Basics - Query and CPU

In this article We are going to understand the basics of SQLOS - CPU scheduling.

In high level:

1. When an user connects to SQL Server instance, unique connection id and session id is assigned to the user.
DMV: sys.dm_exec_connections

2. Queries being executed by the user sessions (requests in other… Read more

5 comments, 1,451 reads

Posted in LivingForSqlServer on 3 December 2012