Max number records SQL Server process in second | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Max number records SQL Server process in second


Our server is Windows 2003 SP1, 4 X 2.7 GHz Intel Xeon Processors,
16 GB SDRAM, Hard drive 4 X 72 GB 15K SCSI, and
SCSI HP Smart Array 6400 Controller. Is there a maximum number of records SQL Server can process in a second? I have been asked to… 1) define a performance target that is within SQL
Server capabilities (we’re batch processing) 2) determine how many records CIMS (our database and
a C# program doing bacth processing) should be able to
process per second 3) determine if SQL Server can meet the potential
CIMS demand I have to determine the amounts above. We have a C#
program that is pulling a file from an ftp site,
parsing it, and then calling a web interface(SCS)
one at at time for information on a person, then
calling an internal table (4,150,550 records) for
detail info, then calling another internal table which
can result in multiple calls to the table(4,152,696
records), then another call to the same web interface
which can be multiple calls . The web interface
(SCS) call is taking anywhere from .002 seconds to 3
seconds depending on network traffic. The other calls
(Compliance) are performed one after another and their
time all together is currently less than 1 second.
However, the time can be longer depending on the SCIMS
call. We are being asked to at least perform 55 Compliance
calls a second. Does this sound feasible?
Andy
I have a similar setup and am getting very good performance while averaging 1000 transactions/second
Is it a SQL enterprise edition?
How about memory settings on SQL Server?
Hope there areno other applications sharing the sQL server resources. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Yes, it is enterprise edition. We have two databases that this process is using and they are both currently configured to dynamically use a minimum of 3 GB and a max of 6 GB. We are also having to run our C# program on the same server, but supposedly the program will share 4 GB with the OS. Andy
Have you captured the PERFMON (SYSMON) counters for further assessment during the insert process. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Yes, I ran performance monitor while the entire process was running. I’m not sure if I had the correct counters selected though. Can you tell me some counters that might be good to use? I’m still very new to SQL Server. Andy
http://www.sql-server-performance.com/performance_monitor_tips.asp
http://www.sql-server-performance.com/performance_monitor_counters.asp
http://www.sql-server-performance.com/performance_monitor_counters_io.asp
http://www.sql-server-performance.com/performance_monitor_counters_memory.asp
http://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp Fyi. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Satya,
Thank you. I will take a look at these sites. Andy
]]>