Database Performance & Optimization
Off late I was thinking about some of the services that we can render from eXzaTech on the data & information management solutions and I suddenly remembered two interesting situations I handled sometime (of course quite long ago) back. I thought I should share them with you. Hence this article.
In the first, it was more to do with complaints from a software development company on the performance of Microsoft SQL Server 2005 Enterprise Edition on a server with Intel Itanium Processor. Software developers were complaining that SQL Server is not performing well on Itanium Processor and they were benchmarking the performance against Intel Xeon processor based server without emphasizing the fact that they were not comparing apple to apple. In their labs they were using Intel Xeon based servers with low volume test data whereas the production server was handling the very high volume, live production data of an international shipping company. Although Itanium Processor lost out to Xeon for various reasons over a period of time, I never believed that Itanium processors were such poor performers as against Xeon 64 Bit processors. This was a typical case of Software vendor blaming hardware and hardware vendor blaming software for poor performance.
The architecture was very complex. Those details are not relevant here.
- to move the analysis & reporting workload out of the live production instance in to a different database and conduct ETL activities during off peak hours and
- optimize the queries, create indexes
- avoid changing the database structure often d) use different integration methodologies to integrate other applications