idle configuration for 1000-1200 concurent users

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » idle configuration for 1000-1200 concurent...

idle configuration for 1000-1200 concurent users

Rate Topic

Display Mode

Topic Options

Author

Message

KcV

Posted Monday, August 27, 2012 3:21 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 31, 2013 6:25 AM
Points: 56, Visits: 152

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

KcV

Posted Wednesday, September 05, 2012 4:36 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 31, 2013 6:25 AM
Points: 56, Visits: 152

pls

Post #1354429

derek.colley

Posted Wednesday, September 05, 2012 5:20 AM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 3:41 AM
Points: 496, Visits: 587

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 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 »

Permissions