SQL Server Performance

To Increase Scalability of the database in 2005

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by Ritu, Mar 17, 2008.

  1. Ritu New Member

    Hi All,
    We have SQL Server database with 200 GB and 1000 concurrent users. We want to scale this to 4000 concurrent users.
    What should we kept in mind from the design perspective of the database.
    Regards,
  2. MohammedU New Member

  3. ghemant Moderator

  4. satya Moderator

    The above link should give you gist of what SQL Server 2005 can offer you to attain the scalability, but in the real terms it depends purely on your current system & application, not to mention about code used to access the database.
    So when you talk about scalabiltiy then 'benchmarking' it is to define the business requirements, including functional, performance, with scalability and translate them into system specs. At the same time you need to generate a workload script, accounting for user load and transactions during busy times & quiet period on the databases.
    You need this in order to stabilize the environment of and enable monitoring on monitored server, not simply documenting or defining benchmarking would do any better. For the best results you have to execute baseline test; benchmark tests scale up in phases and assess the results. If you are in doubt you could go through your Service Management team to get more information

Share This Page