Monday 18 February 2013
Heaps Of Trouble
I recently came across a situation at a client which I
thought I would share with you. I came across this while doing some routine
maintenance and noticed a small table consuming a lot of memory. I mean this
table, which is a smallish lookup table, was consuming almost 430 MB of buffer
space. The thing about lookup tables and the way they are used is that the
entire table is usually read into memory. This is by design but the problem
here is that there should be no way that this table needs 430 MB.
SQL Server 2012: Restore Fails With Deadlock
We had an interesting situation at a client where we could not restore a SQL Server 2008 R2 backup onto SQL Server 2012. The restore would fail at 100% with a deadlock.
Isolation Levels
As a follow up to my NOLOCK blog I thought it would be a
good idea to discuss the five different isolation levels in SQL Server. These
are as follows:
NOLOCK!
I see many developers writing SQL code and using NOLOCK as a "performance tool". I see NOLOCK spread liberally through scripts, applied to every single table as far as the eye can see. This technique is dangerous and I would like to share why.
Labels:
Isolation Levels,
NOLOCK,
Read Uncommitted,
SQL Server
Subscribe to:
Posts (Atom)