Performance Question about SQL 2005
-
I got a requirement for a buisness web application that will handle 100 concurrent users requests. we designed our data tire. we will use SQl server 2005 and we will use OLAP services. the question is how can we determinate the best physical hardware requirment for database server. i mean we need to know min phyiscal memory size , processing power. for the server that will be managed by windows 2003 server OS. known that the client wants max page loading duration on max load(100 concurent users) is 8 seconds. Note: 1-we did tried to set up server with 2 giga ram, and dual core processor. on first 30 concurent users it was ok. after user 50. the processor,memory utilization is 100% and things got worse . over 60 seconds per page 2- we use tool to test performance that simulate 100 users request the application every second.:confused:
marcoryos
-
I got a requirement for a buisness web application that will handle 100 concurrent users requests. we designed our data tire. we will use SQl server 2005 and we will use OLAP services. the question is how can we determinate the best physical hardware requirment for database server. i mean we need to know min phyiscal memory size , processing power. for the server that will be managed by windows 2003 server OS. known that the client wants max page loading duration on max load(100 concurent users) is 8 seconds. Note: 1-we did tried to set up server with 2 giga ram, and dual core processor. on first 30 concurent users it was ok. after user 50. the processor,memory utilization is 100% and things got worse . over 60 seconds per page 2- we use tool to test performance that simulate 100 users request the application every second.:confused:
marcoryos
-
I got a requirement for a buisness web application that will handle 100 concurrent users requests. we designed our data tire. we will use SQl server 2005 and we will use OLAP services. the question is how can we determinate the best physical hardware requirment for database server. i mean we need to know min phyiscal memory size , processing power. for the server that will be managed by windows 2003 server OS. known that the client wants max page loading duration on max load(100 concurent users) is 8 seconds. Note: 1-we did tried to set up server with 2 giga ram, and dual core processor. on first 30 concurent users it was ok. after user 50. the processor,memory utilization is 100% and things got worse . over 60 seconds per page 2- we use tool to test performance that simulate 100 users request the application every second.:confused:
marcoryos
Remove OLAP services into another DB that is not on your OLTP db. Reporting cripples OLTP databases. I can squeeze 100 users onto an ASP.NET/SQL Express Business Application using a shared VM with good design techniques so if your dedicated server is not fast enough consider looking at the system architecture. Good design scales a lot faster than hardware upgrades.
Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
If you don't ask questions the answers won't stand in your way.
Most of this sig is for Google, not ego. -
I got a requirement for a buisness web application that will handle 100 concurrent users requests. we designed our data tire. we will use SQl server 2005 and we will use OLAP services. the question is how can we determinate the best physical hardware requirment for database server. i mean we need to know min phyiscal memory size , processing power. for the server that will be managed by windows 2003 server OS. known that the client wants max page loading duration on max load(100 concurent users) is 8 seconds. Note: 1-we did tried to set up server with 2 giga ram, and dual core processor. on first 30 concurent users it was ok. after user 50. the processor,memory utilization is 100% and things got worse . over 60 seconds per page 2- we use tool to test performance that simulate 100 users request the application every second.:confused:
marcoryos
Most likely the problem is in the overhead that OLAP services cause. The main target for OLAP services is reporting, not transaction handling. Instead of OLAP use the OLTP engine of SQL Server in other words the normal SQL Server engine and design the relational model so that it supports continuous data manipulation and retrieval.
The need to optimize rises from a bad design.My articles[^]
-
Most likely the problem is in the overhead that OLAP services cause. The main target for OLAP services is reporting, not transaction handling. Instead of OLAP use the OLTP engine of SQL Server in other words the normal SQL Server engine and design the relational model so that it supports continuous data manipulation and retrieval.
The need to optimize rises from a bad design.My articles[^]
-
Thanks alot for replies, so far i got that we should take alook at our design again, and try to seperate db engieen and OLAP to be in two servers instead of one, :) Am i correct?
marcoryos