Improving,SQL,Performance,How, computer Improving SQL Performance
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
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 youre running your typical processes and work loads during the monitoring. Dont 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. Dont 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 cant 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
Improving,SQL,Performance,How,