i am an IT Consultant and take up projects for my clients for setting up complete IT infrastructure. I have a client who has been facing problem with their DATABASE, he is a retail distributor for foods and has a database size of 10GB, the server is an IBM x3100 M4 Xeon Quad Core Processor 8 MB Cache, with 16 GB Ram and 300 GB SAS, OS is Windows Server 2008 Enterprise, with sql server 2005 standard. The client complaints that the whole process of billing and other activities on the DATABASE is too slow. When i check the resource monitor on server 2008 i can see that sqlserver process is hitting 70 - 80% every few seconds, memory usage is at 50 to 60% and disk usage keeps varing between 1 to 10mbps.
Any ideas, where the problem might be.