December 27, 2012 at 6:03 pm
Dear all,
I am looking after a web site that is struggling with volume at peak times.
We are hitting 100% CPU for long periods with the system obviously struggling to cope.
To the point of some requests timing out.
I am now trying to tune requests that don't seem so bad at all that I wonder whether we should really send so many requests to the server at all... (more caching on the web front-ends, maybe).
At peak time, it looks like we were firing above 3000 batch requests per second.
Does this sound too much to you?
I realise it might depends on the hardware...
Our database server had 12 dual core CPUs with 36Gbs memory.
Still, 3000 requests per second seems a lot to me...
Thanks
Eric :sick:
December 28, 2012 at 9:10 am
As Amazon if 3k requests per second is too much. 😀
There are way too many factors and too little information for anybody to be able to give you an answer.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 28, 2012 at 10:57 am
I am not surprised you answer that... but it's a bit difficult to give more details precisely because there might be so many factors.
Today we ran some tests that (so far) seem to indicate that this number might be ok in our context.
We had over 2000 requests per second and only 40% CPU usage on a "much lower spec" server (which seems a lot faster!)
Sorry for asking a dumb question and thanks for taking the time to comment anyway.
Eric 🙂
December 28, 2012 at 12:15 pm
It was by no means a dumb question!!! It is just hard to provide much help because of so many unknowns. I wouldn't begin to know how you could scratch the surface on posting enough details through a forum. Hope you get it all sorted out.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply