SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


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: October 2011

Four faces of an Employee

Whoever starts their career in any domain/technology, initially they will have two faces.

First face of an employee is to take care of his/him family & family related commitments and the second
face of him/her is to fulfill the expectation of the Organization they work.

But third and forth faces… Read more

2 comments, 1,530 reads

Posted in LivingForSqlServer on 31 October 2011

Logical CPU, Physical CPU and hyper threading

Those who are fan of Glenn Berry’s DMV queries would have come across below query at-least once.

-- Hardware information from SQL Server 2008

-- (Cannot distinguish between HT and multi-core)

SELECT cpu_count AS [Logical CPU Count], hyperthread_ratio AS [Hyperthread Ratio],

cpu_count/hyperthread_ratio AS [Physical CPU Count] Read more

3 comments, 10,093 reads

Posted in LivingForSqlServer on 30 October 2011