November 24, 2003 at 8:43 am
What is the maximum transactions that are supported by SQL Server, provided with good hardware/Software support?
Currently single CPU of 1.8GHz is installed with a 512MB of RAM on Windows 200 Advance Server. I have to identify, whether my Real-Time application support multiple insertion queries that are executing at a frequency 1 Transaction/Second. And also multiple select queries are running parallel to these insertions. Please help me out if this configuration will be OKEY for the kind of Application.
Thanking in Advance.
- Rattu
November 24, 2003 at 8:47 am
http://www.sql-server-performance.com/ultimate_sql_server.asp
Don't know much about hardware, but you should spent this box more RAM.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 24, 2003 at 8:52 am
The best way is to test with your data and environment. There are too many variables to answer a question like this in an online forum.
quote:
Don't know much about hardware, but you should spent this box more RAM.
What if the database size is only 100MB?
--Jonathan
Edited by - Jonathan on 11/24/2003 08:57:11 AM
--Jonathan
November 24, 2003 at 8:55 am
Thanks Frank, but I need information about what actually is the capacity of SQL Server to manage insert and select queries simultaneously...
looking for reply
- Rattu
November 24, 2003 at 8:58 am
Like Jonathan said, stress your server with a test scenario and choose the scenario that you would consider worst case.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 24, 2003 at 8:59 am
I am currently planning for deploying SQL Server at client. There is no historical data available. So, everything is at conceptual level, as you know planning is the formost thing before deploying 😉
- Rattu
November 24, 2003 at 9:00 am
quote:
quote:
Don't know much about hardware, but you should spent this box more RAM.What if the database size is only 100MB?
--Jonathan
Edited by - Jonathan on 11/24/2003 08:57:11 AM
Interesting, lots of resources...
So we should put on IIS and make it a PDC
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 24, 2003 at 10:15 pm
Frank --- this not funny ...
- Rattu
November 25, 2003 at 12:07 am
I think Frank was very funny.
You'd be better off asking how long is a piece of string - but REALLY it should have more ram no matter what other hardware is in there.
Please do not poke the DBA
The systems fine with no users loggged in. Can we keep it that way ?br>
November 25, 2003 at 12:56 am
quote:
Frank --- this not funny ...
Sorry, I didn't want to annoy you !!!
Basically I was joking on Jonathan's reply.
Now seriously, put up a test scenario. There should be tools that will you on this around.
And do plan and develop for peak usage.
You write that you have a frequency of 1 transaction per second. ...on average?
It should be a huge difference if it is really one transaction per second equally spread over the whole day or 86,400 at once (which is also 1 transaction per second on average).
Also it depends on the kind of transactions your application does.
If you're still uncertain, you should consider asking some consultant in your area. Like Jonathan said there are too many variables involved so that any concrete advice would be like a shot in the dark.
And, once again, sorry if you felt offended!
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 25, 2003 at 2:23 am
no Frank I wasn't annoyed ... well I am confused with another problem now 🙁 for this one, I have tested a little and now I think that the load will not exceed hardware availability ... and I am confident that I can now safely design it ... thanks for your help ... thanks everyone.
The other problem now i am facing is in regard of backups ... please help me out ... i cannot find a way to restore some previously backup data along the new changed database. Can you please suggest me if there is any option to accomplish this?
Edited by - rattu on 11/25/2003 02:33:40 AM
- Rattu
November 25, 2003 at 2:53 am
Start a new thread so more people will be aware of the new subject line.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 25, 2003 at 2:54 am
Oh, well, you've already done this ...
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply