Archives for Software Dev - Page 49
DataContractSerializer – MaxItemsInObjectGraph exceeded exception
Simple Self Reference Consider the following class – a Person contains a list of Children - who are also Persons. So, Person references Person inside itself. This is a self-reference.…
nHibernate–manual session flushing
An nHibernate session maintains all changes to the object model. At some point, it needs to synchronize these changes with the database. It can either do these constantly (as and…
Max Pool Size Setting in ADO.net
As part of my nHibernate troubleshooting, I decided to play with the max pool size setting in We had a WCF Service going through nHibernate – which was setup to…
Missing 4.5 IIS Application Pool, Upgrading to 4.5
Introduction If you have just upgraded to .NET for web app, you may be wondering how to ensure that your application actually is running on and not on the older…
SQL Server – Applying Database Tuning Advisor Recommendations
Once you have obtained a good ‘performance’ trace for your database, you can enlist the help of SQL Server’s tuning advisor. The advisor will treat the queries in the trace…
A useful sql server (production) trace template
Introduction To run a sql server profiler session, you need a ‘trace template’. The default built-in templates are a good starting point (especially the ‘tuning’ template). However, a more advanced…
Inserting code snippets into MS Word documents
Step 1 – Insert Object from MS Word’s INSERT menu. Select OBJECT from the drop-down (as opposed to ‘Text from file’). Step 2 – You should see an ‘Object’…
How much CPU is my web app consuming?
Introduction When running a load test, adding IIS specific performance counters is a good idea (this post details the most important IIS and counters). However, sometimes, all you want is…
Currently executing HTTP requests in IIS
Introduction At a command prompt, use the following command to get a list of currently queued requests:> %windir%\system32\inetsrv\appcmd list requests /elapsed:1000 should produce an output like this: // hanging!…