Re: Performance

From: Ray (someone_at_nowhere.com)
Date: 03/14/05 

Date: Mon, 14 Mar 2005 12:18:05 GMT

If we are to assume that the code and DB model are optimal, and that we
should focus on answering your question only. Your specific question is how
does SQL scale OUT an OLTP. Scale out is generally a matter of adding more
SQL servers and distributing (usually via code but distributed partitions is
also an option) your database and/or functions across them. Sounds like
your asking about creating a reporting ODS to pull the searches off to
another server. By focusing only on scale out solutions you are confining
the answers to expensive solutions.

Lets start with the basics.
What other applications are running on the server if any?
Is this SQL 2000?
Is this SQL Standard or Enterprise edition?
What's driving your high CPU?
    How many recompiles and procedure cache misses are occurring?
    Does your code have an abundance of non set oriented logic?
Is this code owned by someone else and you don't have the right to change
it?

The more information you can provide the better advice the group can give.

Ray

"Shabam" <chalupa@yomama-nospam.com> wrote in message
news:2dadnQoD5ty8u6jfRVn-3A@adelphia.com...
>I have an application that allows for searches, but it appears when I
>stress
> test it with 50+ users the CPU utilization on the MS SQL server machine is
> hitting 100%. The machine is on RAID SCSI, running on 4GB of memory and
> dual AMD Opteron cpu's. I can get a more powerful machine, but not sure
> if
> that is the solution here.
>
> What are some methods to scale this thing out? Replicate the database and
> spread out the searches to multiple identical databases?
>
>

Relevant Pages

  • Re: Clustering for Performance
    ... I second what Andrew said. ... scale up to almost any real-world database problem. ... There is nothing worse than a brand new database system that is ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Problems connecting to SQL-Server
    ... Where do i "click" to grant access with a login in SQL Servers? ... >>Our app uses ADO.NET and the database is MS SQL Server. ...
    (microsoft.public.sqlserver.connect)
  • Find my database
    ... I'm Writing a small wizard to lead users through connecting my client ... I've found some code that enumerates all available MS SQL Servers, ... the database is actually the one I want them connecting to. ... Is there a way with MS SQL to request a list the tables in the database? ...
    (borland.public.delphi.database.ado)
  • Re: Copy database from 2005 to 2000
    ... Are you able to connect to both SQL Servers using SSMS from one ... But the issue is you can not copy a database from SQL 2005 to SQL 2000 due ... When I am going thru a database copy wizard ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL server 2005
    ... Can I copy the database from sql2000 to sql 2005 and work like before. ... Or I have to have both SQL servers installed? ... > Developer Edition). ...
    (microsoft.public.sqlserver.programming)