Tuesday, November 18, 2008

What's installed in a Windows box?

See here for downloading and use msiinv.exe.

Wednesday, November 12, 2008

IIS7: COM 0x800703E3 error

Problem: when requesting static files against IIS7, following error was reported to event viewer

at System.Web.Hosting.IIS7WorkerRequest.FlushCore(Boolean keepConnected, Int32 numBodyFragments, IntPtr[] bodyFragments, Int32[] bodyFragmentLengths, Int32[] bodyFragmentTypes)
at System.Web.Hosting.IIS7WorkerRequest.FlushCachedResponse(Boolean isFinal)
at System.Web.HttpResponse.UpdateNativeResponse(Boolean sendHeaders)
at System.Web.HttpRuntime.FinishRequestNotification(IIS7WorkerRequest wr, HttpContext context, RequestNotificationStatus& status)

Solution: known issue in IIS7, fixed by Microsoft .NET Framework 3.5 Service Pack 1

SQL: Excessive SQL Compilations/Sec

Problem: SQL Compilations/Sec greater than 50 sec in a mid-end backend.
Cause: Store procedures not being fully parameterized. If they were, their plans could have been cached and reused for same runs with different parameters.

Some related links:


Wednesday, November 5, 2008