July 17, 2001 at 11:57 am
I need to be able to gather generic information regarding I/O. I want to know the number of reads & writes by database/table that occur on the SQL Server.
When I need to trouble-shoot the system, I can then in turn compare the I/O table read/writes with information from Perfmon to figure out which tables are the hot spots of the application.
This information could be used to create different drive arrays, and place tables into new filegroups pointing to these arrays.
Another benefit would trend analyses by database/table for historical gathering.
July 17, 2001 at 12:39 pm
Try
set statistics io on
You will have to somehow capture and parse this information as it is a print output. In QA , check the Messages tab.
Steve Jones
July 22, 2001 at 7:21 am
Give the product SQL*Probe a go. Not too bad and may give what you want at a high level. Ive been onto them and have asked for more detailed information and read/write stats at a file-group and then object level. The company is subquery innovations.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply