November 26, 2008 at 11:09 am
if anyone knows of a counter that measures inserts/updates per second or something similar it would be very helpful to me.
our database inserts on a constant basis, and if we stop inserting, it is very probably that there is an issue with either the server or one of the other servers. Anyone have any metrics that can check on this? Again, I don't care so much about reads, I need writes.
December 11, 2008 at 10:17 pm
Personally, I've used SQL Profiler and output the results to a table.
At that point, I can dig into the results and massage them to find out that kind of info.
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
December 12, 2008 at 7:14 am
I think the closest counter to what you want in transactions per second.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 12, 2008 at 7:49 am
But does the SQLServer:Databases Performance Object..Transactions/Sec Counter tell you whether it's a read or a write or just a transaction?
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
December 12, 2008 at 11:24 am
Jason Crider (12/12/2008)
But does the SQLServer:Databases Performance Object..Transactions/Sec Counter tell you whether it's a read or a write or just a transaction?
I think it is reads and writes, but like I said, I think it is the closest counter you will find. Certainly you're idea of using Profiler or a server-side trace could be more accurate for just updates/inserts/deletes.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply