Re: Search Performance
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 01/30/05
- Next message: Uri Dimant: "Re: Search Performance"
- Previous message: Shabam: "Search Performance"
- In reply to: Shabam: "Search Performance"
- Next in thread: Uri Dimant: "Re: Search Performance"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 30 Jan 2005 10:39:34 -0500
As always, it depends on a number of factors. Certainly, a 50% spike is
nothing to worry about with the amount of data that you have. I'd try
generating an amount of data similar to that representative of production
and then retry your test with a load expected for production. If you are
CPU bound, then consider going to a 4 or 8 way box.
That said, there is no substitute for expertise. I'd bring in an expert for
a couple of weeks to look at your design and code, and then render an
opinion as to how to proceed.
-- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com . "Shabam" <chalupa@yomama-nospam.com> wrote in message news:1c2dnRJh5_-Qb2HcRVn-rg@adelphia.com... I have a web application coded in dotnet and ms sql server. It is a multiuser system that lets members search for other members via their profile fields. It gets complicated in that it lets users search based on distance from a zip code, as well as degree of separation. However every time I perform a search I see a spike in the cpu to about 50% (briefly) and there isn't even that many users (still testing) on the system. The way things are going I doubt it can handle more than 50 simultaneous searches, if that. The system has 4GB of ram, is running RAID 5, running dual AMD. I suspect the database design is probably not optimized, but I cannot tell since I hired programmers to code it up, and I'm not exactly a database expert. My question is, other than finding some expert to come in and help me optimize the code, what other steps are there for me to scale out the server so that searches can be handled when the userbase grows much larger? Replication and having searches load balanced? What are some of the popular and/or easier ways to do this?
- Next message: Uri Dimant: "Re: Search Performance"
- Previous message: Shabam: "Search Performance"
- In reply to: Shabam: "Search Performance"
- Next in thread: Uri Dimant: "Re: Search Performance"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
