Transactions Per sec | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Transactions Per sec

HI ALL, what is the best way of testing as to How many TPS a SQL Server Can handle or How many Inserts can be done to a database per second. We have an environment where we just do inserts to the database during the day between 10 AM to 4 PM. Does any one has a script to check this.
Thx
Venu
http://www.tpc.org/tpcb/default.asp for information on TPC> And I haven’t seen any script to test the provcess, PROFILER and PERFMON *SYSMON) is the correct approach to assess the situation. 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.
I am not sure if there is a script available for the same howecer I believe SQL Server Magazine had launced a portal for the same. Not sure of the details though. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
How about: Performance Monitor: SQLServer Databases–>>Transactions/sec?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Transactions/Sec is not the best counter according to<a target="_blank" href=http://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp>http://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp</a> <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />—–<br />To get a feel of how busy SQL Server is, monitor the SQLServer: SQL Statistics: Batch Requests/Sec counter. This counter measures the number of batch requests that SQL Server receives per second, and generally follows in step to how busy your server’s CPUs are.<br />…<br />Some DBAs use the SQLServer<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />atabases:Transaction/Sec:_Total to measure total SQL Server activity, but this is not a good idea. Transaction/Sec only measures activity that is inside a transaction, not all activity, producing skewed results. Instead, always use the SQLServer: SQL Statistics: Batch Requests/Sec counter, which measures all SQL Server activity.<br />—–
Not quite sure, but maybe these one will help:
http://www.microsoft.com/downloads/…53-893a-4aaf-b4a6-9a8bb9669a8b&DisplayLang=en
http://www.microsoft.com/technet/archive/itsolutions/intranet/downloads/webstres.mspx
http://support.microsoft.com/default.aspx?scid=kb;EN-US;231619 FWIW ———————–
–Frank
http://www.insidesql.de
———————–
]]>