May 10, 2009 at 3:38 pm
As a manager of a software house I have noticed continuous complaints regarding slowness in response from reports generated from the database from our ERP business applications. I need to hire an expert to analyze our database and identify bottle necks, bad SQL, bad table design etc.
Any one who wants to offer their services please contact me via email to discuss the issue further.
Salim Bahomed
Injazat IT
Email: sbahomed@bahomed.com
May 11, 2009 at 7:34 am
Are you certain that your ERP system was designed for, or optimised for, (your particular version of) SQL? Our off-the-shelf ERP software was originally written many years ago for Unix systems, and many of the processes and reports read the tables as if they were flat files. Consequently we have ended up writing our own reports and in some cases have reduced the report processing time from 4 hours to 4 seconds.
May 11, 2009 at 9:15 am
Yes our ERP suite was developed for SQL Server, but I think the design is not optimal. Secondly, our programmers did not use indecies as much as would like them to, instead they used views. Also, I think their SQL queries can be improved for better performance. So, I concluded that an expert SQL server programmer can identify these short comings and rectify them.
May 11, 2009 at 9:47 am
Sounds like you probably will need to pay someone to have a proper look then and, unfortunately, that would not be me. The only other thing that immediately occurs to me is are you sure that it is not just a question of locking? Do you have many users acessing the same tables simultaneously? Do your queries and views specify (nolock) wherever possible? Have you used the SQL Profiler to check the efficiency of your code?
May 11, 2009 at 10:31 am
We have no problem with locking. We have used Quest Central SQL analysis tool to look at code effeciency, but not extensively as all programmers are busy. We need to pay someone to do a professional job of looking at our database tables, views, stored procedures and SQL statements to itentify problem areas. We want to improve performance. It is my gut feeling that there is a lot that can be accomplished by a SQL Server expert .
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply