ThatJeffSmith

Tag: transaction

Killing in the Name

Do you take pleasure in killing peo…people’s sessions in the database? If so, you are not alone. If you have Blocking Locks, the easiest way to fix that is kill the offending session and free up the requested resource. But, who should win this battle? What transactions take precedence? Should the business analyst have his [...]

Replaying Activity in SQL Server

Load testing is an interesting topic. Application load testing is what most people are familiar with. They either use something like LoadRunner, or they ask half the company to ‘jump on the website and start clicking buttons.’ But what about the database? In this case, what about SQL Server? Will it be able to sustain [...]