Recording CPU. Disk I/I, memory to help determine SAN configuration

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Strategies » Recording CPU. Disk I/I, memory to help...

Recording CPU. Disk I/I, memory to help determine SAN configuration

Rate Topic

Display Mode

Topic Options

Author

Message

Paul Perez

Posted Friday, October 23, 2009 9:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 23, 2009 1:15 PM
Points: 7, Visits: 26

Greetings,

I have been looking for ways to record CPU and disk I/O on one of my SQL 2005 servers to determine a SAN configuration, but have not found anything concrete. I have used PerfMon but I'm not quite sure how to interpret the results I'm getting. I have also run the Glenn Berry scripts but again - not sure how to interpret the results. Any idea where I can get some clarity on all of these things or a simpler way to obtain the current CPU and disk I/O capacity or bottlenecks for my server?

thanks

For instance,
A particular data gathering from one of my servers go like this..
Cache faults/sec: 2 (with spikes on 145)
Page Faults/Sec: 5 (with spikes on 152)
Pages/sec: 0

Paginf file: 2.841

Avg. Disk Queue Length: 0 - 0.336

Processor: 1.9 - 19

Bytes Total/sec: 0

Processor queue length: 0
threads: 555

thank you

Post #807984

465789psw

Posted Thursday, November 05, 2009 1:02 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 12, 2010 8:40 AM
Points: 190, Visits: 472

try this

http://blogs.technet.com/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx

Post #814513

465789psw

Posted Thursday, November 05, 2009 1:14 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 12, 2010 8:40 AM
Points: 190, Visits: 472

Try this its better yet.

http://www.sql-server-performance.com/articles/audit/hardware_bottlenecks_p1.aspx

Post #814524

ALZDBA

Posted Friday, November 20, 2009 12:43 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:28 AM
Points: 4,977, Visits: 3,926

IMO these are very interesting articles on this Disk related subject ...

- Playing with Disk Alignment
http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/11/19/playing-with-disk-alignment.aspx

- SAN Performance Tuning with SQLIO
http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

Very usefull HowTo for forums:
- How to post Performance Problems
- How to post data/code to get the best help

Post #822128

support.sql

Posted Sunday, November 29, 2009 12:57 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, December 02, 2009 2:07 PM
Points: 70, Visits: 32

If you can record your IO, CPU, Memory, etc., you can use @analyticsperformance (http://www.analyticsperformance.com/) and get amazing information to analyze different IO configurations and get metrics about them.

If you want to simulate the IO load use IO Stress

http://support.microsoft.com/kb/231619

SNM

Try Free Microsoft SQL Server Data Collector & Performance Monitor.

http://www.analyticsperformance.com

@nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

Post #825905

« Prev Topic | Next Topic »

Permissions