TRACEYMS


We are about to go to SQL 2005 and that means getting some new Servers and i am wondering if our SAN is adequate.

I like to measure over the next few weeks the amount of data that is sent to the SAN and how long its taking to come back....i.e if someone is running a large report how much data is sent and how long it takes to return.

This is for 2000 SQL (i like to get all these results to build my migration plan and hardware configuration).

I like to see...........18 mb of data , date time and how much read / write etc if possible the sql.

Any ideas





Re: Disk activity

lkh


The tools are:
SQL Server Profiler (search for Profiler in Books Online. There are many topics)
Performance Monitor

Also see SQL Server 2005 Books Online topics:
System Monitor Scenarios
How to: Correlate a Trace with Windows Performance Log Data (SQL Server Profiler)







Re: Disk activity

TRACEYMS

I looked at profiler but could not get the results i really wanted....

I wanted totally bytes read and write and how long it takes the san to deliver

i.e it was say a 100 mb data request ....i was trying to figure out the SAN response to this.







Re: Disk activity

lkh

Look at Performance Monitor (perfmon). It's under Administrative tools on the Start/Programs menu.

Check out the LogicalDisk and System Performance Objects and the counters in the list for each. The topics I mentioned above have some help on aligning a Profiler trace with a perfmon trace if that's useful.






Re: Disk activity

TRACEYMS

I got the following to run

Disk Write Bytes /Sec
Disk Read Bytes/Sec
Avg Disk Bytes Read
Avg Disk Bytes Write
Avg. Disk sec/Transfer
Split IO/Sec
%Disk Read Time
%Disk Write Time
Current Disk Queue Length

I think that get me in the right direction......