Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

idle configuration for 1000-1200 concurent users Expand / Collapse
Author
Message
Posted Monday, August 27, 2012 3:21 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 12:36 AM
Points: 65, Visits: 205
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.
Post #1350279
Posted Wednesday, September 5, 2012 4:36 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 12:36 AM
Points: 65, Visits: 205
pls
Post #1354429
Posted Wednesday, September 5, 2012 5:20 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 22, 2013 9:13 AM
Points: 496, Visits: 601
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??!

Want to get the best help? Click here http://www.sqlservercentral.com/articles/Best+Practices/61537/ (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.
Post #1354438
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse