Archives: February 2011
I got a report from development team that section of BizTalk communicating with SQL Server to update status
is frequently failing as deadlock victim.
As I couldn't see any useful details in errorlog, enabled trace flags 1204,1205, 3605 and -1 and captured
few deadlock cases in errorlog.
but there was… Read more
I got a chance to evaluate performance of both views and stored procedure for high level decision making.
As all of Us knows that purpose/scope of views and stored procs are different, I have done this quick POC only to prove execution time of both views and stored procedures are same.
seem still lots of people… Read more
Anyone who can interpret data and index pages will surely think about interpreting PFS, GAM and SGAM pages. I am no exception.
I thought of giving a try in a lazy weekend with little experience on examining data and index pages.
Agenda of this exercise is, to create a simple… Read more