Showing posts with label: Database

After spending a lot of time focusing on Client-Side Web 2.0 Performance Problems it is time to focus on specific Server-Side Performance Problems. Last week I worked with a client that runs a custom application on Microsoft CRM 4.0 and experienced performance problems in their test environment. Individual web requests to query or update data [...]

An Oracle database provides several v$ views to query information about the database instance, including statistical information that can be used for monitoring and problem analysis purposes. Rene Nyffenegger wrote a nice Summary on Oracle’s v$ views that gives an overview of all available views.
The following illustration shows [...]

Every time I work with one of our .NET customers to help them with managing their application performance I come across the same problems as seen with other clients before: lots of ADO.NET queries, many hidden exceptions in core or 3rd party .NET libraries, slow 3rd party components, inefficient custom code, …
Too often we from [...]

I recently gave a talks on the behaviour of different JPA frameworks at W-JAX(Germany) and TheServerSide Java Symposium (Prague). As some people have asked me, I am publishing the samples as well. I would also give away the eclipse project, however with all the third party libraries I am sure I will end up not [...]

Last year at devoxx I gave a talk on common pitfalls in performance management. Parleys has now put the talk online. A couple of people have been asking to get slides. Now you can even get the voice and the slides. In this presentation I give an overview of typical performance antipatterns. I discuss conceptual, [...]

Many of you bloggers out there have already covered the fact that Stored Procedures should be used for INSERTS, UPDATES and DELETES or in general when modifying multiple rows in a batch like statement. I also came across other blogs that discussed deleting or updated multiple entities with the standard interfaces of Linq2Sql – not [...]

I’ve started to look closer at the ADO.NET Entity Framework that ships with .NET 3.5 SP1. There are some interesting blogs from the ADO.NET Product Team that you should read. I started with a sample database that contains a simple Address table. I created an Entity Model that automatically created my ObjectContext, my Entity Classes and [...]

Starting with SQL Server 2005 a database developer has the option to implement Stored Procedures in Managed Code. SQL Server offers a feature which is called “CLR Integration”. A good starting point for additional technical background is the following link: http://msdn.microsoft.com/en-us/library/k2e1fb36(VS.80).aspx
This feature is a great improvment for database developers. Its also possible to debug the [...]