|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to Measure TPM Tool?Does anyone know of a tool or utility that you can run against a sql 2005
server that will measure the transactions per minute on a server. Hello,
You can use the perfmon which is coming along with Windows operating systems to see the Transactions per second. - Go into perfmon -- Add the counter -- select SQL server:Databases -- Choose the database and select Transactions/Second Thanks Hari Show quote "Thomas H. Maine" <ThomasHMa***@discussions.microsoft.com> wrote in message news:06BDC48B-3B47-498E-BFE4-7D6587431B5B@microsoft.com... > Does anyone know of a tool or utility that you can run against a sql 2005 > server that will measure the transactions per minute on a server. Thanks for the response,
i was actually looking to find the transactions per minute for the server to see how many the server can hold, before perfomance starts getting affected. thanks thomas Show quote "Hari Prasad" wrote: > Hello, > > You can use the perfmon which is coming along with Windows operating systems > to see the Transactions per second. > > - Go into perfmon > -- Add the counter > -- select SQL server:Databases > -- Choose the database and select Transactions/Second > > Thanks > Hari > > > "Thomas H. Maine" <ThomasHMa***@discussions.microsoft.com> wrote in message > news:06BDC48B-3B47-498E-BFE4-7D6587431B5B@microsoft.com... > > Does anyone know of a tool or utility that you can run against a sql 2005 > > server that will measure the transactions per minute on a server. > > > In perfmon, when you select the instances, you can select
All for all databases instead of just a specific database. -Sue On Fri, 23 Mar 2007 05:37:08 -0700, Thomas H. Maine <ThomasHMa***@discussions.microsoft.com> wrote: Show quote >Thanks for the response, > >i was actually looking to find the transactions per minute for the server to >see how many the server can hold, before perfomance starts getting affected. > >thanks > >thomas > >"Hari Prasad" wrote: > >> Hello, >> >> You can use the perfmon which is coming along with Windows operating systems >> to see the Transactions per second. >> >> - Go into perfmon >> -- Add the counter >> -- select SQL server:Databases >> -- Choose the database and select Transactions/Second >> >> Thanks >> Hari >> >> >> "Thomas H. Maine" <ThomasHMa***@discussions.microsoft.com> wrote in message >> news:06BDC48B-3B47-498E-BFE4-7D6587431B5B@microsoft.com... >> > Does anyone know of a tool or utility that you can run against a sql 2005 >> > server that will measure the transactions per minute on a server. >> >> >> Load testing with YOUR data/applications would be VERY difficult without
some automated (and expensive) tool. I do believe you can download a workable TPC.org-compliant load testing suite from the web that will function in a Microsoft/SQL Server environment. It is still pretty complex, but I have done it before some time ago. -- Show quoteTheSQLGuru President Indicium Resources, Inc. "Thomas H. Maine" <ThomasHMa***@discussions.microsoft.com> wrote in message news:5F1D9E24-A0B2-4647-B20F-26C1BD5CCA2F@microsoft.com... > Thanks for the response, > > i was actually looking to find the transactions per minute for the server > to > see how many the server can hold, before perfomance starts getting > affected. > > thanks > > thomas > > "Hari Prasad" wrote: > >> Hello, >> >> You can use the perfmon which is coming along with Windows operating >> systems >> to see the Transactions per second. >> >> - Go into perfmon >> -- Add the counter >> -- select SQL server:Databases >> -- Choose the database and select Transactions/Second >> >> Thanks >> Hari >> >> >> "Thomas H. Maine" <ThomasHMa***@discussions.microsoft.com> wrote in >> message >> news:06BDC48B-3B47-498E-BFE4-7D6587431B5B@microsoft.com... >> > Does anyone know of a tool or utility that you can run against a sql >> > 2005 >> > server that will measure the transactions per minute on a server. >> >> >>  |
|||||||||||||||||||||||
Other interesting topics