Problem solve Get help with specific problems with your technologies, process and projects.

Getting I/O stats

We are trying to capture I/O for SQL Server databases as a way to charge internal customer groups for database usage. We are interested in bufferpool logical data I/O, data writes, logical index I/O and index writes.

These four items will be added together, and we don't need to identify any of the components individually. We don't have any need to measure physical I/O, but if it is part of an overall measurement we will take it. We want to avoid asynchronous I/O if at all possible. Ideally we would like to also include any reads or writes that bypass the bufferpool completely. I believe loads bypass the bufferpool.

We can't seem to find this information at the database level. I successfully set up these measurements on DB2, but I can't seem to do it in SQL Server. I can't even figure out where to start! Is this even possible?

You can gather I/O stats via Performance Monitor and also via Profiler.


For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.