sql server internals & achitecture

/Tag:sql server internals & achitecture

SQL Server Lock Escalation explained

Hi Friends, I wrote a blog post on partition-level locking where I demonstrated how locks are escalated from row to partition. The blog post is here; A few readers wrote back to me asking when does SQL Server escalate the row locks to table or partition level locks. So in this post, I will talk [...]

By |March 13th, 2014|SQL Server|0 Comments

SQL Server DBCC LOGINFO – Observing Virtual Log

Hi Friends, We can have more than one log file for a database. However, in many cases a single log file suffices. Logically, a log file is divided into a number of virtual log files. The virtual log file concept allows SQL Server to manage various operation on the log file, including checkpoints, various phases [...]

By |February 3rd, 2014|SQL Server|6 Comments

SQL Server 2014 In-Memory OLTP – Have You Tested It The Right Way?

Hi Friends, Are you sure you have tested SQL Server 2014 In-Memory OLTP the right way? In one of my recent conversations with a customer, a senior DBA from the customer side expressed that he does not see ‘exponential’ performance when he converts on-disk tables to In-Memory tables. He further expressed that performance by ‘leaps [...]

By |January 15th, 2014|SQL Server|4 Comments

Does SQL Server NEWSEQUENTIALID function always generates sequential GUIDs?

Hi Friends, Many of us already know the difference between NEWID() and NEWSEQUENTIALID() function. The GUID generated using NEWID() function is random in nature, which means, there is no guarantee that the the GUID generated is lower or higher than the previous GUID. And we all know that this was a burning issue becuase its not [...]

By |November 13th, 2013|SQL Server|1 Comment