CATEGORIES Auto & Trucks Business & Finance Computers & Internet Education Family Food & Drink Gadgets and Gizmos Health Hobbies Home Improvement Humor Kids & Teens Legal Marketing Men Music and Movies Online Business Parenting Pets and Animals Politics and Government Recreation & Sports Relationships Religion and Faith Self Improvement Site Promotion Travel & Leisure Web Development Women Writing Keyword Search Article Title Author's Name SITE MENU Search Submit An Article Submit Articles in Bulk Submit Press Release Syndicate Articles Distribute Articles Privacy Policy Terms of Use Link To Us Contact Us Site Map Home

Improving SQL Performance  by: Marisa Pellegrino How do you know how much hardware is really needed by your applications? And what do you do when your applications are overloading your system? The answer lies with improving your SQL performance. You have to tune your hardware SQL server and monitor performance, all of which will be explained as clearly as possible on this page. The first thing to do when you want to improve your SQL performance is you need to learn how to optimize your system by finding out how much hardware you really need to run your applications. The best way to tune your hardware and monitor performance is through the art of performance monitoring which takes experience, knowledge, and sometimes even luck. Performance monitoring guidelines: Make sure you’re running your typical processes and work loads during the monitoring. Don’t only do a real-time monitoring of your servers; capture long running logs. Always have the disk counters turned ON. Set up the chart windows with an interval of 18 seconds for routine, daily desktop monitoring. Know the tools you are working with. Don’t be afraid to experiment. Know the terminology (“objects” are lists of individual stats available; “counter” is a single stat; “instance” is further breakdown of a counter stat into duplicate components). A bottleneck happens when the hardware resources can’t keep up with the demands of the software. This is usually fixed in one of two ways: first, you identify the limiting hardware and increase its potential (i.e. a faster hard drive or increase the speed of the computer); second, make the software processes use the hardware more efficiently. Five areas to watch when improving SQL performance and identifying bottlenecks: Memory usage CPU processor utilization Disk input/output performance User connections Blocking locks About The Author Marisa Pellegrino is a freelance writer from Montreal and is the head researcher and content manager for www.sql-recovery.com. info@sql-recovery.com This article was posted on December 24, 2004 Read More Articles from the "Computers and Internet" Category: 5 Basic Rules on Typography by Granny's Mettle Paypal Users: Don't Get Caught By Phishers by Rose DesRochers Tools for Customizing Great Plains by Divine Rigor Protecting Your Profits on Pay-Per-Click Engines by Catherine Seda Become a More Creative Person by Granny’s Mettle E-Commerce Strategy Development - Online Music Case Study by Sam Harnett Autoresponders: Laying The Groundwork by Scott Lindsay Creating the Right Skin Texture by Ma. Carla Balattan How To Add Dynamically Generated Graphs And Charts To Web Pages And Applications by Patrick OBrien Cisco Certification: Debug and Show commands for ISDN by Chris Bryant << Back to "Computers And Internet" Index

Disclaimer: The information presented and opinions expressed herein are those of the authors
and do not necessarily represent the views of ArticleCity.com and/or its partners.

	Web www.articlecity.com