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

0x800703E3
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:

http://www.sql-server-performance.com/tips/stored_procedures_p1.aspx
http://www.sql-server-performance.com/tips/sql_server_performance_monitor_coutners_p1.aspx
http://support.microsoft.com/kb/243588
http://msdn.microsoft.com/en-us/library/aa212698(SQL.80).aspx

Wednesday, November 5, 2008