September 16, 2005 at 10:46 pm
First off, I would like to state I am not a DBA of any kind. I am a storage engineer. One item that I have attempted to put in my bag of tricks is to learn how to gather performance data from within MS SQL. I would like to know:
Does MSSQL have the ability to report the IOpS for a particular database, and then also be able to report on the throughput during the transactions/IOs?
I can gather the statistics of a logical and physical disk using tools like perfmon. I would like to know what SQL can report, if anything.
September 20, 2005 at 7:29 am
Maybe not exactly what you want, In sql server the function ::fn_virtualfilestats and tables master.dbo.spt_monitor,
master.dbo.sysperfinfo can provide IO activity infromation and other performance counter.
September 22, 2005 at 8:57 am
This may not be exactly what you are looking for, but hopefully it will help.
Using "perfmon" you can add counters for individual databases as well as the underlying disk that your databases live on.
SQLServer:databases:Transactions/Sec (select whichever DBs you want to monitor)
PhysicalDisk:diskTransfers/Sec, DiskReadBytes/Sec, DiskWriteBytes/Sec (for the HDD that the database is sitting on).
Enjoy.
September 22, 2005 at 9:59 am
I will check out the suggestions. Thank you.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply