Performance Tuning your SAS Environment (Hints and Tips) Andrew - PowerPoint PPT Presentation

Performance Tuning your SAS Environment (Hints and Tips) Andrew Gadsby SAS UK Customer Loyalty Team andrew.gadsby@sas.com 07880 253 430 Note: The views of the author many not reflect those of the company.

Abstract • This session focusses on providing some guidelines on how to approach performance tuning covering both operating system and SAS options. • The information given and the hints and tips being shared are based on the my experiences in helping identify and resolve performance issues within several SAS customers in the UK.

Important DISCLAIMER • These guidelines have been developed following visits to a number of UK customers where various performance problems and have been reported and in many cases resolved following deeper investigation. During these visits a number of common patterns have emerged that SAS Administrators can, hopefully, exploit to improve and maintain performance in their environments. • This document is designed to help SAS Administrators tune their systems however, it is not a definitive reference source, for that consult www.sas.com and the various SAS conference proceedings referenced below. • Finally, as a SAS Administrator you are responsible for your SAS environments and the topics discussed should be carefully reviewed before being tested or used in a production environment as environments vary depending on specific configurations. • For assistance on tuning please in the first instance contact your normal SAS Support representative. If you have additional hints and tips that you feel SAS users could benefit from then please do let me know me on the email address below. • The views of the author many not reflect those of my employer.

For Grid Sites See Also http://api.ning.com/files/4O6eIqcn6-5EauYClb*X2Mn8YF6hlXUdHfdqciAoZOEqZgXZ*EnnLn-0eUanYHuxMJ4HKiUdtuLF5CzXofFUjxqHJ5- 2PMw4/BestPracticesforSASGridandLSFDeploymentsAndyGadsby.pdf

Business Performance • 360 Benefit Check • Free service provided by SAS • 2 weeks engagement • Output/deliverables can be shared with senior management • Identifies • Benefits recognised Jaap Piersma • Missed business opportunities Business Advisory • Recommendations for continual improvement jaap.Piersma@sas.com • SAS investing in your continual development 07918 708 938

Getting Started • What is normal? • Things to collect? • Turn on FULLSTIMER and keep it on!

Memory • MEMSIZE, SORTMEMSIZE • Buffers • BUFNO, BUFSIZE • Buffer Cache • Transparent_hugepages (LINUX only)

PROC SQL HTTP://WWW2.SAS.COM/PROCEEDINGS/SUGI30/101-30.PDF • Query Plans • proc sql _method _tree • proc sql buffersize=12345678 • Default is 64,000 rows

Views • Make extensive use of VBUFSIZE • Default is 32K • Experiment with bigger values • 1M – 200M

Metadata • Needs cleaning – regularly! http://support.sas.com/documentation/cdl/en/bisag/65422/HTML/default/viewer.htm#n1vl1pbgfeg71zn1cznorwizcg61.htm • Needs Monitoring and Tuning http://support.sas.com/documentation/cdl/en/bisag/65422/HTML/default/viewer.htm#n0sch2ahexwy7xn1n67sf998iv92.htm

Network • Network settings • Latency • Jumbo Frames • AIX : tcp_nodelayack (work in progress)

Storage • SAS Recommends 100+ Mbytes/second/core • Split Data, SASwork, Util, Input/Output, etc. • FLASH storage • SASwork

Questions THANK YOU Go and Have Fun Experimenting!