April 14, 2003 at 11:44 pm
Hi All,
Is there any way we can check the transactions/Min or Hr or day on a specific database. I would prefer to know either from EM, QA or DBArtisan. Is there any such monitoring capability in SQL Server. I would like to give these statistics to the Business. Because few of my servers are becoming more and more busy. And I am preparing statistics for requesting Replication Server.
Please let me know.
.
April 15, 2003 at 6:48 am
You can use Windows Performance Monitor to check for example, the transactions/Sec. Add a counter, chosee the SQL Server:Databases performance object and then chosse transactions/sec.
April 15, 2003 at 8:05 am
Yes. But if I would like to have number of transactions in any day, how do we do that. I am trying to setup a table to show how many transactions occurred on a any given day. I deperately need this for the stats to support my recommendation of Replication Server. Is there a tool or a way we can do that?
I guess this might be a chance of increasing the load on the server, if we use the triggers to update the table. Is that an option?!
.
April 15, 2003 at 9:35 am
I use perfmon and the counter option. To track exactly what you are talking about. I eventually take the perfmon data and place it into SQL Server tables, so I can roll up the statistics, by day, database, or user. Of course there is a performance hit for doing this, but it lets me know which databases/users are using the most resources.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply