Post reply

idle configuration for 1000-1200 concurent users

  • August 27, 2012 at 3:21 am

    #280162

    Hi,

    i want to set up a database server in my company for 1000-1200 concurrent users.

    so i want to know that :

    what is the idle database server's hardware configuration (CPU,RAM,Hard disk,partitions,free space etc.) for 1000-1200 concurrent users in sql 2005 ?

    so i can report to my superiors to make it available.

    awaits for your expert advice.

  • September 5, 2012 at 4:36 am

    #1533716

    pls

  • September 5, 2012 at 5:20 am

    #1533724

    1000-1200 concurrent users doing what? I'm afraid there is no way to answer this question. You need to go back to your boss and find out a LOT more information. What are the servers going to do? What sort of transactional load are you facing? What's the expected data load - how much new data do you expect every day, every week? What's your budget? Is failover important? How critical is the data? What are the security requirements?

    Find out from your app developers and your boss what it is they actually want, before you try and work out what it is you need.

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply