SQL Server Performance tracking

[Skiver Veteran]

Hi Guys,

 

My company has recieved a request for some very specific statistics in which a couple I am having a bit of trouble trying to actually produce. Basically they want SQL Transaction Logs Read (MB/s) and Write (MB/s) however my usual tool for this kind of thing (Perf mon) only seems to track the amount of transactions that are going on rather than the size of each transaction.

Am I missing it in perfmon or is there a tool I may be able to use instead?

 

Thanks in advance!!

[snuffy]

Do you have your logs on a separate drive? If so, can you monitor the IO of that drive?

[Skiver Veteran]

Do you have your logs on a separate drive? If so, can you monitor the IO of that drive?

At the moment no, but its a virtual machine and I could easily add a second drive however they have specifically asked for transaction logs are there not other area's of the DB that are may be read but not cause an action on the transaction log that could invalidate the capture?

[snuffy]

it is best practice to separate the logs and database so I would think the data obtained for that drive etc should be enough.

[Skiver Veteran]

it is best practice to separate the logs and database so I would think the data obtained for that drive etc should be enough.

Unfortunately, best practice is not something we really adhere to, but thanks for the responses.