|
|
|
10 PROVEN TIPS TO SURVIVE A COMPUTER CRASH
10 PROVEN TIPS TO SURVIVE A COMPUTER CRASH By Eve Abbott, excerpted from her new book, How to Do Space Age Work with a Stone Age Brain TM COMPUTER CRASH Do these words strike fear into you? If not, maybe they should! A computer crash is at best...
Great Plains Accounting Support – overview for IT specialist
Great Plains Accounting was popular accounting package for mid-size and small companies back in 1990th. As each product has its life time – it is almost over for Great Plains Accounting – Great Plains Software was purchased by Microsoft and...
How Safe is Your Success? Part 5 of 8
"How Safe is Your Success" is a series of eight articles that address different aspects of a universal problem which is of particular importance to those who do business on-line. Most Internet users are at least aware there are dangers "out there",...
Need a Copy of Your Tax Return Information?
Taxpayers have two easy and convenient options for getting copies of their federal tax return information — tax return transcripts and tax account transcripts — by phone or by mail. A tax return transcript shows most line items from the tax return...
Online Investing and Trading discussions at www.streetplayer.com
The new investment forum, www.streetplayer.com is back. streetplayer.com is an investment information site for those interested in using Internet to obtain information about stocks and other securities. Our plan is to build comprehensive database of...
|
|
| |
|
|
|
|
|
|
Improving SQL Performance
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
Associated Websites
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 SQL Server Database Recovery. www.sql-recovery.com
|
|
|
|
|
|