• 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.