July 21, 2006 at 8:54 am
Hi!
What is the best way to get an info about what is
the MAX # of transactions per second, on my sql server on
my particular system with my raid config, memory etc.. ?
thank you
July 21, 2006 at 9:05 am
When you say MAX, are you looking to find out the maximum number of transactions your SQL Server handled per second over a given period of time, or are you looking for the maximum throughput that your server can handle?
The best way, in my opinion, to get the maximum transactions per second over a period of time is to run Windows Performance Monitor and monitor the SQL Server: Databases>>Transactions/sec counter. You can then use the data samples to determine the maximum transactions/sec.
If you are wanting to determine what your server's threashhold for transactions/sec, you will need to find/create some sort of load testing tool that will put load on your server
July 21, 2006 at 9:24 am
yes sir, that is exactly what i meant, the server's treashhold for transactions/sec, to see in what shape my database or server is, in this particular moment.
we have VERY production environment and i have very smale window for maintenance during the week, so i just need to see if the number of transactions/sec is deteriorating and how bad the difference is between monday and friday.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply