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

Question

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

Paul Perez

SSC Veteran

Points: 237
More actions
October 23, 2009 at 9:22 am

#227415

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

465789psw Hall of Fame Points: 3314 More actions · Answer 1

try this

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

465789psw Hall of Fame Points: 3314 More actions · Answer 2

Try this its better yet.

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

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

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

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

support.sql Default port Points: 1444 More actions · Answer 4

If you can record your IO, CPU, Memory, etc., you can use @analyticsperformance (http://www.analyticsperformance.com/%5B/url%5D) 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[/url]

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